For more information about the site, see the
Site Index
Invalid stored procedures
Hardware requirements for Oracle server on Unix
Generating numbers with MAX(id)+1
COUNT(*) or COUNT(1)
One column LIKE another column
Finding size of files in BLOB datatype
Restoring Oracle 9i backup in Oracle 8i
Restarting 9i database automatically after OS reboot
Locating exp920 executable
GUI-based Oracle auditing software?
Changing location of controlfile during RMAN backup
Copying database structure without data
ORA-600 error after full backup
Easily exporting and viewing Oracle data
Problems connecting 10g client to Oracle 8.1.7 database
ORA-01092 error with upgrade
Encountered the symbol "ELSE" when expecting one of the following
Impact of changing OCR on RAC database
Using export/import to migrate from Windows to Solaris
High availability recommendation for Oracle 10g databases
Can't see audit logs
Import of .dmp file from 64-bit to 32-bit machine
PLS errors after adding columns to table
What is CPU parse overhead?
Differences between tables and views
Switching RAC database to noarchivelog mode
Cost of two-node RAC implementation
Migrating/upgrading Oracle database from Unix to Linux
Exporting Oracle database on Linux for backup
Expression is of wrong type
Datafiles on different backup disk from controlfile
Example scripts for Oracle9i cold backup on Linux
Opening a database with a missing datafile
Are records inserted during backup?
Upgrading Sun OS with Oracle9i
SCN entries in controlfile during database crash
Cloning database with hot backup
Restoring tablespace on another instance and another server
Normalizing a comma-delimited list
Search for a value in 12 columns
Fiscal year in Oracle SQL
GROUP BY multiple columns
Receiving email notification when Oracle goes down
Software design considerations for performance
What are DDL and DML?
Tools for monitoring Oracle databases
Maintaining dblink between databases after upgrade
ORA-03113 when query retrieves many records
Codepages used in Oracle 10g database instance
Database link between TCT/IP and IPX/SPX
Sorting a clob column
Maximum number of sessions exceeded
Sum of sales for two years, by month
Constraints on user tables
Moving temp tablespace and temp file in 10g
Tools to migrate/export data from 8i to 10g
Auditing or tracking changes in Oracle 10g
Two catalog databases for primary and standby?
RMAN backs up for a few hours then fails
Zipping export backup of schema
Taking delta changes after migration
No storage definition found for segment
Size of catalog database
ORA-00980: synonym translation is no longer valid
Restoring a table from a particular day
What is happening during "linking Oracle database" step?
Importing extra columns as null values
Migrating Oracle 8i DB from AIX to Windows
Can't stop all required services for patch application
Patch application incomplete
Upgrade OS or database first?
Using SYS for export
Wrong password error after 10g installation
Execute permission denied
Command prompt disappearing on 10g install
ORA-12518: TNS:listener could not hand off client connection
Migrating 9i database on Windows to 10g on SLES
Performance of DBMS_DEFER_SYS.EXECUTE_ERROR
What happens to DB calls done during a failover?
Restricting update/delete
How many disk groups for our data marts?
Exists keyword in Oracle
Unable to drop test user
Max value of sequence
Installing Oracle binary files on SAN vs. internal drive
Tracesvr80.vrf(67):unbound variable 'exe' error
Full copy or export?
I/O requirements for Oracle 11i implementation
Oracle 10g or SQL Server 2005?
Implementing /3GB and /PAE switches
Sample trigger codes for Oracle 10g
Can we stop writing to the alert log?
Difference between instance and session
What happens to redo files in a crash?
Solving system01.dbf block corruption without backups
SP2-0734 error during import
Tape backup but no Oracle backup
ORA-01116 error
Using backup of standby database
Error with RMAN cold backup
More