Oracle

May 2007

Scripts
(31 May 2007 20:30:45)
Export Import question
(31 May 2007 20:27:55)
MSSQL DTS executing an external app
(31 May 2007 18:31:56)
from existing schema to new schema
(31 May 2007 16:24:31)
Oracle version 10.2.0.3
(31 May 2007 15:5:13)
Ora service user
(31 May 2007 14:48:42)
T.D.E in Oracle 10g
(31 May 2007 14:43:52)
Determine Disk Space used by tables
(31 May 2007 14:24:25)
NOLOGGING at Table level
(31 May 2007 13:37:30)
Specific permission/privilege to create a pfile from an SPFile
(31 May 2007 12:52:30)
dbms_stats in 10G
(31 May 2007 11:44:40)
create objects with constraints
(31 May 2007 11:13:23)
nulls with objecs and nested tables
(31 May 2007 9:29:55)
Réf. : RE: move tables to new tablespace.
(31 May 2007 8:49:56)
Import Problem
(31 May 2007 6:22:23)
how to retrieve sys password
(31 May 2007 6:17:49)
RMAN could not access datafile
(30 May 2007 21:58:27)
Data File missing.
(30 May 2007 18:31:32)
File permissions
(30 May 2007 17:55:18)
collecting statistics
(30 May 2007 17:53:31)
sql help
(30 May 2007 17:18:31)
Re: Tables
(30 May 2007 13:5:10)
Error in Flashback
(30 May 2007 12:55:33)
move tables to new tablespace.
(30 May 2007 12:20:36)
can ui alter objects
(30 May 2007 10:15:39)
all privileges to user
(30 May 2007 9:39:51)
wait event: "enq: HV - contention" WHAT IS IT?
(30 May 2007 9:39:50)
DBa Interview Questions
(30 May 2007 6:41:12)
Restore Database to Another Machine
(30 May 2007 4:26:42)
RMAN help
(30 May 2007 0:36:20)
Re: DBA Interview Questions part 1
(29 May 2007 23:54:1)
Re: unable to extend index PK_DTL_IX by 2048 in tablespace EPICIXLARGE
(29 May 2007 23:52:27)
Import/Export error
(29 May 2007 22:33:55)
Cluster Wait Time ??
(29 May 2007 18:50:19)
backing up DBs with OEM
(29 May 2007 14:42:39)
Re: DBA Interview Questions Part 3
(29 May 2007 14:39:16)
Re: {Spam?} hoe to Migrate standard to enterprise edition in ora cle9i
(29 May 2007 14:35:3)
Re: DBA Interview Questions Part 2
(29 May 2007 13:22:1)
Oracle Constraints
(29 May 2007 12:22:52)
Re: bad bind variable
(29 May 2007 9:27:44)
Re: To create database for backup restoration purpose
(29 May 2007 9:20:16)
How to include alter system command in PL/SQL
(29 May 2007 9:10:58)
migrating from oracle 9i to 10G on Unix
(29 May 2007 8:40:43)
Re: Database administration
(29 May 2007 6:49:43)
A procedure not getting executed
(29 May 2007 6:48:2)
FMR-92120 Registry.dat is missing
(29 May 2007 6:19:28)
Urgent Help !!!
(28 May 2007 16:57:24)
ORA-01502
(28 May 2007 14:44:14)
how to find Logon time of a user
(28 May 2007 6:3:21)
I have a 9iRelease 2 database Export Dump Can I create a database from thisin another 9i Release 2 Database
(27 May 2007 21:2:41)
hoe to Migrate standard to enterprise edition in oracle9i
(27 May 2007 20:43:37)
UNUSABLE INDEXES
(27 May 2007 11:43:59)
Cannot open standby database in read only
(27 May 2007 10:35:0)
NLS Problem
(27 May 2007 9:7:24)
LISTOWNER- EMAIL SHIELDING
(26 May 2007 13:0:2)
Cannot commit inside trigger
(25 May 2007 23:5:53)
cannot open db
(25 May 2007 21:48:51)
application tuning
(25 May 2007 19:2:29)
How to get a general total?
(25 May 2007 18:40:16)
how to recover database using binary(encrypted) backup controlfile...
(25 May 2007 14:24:14)
DB isn't connecting !!!
(25 May 2007 14:18:40)
execute function
(25 May 2007 14:11:41)
execute function question.
(25 May 2007 14:11:20)
Truncating table inside trigger
(25 May 2007 13:16:56)
Returning the last 200 records
(25 May 2007 13:7:48)
Shutdown Scripts for Linux
(25 May 2007 12:23:40)
~= what does this operator
(25 May 2007 10:19:32)
Error when compiling objects
(25 May 2007 9:33:58)
alternative to a merge
(25 May 2007 8:47:23)
create user min length
(25 May 2007 7:1:30)
Row Level /Column Level Locking
(25 May 2007 2:21:38)
Simple UNIX question
(24 May 2007 20:34:1)
oracle hints
(24 May 2007 19:23:50)
ODBC
(24 May 2007 19:14:21)
TNSNAMES
(24 May 2007 18:14:48)
setting listener password in Oracle 10G
(24 May 2007 17:39:15)
Only fetching last row in table
(24 May 2007 16:46:58)
export table partionned
(24 May 2007 16:40:59)
cdc async distributed hotlogs concepts
(24 May 2007 16:27:26)
Re: TNSNAMES - single point of failure
(24 May 2007 15:34:31)
Oracle editions - difference
(24 May 2007 14:59:55)
La puerta de salida del laberinto...
(24 May 2007 13:19:33)
How to monitor the index usage.
(24 May 2007 11:15:14)
Solution Req!
(24 May 2007 8:37:31)
Create tablespace in OracleXE
(24 May 2007 8:34:58)
Auditing Query
(24 May 2007 8:32:12)
RAC Installation Document >>>>
(24 May 2007 8:3:0)
migrating single instance 3 TB db to RAC
(24 May 2007 7:4:24)
Oracle to teradata migration approach
(24 May 2007 6:37:2)
Re: New emai-id]
(24 May 2007 5:46:53)
Data Block
(24 May 2007 5:45:11)
New emai-id
(24 May 2007 5:43:48)
ORA-4031
(24 May 2007 4:29:50)
viewing statistics generated by DBMS_STATS
(24 May 2007 4:9:42)
Re: TNSNAMES - finalized
(24 May 2007 3:51:28)
Exporting table SQL only
(24 May 2007 0:29:38)
send_header standard procedure in Oracle?
(23 May 2007 18:25:28)
flash recover area
(23 May 2007 18:3:4)
trace file generated during planned shutdown and startup
(23 May 2007 15:46:10)
GV$SESSION_WAIT
(23 May 2007 15:43:16)
collection in PL/SQL
(23 May 2007 15:0:54)
proper order of events... drop user then drop tablespace?
(23 May 2007 14:46:10)
Segment_ID
(23 May 2007 13:51:56)
calling a sys table from a stored procedure
(23 May 2007 12:53:4)
Backup tablespace error
(23 May 2007 12:36:6)
Standby issue
(23 May 2007 12:28:51)
alter table while used table by any other user..
(23 May 2007 12:27:27)
Listener shutdown issue
(23 May 2007 12:20:56)
Login to the Oracle Management Server
(23 May 2007 12:19:30)
Help! Oracle10gR2 can't see all server's memory
(23 May 2007 11:29:52)
Java log in forms
(23 May 2007 11:0:55)
Error When executing job
(23 May 2007 10:56:5)
qyery regarding collecting tkprof readings
(23 May 2007 10:37:4)
Memory allocation in data blocks
(23 May 2007 9:30:17)
Query for columns with same name in different tables
(23 May 2007 9:0:34)
Query for number conversion
(23 May 2007 7:8:30)
ROWNUM PROBLEM
(23 May 2007 6:41:5)
JSP Not Responding
(23 May 2007 5:2:57)
Database Load issue
(22 May 2007 23:27:1)
Linux 10G - DataGuard
(22 May 2007 21:55:39)
How to load clob in oracle
(22 May 2007 21:26:5)
newbie question
(22 May 2007 19:54:15)
what are these tables ?
(22 May 2007 17:21:42)
Date conversion question
(22 May 2007 16:41:19)
create trigger :ORA-04072: invalid trigger type
(22 May 2007 15:18:39)
Re: drop tablespace - alert log message
(22 May 2007 15:17:24)
query result
(22 May 2007 15:11:28)
Copy of /dboracle
(22 May 2007 14:29:38)
tkprof
(22 May 2007 13:28:25)
urgent crs error message
(22 May 2007 13:22:54)
setting contants that support different NLS numeric character settings
(22 May 2007 13:21:6)
RMAN recover of archive log files
(22 May 2007 12:46:28)
create a trigger for last connection..
(22 May 2007 12:18:28)
Query tuning
(22 May 2007 11:42:21)
Load date to remote server
(22 May 2007 10:15:40)
Reports service, urgent ! -- Terminated with error: REP-50127: Cannot write into file
(22 May 2007 8:36:51)
transportable tablespace
(22 May 2007 7:27:0)
help : ORA-00001: unique constraint (SYS.I_TABPART_BOPART$)
(22 May 2007 5:4:32)
Help reqd: ORA-01000 maximum open cursors exceeded
(22 May 2007 4:42:29)
./.bash_profile
(22 May 2007 1:37:57)
Drop tablespace
(22 May 2007 0:18:54)
SQLLDR file question
(21 May 2007 22:5:49)
How to create user with SELECT only privilege
(21 May 2007 18:45:14)
Error ORA-600
(21 May 2007 18:16:45)
table with no data output needed
(21 May 2007 17:47:25)
Re: error on auto execute of job
(21 May 2007 17:45:16)
What is LTIME in USER$ on ORACLE 9.2.0.7
(21 May 2007 17:8:56)
Prevent table from growing
(21 May 2007 16:37:50)
RMAN / Restore Tables
(21 May 2007 16:0:34)
Best Way to Upgrade Database From 9i on HPUX to 10g on Red Hat Linux
(21 May 2007 14:5:51)
Configuring mail server within application server for Discoverer
(21 May 2007 13:58:32)
Getting the sql from the Trigger?
(21 May 2007 13:58:29)
ORA-03297 - file contains used data beyond requested RESIZE values
(21 May 2007 13:58:29)
not connected to ORACLE
(21 May 2007 13:58:29)
dbconsole doesn't Start
(21 May 2007 13:40:1)
size of shard_pool_size for a database
(21 May 2007 13:28:0)
only 15 records to return
(21 May 2007 12:17:23)
mail settings?
(21 May 2007 12:16:41)
Out put in Sequence
(21 May 2007 11:12:8)
INDEX_STATS
(21 May 2007 9:34:56)
estimate size of table
(21 May 2007 8:18:59)
problem in patch upload
(21 May 2007 5:18:28)
SPFILE RESIDENT
(20 May 2007 16:29:28)
Windows 10g RAC using OpenFilers iSCSI
(19 May 2007 21:1:2)
constraints in all tables
(19 May 2007 9:38:9)
function as a default value
(19 May 2007 2:48:11)
Display Decimal Points
(18 May 2007 18:20:41)
Script/job
(18 May 2007 18:19:32)
How to specify partition dynamically in select
(18 May 2007 18:2:1)
Upgrading Databases From 9i to 10g
(18 May 2007 15:24:50)
CHANGE pfile residence
(18 May 2007 14:35:10)
DLL Copy error applyiing April CPU
(18 May 2007 14:31:28)
ORA-28030
(18 May 2007 13:44:33)
exporting data to excel
(18 May 2007 12:30:13)
Calculated Column while Creating a Table.
(18 May 2007 12:9:28)
32-bit client with 64-bit database
(18 May 2007 11:25:2)
multiple versions of listener on same box
(18 May 2007 11:21:12)
Oracle 9i installation on existing server with 10G
(18 May 2007 8:25:18)
pfile residence
(18 May 2007 8:12:33)
Can I live without sysaux
(18 May 2007 3:20:7)
linux 9i to linux 10g r2 migration
(17 May 2007 20:18:33)
Check to see what Sql statements are being run against a database
(17 May 2007 19:24:39)
Change a users default tablespace
(17 May 2007 19:11:46)
JDBC and OS Authentication
(17 May 2007 19:9:1)
Sqlldr error: ORA-12162: TNS:net service name is incorrectly specified
(17 May 2007 19:4:28)
Whats Wrong In This Statement ???
(17 May 2007 19:4:6)
Migrate data from MS SQL into Oracle
(17 May 2007 18:55:37)
huge archivelog are genrerated during imp or impdp
(17 May 2007 18:50:45)
Par file - the conclusion
(17 May 2007 17:42:6)
using default in Oracle SQL Scripts
(17 May 2007 16:29:47)
workflow manager help
(17 May 2007 16:13:26)
Oracle Migration Workbench
(17 May 2007 16:0:50)
Oracle dba jobs in canada
(17 May 2007 15:38:18)
April Critical Patch
(17 May 2007 14:28:24)
Help! Oracle 10g won't start!
(17 May 2007 12:18:11)
OEM agent stop/start
(17 May 2007 11:54:18)
sysdba
(17 May 2007 10:37:4)
error while upgrading to 10.2.0.2
(17 May 2007 9:43:34)
need help with more recovery to be consistent
(17 May 2007 5:52:34)
Réf. : empty UNDO tablespace
(17 May 2007 4:29:53)
Error in viewing snapshot
(16 May 2007 19:49:30)
Hi,
(16 May 2007 18:49:57)
Database Configuration Parameter.
(16 May 2007 18:42:58)
SQL question - Insert from two rows into one row.
(16 May 2007 17:46:44)
Concatenating columns
(16 May 2007 17:36:24)
Create odbc connect from mysql to oracle
(16 May 2007 17:21:36)
rename tablespace from tbs1 to tbs2
(16 May 2007 17:3:28)
UPDATEING MANY ROWSAND COLUMNS OF A TABLE
(16 May 2007 16:42:31)
Re: rename tablespace from tbs1 to tbs2 - sorry !!
(16 May 2007 16:25:28)
RAC 10g (Books or References)
(16 May 2007 15:41:14)
Database link
(16 May 2007 15:30:29)
Refresh Production database using RMAN?
(16 May 2007 15:24:5)
Réf. : RE: rename tablespace from tbs1 to tbs2
(16 May 2007 15:10:13)
number of archieve-logged transactions
(16 May 2007 14:26:34)
RMAN memory issues
(16 May 2007 12:58:42)
Duplicate database error
(16 May 2007 12:40:4)
HI TO ALL
(16 May 2007 12:32:32)
ORACLE on windows
(16 May 2007 10:58:17)
redo logs
(16 May 2007 10:25:20)
empty UNDO tablespace
(16 May 2007 9:57:57)
Size of database
(16 May 2007 8:45:5)
foriegn keys
(16 May 2007 4:19:40)
DB backup plan
(15 May 2007 23:42:21)
Can not configure any Database in Grid Control
(15 May 2007 20:25:57)
Help with a par file
(15 May 2007 19:45:26)
User- Managed Backup & Recovery
(15 May 2007 17:34:51)
Cloning of database using RMAN
(15 May 2007 15:28:17)
Possible to Open 10g Instance Using 9i OEM??
(15 May 2007 15:27:47)
Sizing tempfiles
(15 May 2007 14:44:50)
RefCursor Output
(15 May 2007 12:9:24)
Error while inserting image in oracle DB
(15 May 2007 12:8:11)
ORA-10134, ORA-27101
(15 May 2007 11:59:36)
Oracle 10.2.0.3 - Duplication of database failing with missing archive logs
(15 May 2007 11:55:50)
Database monitoring task
(15 May 2007 9:38:21)
How to create a duplicate database by RMAN
(15 May 2007 8:1:45)
Instal 10GR2
(15 May 2007 4:16:44)
chinese language
(15 May 2007 2:57:22)
Size guidelines for OEM repository database
(14 May 2007 20:44:58)
Securing Oracle connections
(14 May 2007 19:32:41)
Oracle 9i Installation on windows 2003 server
(14 May 2007 18:59:3)
TableSpace Status
(14 May 2007 18:56:55)
conditional compilation in 10G
(14 May 2007 17:13:52)
Re-install of Oracle 9i on Windows 2003 Server
(14 May 2007 15:38:8)
Shared memory realm error with Ora 8
(14 May 2007 15:30:59)
Oracle Archiving
(14 May 2007 14:41:30)
Oracle 9i Installation on Windows 2003 Server - Installed Oracle via terminal services session
(14 May 2007 14:37:3)
Ple help out on this
(14 May 2007 12:37:20)
Citrix - Oracle connection problem
(14 May 2007 11:13:26)
Insert gif image into table field
(14 May 2007 10:10:58)
function can have out paramters
(14 May 2007 9:39:51)
hi rename
(14 May 2007 4:25:56)
64-bit SEQUENCE or similar?
(12 May 2007 10:23:49)
ORA-08187
(12 May 2007 9:12:23)
exp command inside cron job doesn't works
(12 May 2007 6:33:29)
Error block!
(12 May 2007 2:18:1)
Re: function to return more than one field
(11 May 2007 20:25:19)
How to pass a record to a function in a select statement?
(11 May 2007 19:57:32)
Re: find out any new invalids since the last compile job before compiling them again
(11 May 2007 17:15:5)
oracle exam
(11 May 2007 16:22:57)
find out the invalid, since the last compile job before compiling them again
(11 May 2007 16:1:2)
hi create table
(11 May 2007 14:6:30)
compare two date values from two different tables using max clause
(11 May 2007 13:56:19)
Infinite parameters in PL/SQL function
(11 May 2007 13:20:31)
ssh command with "at" command
(11 May 2007 11:52:6)
OEM 9.2.0.1.0 Log files
(11 May 2007 11:0:39)
return a collection in PL/SQL
(11 May 2007 7:43:24)
sqlplus hangs on linux
(11 May 2007 7:3:20)
Oracle 10gR2 Data Guard
(10 May 2007 20:18:12)
Oracle solution for high availability
(10 May 2007 16:8:48)
Package
(10 May 2007 15:22:29)
Need advice on tuning Partitioned and Subpartitioned Tables, AND Global, and Local indexes.
(10 May 2007 15:7:55)
clufvy
(10 May 2007 13:45:13)
RMAN
(10 May 2007 13:38:40)
clyvfy
(10 May 2007 13:1:5)
revoke the roles
(10 May 2007 12:46:42)
Re: unimplemented or unreasonable conversion requested ::-1
(10 May 2007 10:32:9)
Re: tablespace CMMS is offline
(10 May 2007 10:18:16)
Install Oralce 9i on Server 2 CPU
(10 May 2007 8:47:7)
apoligies
(10 May 2007 1:41:51)
Data Pump import
(9 May 2007 20:37:21)
Question about importing statistics
(9 May 2007 20:2:8)
funtion to return more than one field
(9 May 2007 19:56:2)
Select query & null values
(9 May 2007 19:51:25)
Help with Oracle 10g R2 Physical DataGuard
(9 May 2007 18:17:46)
Error on procedure
(9 May 2007 17:9:23)
password start with a number
(9 May 2007 16:38:37)
grant role in procedure
(9 May 2007 16:8:11)
oracledba- administration manual...
(9 May 2007 15:45:50)
Query Required
(9 May 2007 15:16:53)
Please Help
(9 May 2007 14:18:18)
9i Failover without RAC
(9 May 2007 12:24:20)
Explain Plan Questions
(9 May 2007 11:32:26)
moving datafiles recreating control file
(9 May 2007 11:25:55)
Spooling off
(9 May 2007 9:2:46)
recreate the password file
(9 May 2007 8:10:47)
password file
(9 May 2007 5:40:28)
Implementing Row Level Auditing
(9 May 2007 3:44:16)
database for alphabets with numbers
(9 May 2007 3:8:55)
ORA-27140 help
(9 May 2007 0:53:50)
V$db_object_cache and pinning packages
(8 May 2007 19:5:34)
OS authentication, what am I missing?
(8 May 2007 18:59:3)
select query
(8 May 2007 17:6:24)
Analytical Query - to generate a cross-tabbed or cube like report.
(8 May 2007 16:46:37)
SQL QUERY FOR JOINING TWO TABLES
(8 May 2007 16:9:5)
Creating an Excel file Using SQL*PLUS
(8 May 2007 15:52:46)

oracle lazydba home page