For more information about the site, see the Site Index

• RMA authorization numbers
• Implementing the Benefits Administration/Advanced Benefits module
• Editing applications in Oracle 11i
• Database crash during hot backup
• Transporting a database with no archive or backup
• Manually removing archived log files
• Installing 32-bit and 64-bit Oracle on same machine
• Copying a database to Windows 200x
• RMAN commands for Oracle 8i
• NULL can be your friend
• Databases for SOA integration
• Three consecutive months in fiscal year
• Making a test copy of a database
• Checking for single quotes in a variable
• VARCHAR2 vs. NUMBER
• Finding Oracle instances
• Using export utility after upgrade
• Exporting from SQL Server to Oracle
• Multiple instances on a single database
• Errors during import of dump file
• Calculating database efficiency
• Oracle and SOAP
• Concatenating XML fragments
• Another FULL OUTER JOIN example
• Ranking within a group
• Latest version of each jobcode
• Speeding up the startup migrate process during upgrade
• How do I know if I really need a patch?
• Doubts about applying and removing patches
• Failure during patch installation
• Predefined setup for Oracle 9i
• Upgrading from Oracle 7.3.4 to 10g
• Installing a database on two servers
• Post-installation steps after applying patches
• Importing a schema from 9.2.0 to 9.1.0
• Error message ORA-12545 during remote connect
• Why are patches so complicated?
• Errors after patch installation
• ORA-03113 error when querying table
• Converting to a locally managed tablespace
• Upgrading on a production server
• Dropping two tables with a single drop table statement
• Receiving ORA-313 and ORA-312 errors when trying to open database
• Connecting Oracle forms developer to a database
• Creating a Recovery Catalog in Oracle 8i
• Finding the SCN in the Alert Log
• Removing blank lines from a text file
• Understanding a STATSPACK report
• How to UNION tables that are not union-compatible
• Comparing current and previous row values
• COUNT DISTINCT revisited
• Removing Oracle 9i
• Changing block size
• Creating directories in Oracle 9i
• Packaging procedures with two schemas
• Partitioning tables by range
• "TNS:connection closed" error
• Backup strategy for a 2-node 10g RAC cluster
• Deleting all data in a database
• Clearing the rollback segment from a tablespace
• Dump file error
• Copying tablespaces to another server
• Backup and recovery in Oracle 10g
• APIs in Oracle Enterprise Manager
• Alternative solution to BITMAP index
• Why I love VIEWs
• High System% usage
• Viewing queries in v$sqlarea
• Integer or CHAR(1) primary key?
• TNS protocol adapter error
• Data partitioning and surrogate keys
• "Oracle not available" error
• Logging in to a test database
• Configuring Oracle RAC on a single node
• Proof of installed security patches
• Connecting to 10g database after rebooting server
• Installing Oracle DBMS on Solaris servers
• Temporarily renaming files for testing purposes
• 8i and 9i databases on same server
• RMAN connection error
• Checking for corrupt blocks
• Loading PDF files using SQL*Loader
• Editing object-type data on the Enterprise Manager Console
• Database returning duplicate records
• Deleting a user from a tablespace
• Importing an Excel file into Oracle 10g
• Is full backup mandatory after changing parameters?
• Pre-creating tables in 9i
• Connecting to an Oracle database through .NET
• Generating week dates
• Converting to LEFT OUTER JOIN syntax
• Using DBUA to upgrade
• Importing export file after 9i upgrade
• Database Upgrade Assistant error
• Oracle 9i login error
• Upgrading to Oracle 9i from Oracle 7
• Migrating 8i databases to 9i
• Changing server mode from dedicated to shared
• Oracle vs. Access
• Running Oracle9i in 32-bit mode



• More