For more information about the site, see the Site Index

• Installation hangs
• Best way to migrate Oracle 7.3.4 to Oracle 9i
• Error when installing Oracle 10g on Suse 9.1 Professional
• Problem installing Oracle 10g on a standalone Windows 2000 SP4
• What do I need to do to create a database with Oracle 9i?
• Problem with a Oracle 8i installation in Win 2000 Pro.
• Why is the listener terminating?
• SQL statement issued by the client system
• Migration of an Oracle database
• Upgrade gotchas
• Oracle forms only accessing the database
• Preventing connections to the database
• Deploy entire database schemas
• Top N rows for each X
• Durations calculated from two rows
• ORA 12560 TSN protocol adapter error
• Oracle application made to run in Arabic and English
• Bug fix for ORA-14450 error
• DBMS error ora-01034
• Oracle 8i TNS protocol adapter error
• Insert records into Oracle automatically
• Oracle e-Business Suite and security
• Using Forms10g apps to automate the testing
• Levels of clustering on Oracle AS10g
• Understanding SMON
• Application Failover
• Calculate the execution of a query -– revisited
• Error while connecting to Oracle8i
• Rows to columns (another "crosstab" report)
• Customers who bought X at least once and Y at least twice
• Clarification on explain plan statistics and used COST
• Hung sessions while working with DML
• Select all rows for a particular column
• Joining on a substring of a column
• Backup and recovery scenarios
• Create a new user
• EXECUTE IMMEDIATE with SELECT statements
• Import specific tables from usermode_exported file
• Import a tablespace from export file
• How can a bind variable increase query performance?
• Directly insert data into a database
• Explain Plan vs. Execute Plan
• Use TOAD to move data from MS Excel to Oracle
• Unacceptable performance in the test database
• OLAP defined
• Data mining and data warehouses defined
• Oracle versus SQL Server for data warehouse
• Course suggestions for learning data warehousing
• Measuring offload data
• Query on primary keys takes too long
• Can Informatica write a Mainframe file?
• Cross join effects
• NULLs propagate through expressions
• Sum of two table row counts as one answer
• Utility that reads from a USB port
• Creating a test Oracle 10g database on Windows XP
• Insert a new row by "INSERT INTO"
• Working with the RMAN command
• Lost archived redo log files
• Totals for one customer compared with totals for all
• Error message when software is at its peak
• Export tables into separate dump files
• Load data from a Microsoft Excel spreadsheet using TOAD
• Unable to log to sqlplus
• Session is disconnected after shutting down an instance
• Performing a backup with 24/7 availability
• Reading Execution Plan output
• SUMs from either of two columns
• When did a product price increase a given percentage
• Exporting a Window XP database to Linux
• Automate the testing process
• Error when exporting DBMS to a dump file
• Back up an Oracle database on a Linux platform
• Exporting a full database mode from Oracle 10g
• Importing an export file
• Multiple rows from multiple columns
• Another WHERE EXISTS example
• Number of values across a row
• Concatenate values into comma-delimited string
• How can I delete empty spaces from a text column?
• Making sure your DB is optimized
• Is Oracle Streams a good tool to move data from production to a reporting environment?
• Is a separate tablespace for every table and index a good idea?
• Performance problems with RAID 5 disk architecture and Oracle
• Searching for stored reservation dates in a database
• Write a SQL script with optional arguments
• Line placement in an EMESSAGE
• Optimizing the performance of the redo log buffer
• Working with InterDev and DreamWeaver
• Specifying a column as NULL
• Disparate date-a types
• Using RMAN in Oracle 9.2 for recovering a tablespace
• Optimize the performance of redo log buffer
• Export an Oracle extension to another extension
• Is there a table to define Oracle error messages?
• Error message while trying to write a Pl/SQL block
• Migrating an Oracle 9i database to an Oracle 10g
• Why do many DBMS push their own programming languages?
• Display a record in a single dbms_output.put_line statement
• Cost factor in the explain plan and query execution time



• More