For more information about the site, see the Site Index

• Checkpoints and RBA in Oracle
• Replication between RACs
• Errors after changing to archivelog mode
• Retrieving records from truncated table
• Necessary to back up UNDO tablespace?
• Hot backups of Oracle E-Business Suite
• Setting preferred credentials
• Moving dbf files
• "Grant failed" error with password file
• Importing Oracle data from Unix to Windows
• Tune this complex WHERE clause
• Update a substring of a column value
• Concatenate into a single row
• Count two columns in a join
• Date constraint in a query
• ORA-01455 on Apps 11.0.3
• Cumulative quantities
• Different invoices on first and last version in group
• Can a foreign key also be used as the primary key in the same table?
• Function is nested too deeply
• Protecting *.aud files from SysAdmin
• Tool for migrating data between databases
• Unable to drop a user
• Converting SQL Server data to Oracle
• Packaging project built in Oracle 9i/Forms 6i
• Archive log not updating
• Connecting to Oracle9i table from DB2
• "Input is too long" error
• Data truncated after 4,000 characters
• Restricting access to database via trigger
• Cannot determine which trigger has COMMIT clause
• Setup for 10g Grid at home-based lab
• Retention policy in RMAN
• Cold backup on Unix server
• Using exp80 and imp80
• Export errors with Oracle 7 on SCO OpenServer
• ORA-01078: failure in processing system parameters
• Restoring a specific table
• Transferring tablespace to another database
• Consistent vs. inconsistent backup
• Restoring Oracle via tape to different server
• Problems after using DBMS_STATS with GATHER AUTO
• Using HINTS in SQL tuning
• Query takes much longer in 10g
• Time taken to execute query
• CPU jumping to 100% usage
• Help with optimizing a query
• How to improve insert performance
• Using Oracle trace files
• Display query taking too long
• Implementing partitioning before data warehouse upgrade
• Oracle not available after restart
• Error at recursive SQL level
• Maximum open cursors exceeded
• Task-level expenditure transaction control has been violated
• Problem loading comma-separated values
• Running connect command
• Which roles/privileges are associated with a user?
• Grid or RAC?
• Questions about user-managed hot backups
• How to use backup utilities in 10g
• Errors with ARCserve backup
• Recovering a table dropped after backup was taken
• Taking backup with only DBF files
• Recovering database with newly added datafiles
• Backup methods other than exp/imp
• Creating report from snapshots
• Releasing table lock
• Taking backup of table structures without content
• Taking cold backup without external backup media
• Copying table from production to test server
• Recovering .dbf files without .dmp files
• Upgrading production databases
• Is 9.2.0.7 just a patched version of 9.2.0.6?
• Unsure how to apply patch
• Upgrading from 8i to 10g with import utility
• Migrate to 9.2.0.7 first or directly to 10g?
• Upgrading from 9.2.0.1 to 9.2.0.5
• Upgrading client machines
• Have to reinstall Oracle8i on Windows XP each time I restart
• Using export/import to upgrade to 9i Rel 2
• Import failing
• Problems encountered during upgrade to 10g
• Info on starttype option
• Renaming accounts for security
• Configuring RAC on Windows laptop
• 9i install hangs at 23%
• No errors in tnsnames.ora file
• Error when trying to connect through SQL*Plus or Oracle Net Manager
• Need higher JRE version?
• OIP-00005 error
• Java Run Time error when installing Oracle8i on Windows 2003
• Packet writer failure
• Files are in use by another application
• Not able to connect with Covus
• What do we do after installing patch 9.2.0.6.0?
• Upgrading Oracle on Red Hat
• SQL*Forms30 not recognized
• Plan for laying out instances before migration
• Character set name is not recognized



• More