For more information about the site, see the Site Index

• ORA-12571 error installing Oracle 9.2.0.1.0 on XP
• Questions about CLOB data type
• LGWR error when running batch processes
• Best way to update column of table with 5 million records
• Cause of Oracle shared pool fragmentation error
• Causes of dbf file corruption and truncation
• Problem getting disconnected from server after one hour
• Recommended files and version for installing Oracle DBMS
• Errors trying to migrate from Oracle 7 to 9i
• Options for universal ID at a university
• Is Oracle incompatible with Pentium 4 machines?
• Database instance hangs on issuing statements with literals
• Using the ON DELETE CASCADE in Oracle
• Can I install Oracle 10g on same machine with 8i and 9i?
• Logging changes to row content, part 1
• How to excel with SQL
• Loading CSV file to an Oracle table
• Need help creating a calendar
• Procedure to access public synonym via select statement
• Determining timing of PL/SQL
• ORA-01002: fetch out of sequence error
• Quirks in Database Configuration Assistant
• Using Java to find value of nextval
• Mapping multiple users to a single database user ID
• Query to list city with most customers
• Correct syntax for invoking a packaged procedure
• Logging changes to row content, part 2
• Errors running Oracle Forms application
• Recommended reading on Oracle SQL optimization
• How to copy tables from floppy disk into SQL
• Problems deleting 600,000 rows from partitioned table
• Producing table output from three tables
• Converting COBOL style code to PL/SQL
• Best way of updating 400 column values in table
• Extracting data from 30 tables using a join condition
• Recommended reading to prepare for Oracle certification
• Help fixing script to process 3 million records faster
• Error running procedure without a parameter
• Oracle 9i forms question
• How to stop scripts when error condition occurs
• Determining table size
• How to store a picture or graphic in Oracle database
• ORA-01840 error generated when running query
• What does SQL stand for?
• Problems accessing SQL Server from Oracle
• Error installing Oracle 9i
• Backing up a 1.4 terabyte database
• RMAN backup and recovery help for new DBA
• How does database connectivity work in C++?
• How is recovery possible in a roll forward phase when the database instance fails?
• Setting the timeout in listener.ora
• Solution for ORA-01034 error
• What is a mutating row?
• Can I use existing forms and reports after upgrading to Oracle 9i?
• Techniques for faster data loading instead of using Java
• ORA-00959 error on trying to drop a tablespace
• Description of different Oracle versions
• ORA-00060 error doing table inserts
• Upgrading from Oracle 8i to what?
• "Insufficient privileges" error when creating database
• Stopping a scheduled job in Oracle 8i
• Questions about portlets and portals
• Questions about installing Oracle 9i on Windows 2000 server
• Database doesn't start automatically but Listener is running
• Role of system administrator versus database administrator
• ORA-12560 error after installing Oracle 8i Enterprise Edition
• Using OCIPasswordChange
• Best way to repackage Oracle applications into MSI?
• Only the latest matching row
• Clarity in stating the question
• Duplicate company names
• Cursor or application code?
• Can I install Windchill 7.0 with Oracle 8.1.7?
• How to verify queries using statistics from dbms_stats?
• Calculating space needed to create index
• Preferred way to update statistics when dbms_stats has been run on tables
• More on healthcare data warehouse star schema
• BI without ETL
• Best DB cert
• Assertions
• Data warehousing resources
• Data warehouse as a fully normalized DB or as a collection of tables?
• Replicating transactional data from Oracle 9.2 RAC to SQL Server 7
• Implementing RMAN to take online and offline backups
• Writing script to automatically read last query without using AUTOTRACE
• How to establish a database link from Oracle 8i to SQL Server 7?
• ODBC driver support for the SQL_ATTR_QUERY_TIMEOUT parameter
• What are bdump files?
• How to get faster output on SQL query to join four tables
• Unable to connect to database using svrmgrl
• Using Statspack to monitor database and plot results
• Comparing AWR data with the baseline during report generation
• Getting the time it takes a query to execute
• Problems from removing a non-system data file when database was running
• Testing offline backup by restoring files to remote site
• Database instance not working after improper shutdown
• Running SQLLDR from an application
• Installing SAP 4.7 on Windows 2000 and Oracle
• Unable to install Oracle 10g on Windows 2000 server
• Problems migrating Oracle 8.1.7 from Windows NT 4 to Windows 2003 Active Directory



• More