For more information about the site, see the Site Index

• Problem with quick generation of archive log files
• Can we improve the performance of a tool by eliminating joins?
• PL/SQL program for auto-replying to users
• Keeping data recovery site active
• Sequence of WHERE and ORDER BY clauses
• The three smallest numbers
• Hiding objects in a schema
• COMMIT after deleting X records
• Barcode printing in Oracle
• List of Oracle apps APIs?
• Design help for Oracle Roles when front-end application is not Oracle
• Speed of indexing on tables with different numbers of fields
• What is the max number of sessions that Oracle 8i supports?
• Encountering error trying to resize datafile
• Performing a patchset application in a RAC environment
• Reflecting changes to Oracle database in DB2 database
• Difference between cluster and grid
• Query for five most recent dates
• How does Oracle 8i differ from Oracle 8?
• More on using date as a primary key
• Problems with exp utility after migration
• What does the dump file consist of?
• Difference between RBO and CBO
• Why does RMAN generate less redo than user-managed backup?
• How do I recover deleted data without writing over current data?
• How to change the Oracle SYS password
• Percentages of overall total
• Should sequence numbers be used as primary keys?
• Select another row if first choice is not available
• Multiple rows with same value in one column
• Moving archive log files from primary to standby database
• Taking a backup without creating an RMAN database
• What is a surrogate key?
• A CASE expression inside a COUNT function
• Implementing a Web service in Oracle 10g
• Different queries, different counts
• Configuring TAF parameters in RAC
• Dumping data from 10g to 9i
• How to set the size of SGA?
• Copying a database with Arabic fonts
• Problems installing 8i Enterprise Edition on XP
• Operation hanging during installation
• Planning for migration from 8i to 10g
• Updating changes to DB objects with new releases
• ORA-12537 error when trying to connect
• Archive log files generating quickly
• Help wrapping data in Windows 2000
• Capturing change in every column in every table
• Which IMP messages are warnings and which are errors?
• Can I reset the SYS password?
• Are column headers exported along with data?
• Creating a query to hit an index
• How is the bitmap index stored?
• Same editor for Microsoft and Oracle?
• Error when running .NET application
• DIM error during 10g installation
• Unable to connect to 9i on Windows 98
• ORA-1053 error after 8i installation on Windows 2003
• Exporting from command line
• Finding names of tables with a certain column
• Two tables with same value as primary key
• Difference between "SYSADM" and "SYSDBA"
• Impact of moving two database instances to one database with two schemas
• Receiving error at export command
• Connecting with Visual Basic
• Ways to handle an error on an INSERT statement
• Way to recover a database without backup?
• Difference between regular and REF cursors
• SQL ANSI standards
• Select only non-null columns
• The row with the Nth value in a column
• Difference between a primary key and a surrogate key
• Query to see which user is executing which SQL statement
• Objects suddenly invalid
• Disabling default auditing
• ORA-0658 error at run time
• ORA-12571 error with Oracle 8i on Windows XP
• Questions about ORA-1652 error
• Looking for an article recommending Oracle Designer
• Counting rows in a LEFT OUTER JOIN
• SQL execution error ORA-00904
• Is it beneficial to switch from dedicated to shared mode?
• High traffic and bad performance at peak times
• First steps for determining database performance
• Error during import from 9i to 10g
• ORA-30036 error when executing update query
• Mapping values from 8i to 9i
• How much redo is generated from a hot backup?
• Best RMAN script for 9i
• Unable to open 8.0 database on Windows
• Can I use RMAN to back up a database not running in archive log mode?
• "Database not mounted" error
• Advice on Oracle disaster recovery plan
• Performance tuning questions
• Minimizing time to export a 9i database
• Way to recover a tablespace without backup
• What time did the database go down?
• Error during export of database
• Steps for importing an 8i database to a 9i/Linux system
• SQL ANSI standards and compliance



• More