For more information about the site, see the Site Index

• Best approach for upgrading from 6.0 to 9i
• Upgrading from 8.1.7.4 to 9.2
• Upgrading from 9.2.0.1.0 to 9.2.0.4 with patch CD
• What is the Oracle inventory directory?
• Exporting data from Oracle 7.3.4 to 10g
• Running Oracle9i and SQL Server on a single system
• Help with cloning a database
• Making checks out to a factoring company
• Accessing an Oracle instance with SQL*Plus
• Specifying a non-empty directory
• "TNS: Operation timed out" error
• Receiving "TNSListener protocol adapter error" during installation
• Removing Developer software from PCs
• How do I find out if a Web page is static?
• Application user request waits and slow database
• Too many buffer reads
• LEFT OUTER JOIN on more than two tables
• Query 2 should not include results from Query 1
• Composite keys in fact tables
• The difference between NOT IN and NOT EXISTS
• LEFT OUTER JOIN with ON condition or WHERE condition?
• How long does a rollback take?
• Can a composite key contain the primary key from another table?
• Deleting a duplicate row in a table
• Is it necessary for the instance name to match the database name?
• Status of Oracle 8i instances running on Windows 2003
• Installing Oracle 9i and SQL Server on the same server
• Updating parent and child records at the same time
• Receiving ORA-01034 error while connecting
• ORA-00054 error with shell scripts
• Copying a LONG RAW column into another tablespace
• Checking for software without running universal installer
• Inserting an apostrophe in PL/SQL
• ORA-04030: Out of process memory
• Configuring the TNSNAMES.ORA file
• Problems with installation of Partitioning
• Sending data from Oracle database to SQL Server
• Configuring a link between Oracle 8i and SQL Server 2000
• Reducing time to process a query
• What is the "yellow bar"?
• Changing a database from dedicated to shared server mode
• Use of decimal in NVL function
• Invalid packages and procedures
• Problems with SQL analyze tool
• Using a nested table for a view-based form
• Handling a large trace file
• Reducing sequential reads
• Taking hot, cold and RMAN backups on Linux and Windows
• Performing a hot backup with RMAN
• Importing dump files from server to computer
• Increasing database backup time
• Cloning a database on Linux and restoring on Windows
• Problems with iAS while migrating to 9i/10g
• Clustering forms and reports
• Accessing applications from the Internet
• Export/import between two servers
• Deleting expired backups on tape
• ORA-03232 error
• Installing Developer Suite and database in different directories
• Duplicating a very active database
• 8i and 9i databases running on separate servers
• Errors during import of a dump file
• Backing up data using VB code only
• Data replication in 10g
• Initialization or shutdown in progress
• Using a decode statement with over 255 parameters
• Benefits of Data Pump in 10g
• OS commands for copying files to a backup location
• Joining on variable field names
• LEFT and RIGHT joins, INNER and OUTER joins
• Top 3 counts, revisited
• Input/output errors
• Design recommendations for FACT TABLE and DIMENSIONS
• Ways to speed up a full export
• Installing a composite primary key on a column without unique data
• Technical considerations for using NUMBER vs. VARCHAR2
• Using OS Authentication
• Converting from CHAR to DATE datatype
• Installing 9i on Windows XP
• Problems with exp utility after patch installation
• Best approach for upgrading from 8i to 10g
• Downloading Oracle for Windows 2003 Enterprise Server
• Producing a nested output
• Exporting a DB using Oracle Console
• ORA-12545 error when connecting to database via client
• Error in ODBC connections
• Fatal NI connect error
• ORA-01092 error while using DBCA
• Migrating from Solaris to Linux
• Which user is putting pressure on the database?
• Getting information on forms and reports from OAM
• Input truncated to one character
• Migrating a database from Intel to HP-UX
• Modifying the interface between two databases
• Insert process running during hot backup mode
• Applying SOA to a large amount of data
• Difference between E-Business Suite 11.5.6 and 11.5.9
• Rebuilding and modifying a database
• Cause of statements running slowly
• Identifying the source of high CPU usage



• More