For more information about the site, see the Site Index

• Migrate data from SAP warehouse to Oracle 10g
• Migrate 6 TB of data from Oracle 8.1.7 to Oracle 10gR2
• Unable to connect to management server
• How to migrate Oracle 10g to RAC cluster on Linux
• How to practice Oracle 9i on home PC
• ORA-12546 error installing 32-bit Oracle on 64-bit Windows XP
• DBUA throws "not a valid xml file" error during upgrade
• Help for beginner installing Oracle 10g on Linux
• Using Oracle 9i with Oracle 10g Grid Control
• ORA-1157 error with Oracle 8i database restore
• "Delete from emp" without "where" condition
• How to attach Oracle database backup files to existing server
• "Need media recovery" error
• Apply redo logs to update changes made during hot backup
• Delay with import from 32-bit to 64-bit
• Migrate Oracle database from Windows to Solaris
• Remotely manage Oracle 8i via Windows Terminal Services
• No such file or directory error
• Configure Oracle Data Guard
• Oracle UDP protocol or Veritas LLT for interconnect traffic?
• LEFT OUTER JOIN without using LEFT OUTER JOIN
• Distinct values of more than one column
• Difference between candidate key and composite key
• Update two columns with one UPDATE command
• Highest revision within highest version
• Execute SQL statement from table in other schema
• ORA-04082: NEW or OLD references not allowed in table level triggers
• Oracle 9i or Oracle 10g for beginner DBA?
• Oracle's holding capacity
• Counting rows in runs
• ORA-28500: Attempt to access a column with unsupported name length
• Inserting multiple rows in SQL
• What is a hash value?
• The controlfile_sequence# column in v$database view
• How many schemas per application?
• View for total users and default tables in Oracle database
• Which datafile contains my table?
• Default users for new database
• Safe to remove archived redo logs from OS?
• IMP-00009 and IMP-00028 errors during import
• Backup and recovery strategy for very large databases
• Use archived redo logs to see DML changes
• Migrate Oracle Database 9i from Solaris 9 to Solaris 10
• Redo log file filled up
• Add a column in a specific position in a table
• Check current SCN in control file
• Recover database using backup controlfile until cancel
• Composite keys and normalization
• Setting up backups with data replication
• More about ORDER BY for a specified sequence
• ORA-01801 error in RAC environment
• Can't refresh individual table with replication system
• Migrating to Oracle RAC from single-instance database
• Dedicated vs. shared server configuration
• User IDs keep getting locked
• Checking for URL to administer Oracle 10g database
• RAC or Data Guard for 2TB application with 30 users
• Importing data from Continuity database into Banner
• Convert minutes to HH:MM:SS format
• Useful SQL commands for new Oracle DBA
• Compare two tables for anomalies
• Totals from a UNION query
• What is the SCN?
• ORA-01092 error at startup
• SAN storage for optimal performance
• ORA-12801: error signaled in parallel query server P004
• Using Oracle Transparent Gateways to fetch data from DB2
• Script to revoke access from user
• Using sequence in table with no ID field
• SQL commands to copy selected records from old system to new
• Patches for upgrading from Oracle 9i release 1 to release 2
• Database Configuration Assistant gets stuck on step 8
• tnsping timing out when trying to connect
• Definitions of checkpoint, PMON and SMON
• Recovering database that crashed an hour after backup was taken
• Upgrading from Oracle 8.1.7.3 to 9.2.0.6 on Sun
• Was OPatch applied successfully?
• Difference between migration and upgrade
• User manipulated data in hot backup mode
• Backup strategy for 1TB database
• Changing synonym of base table
• Steps to migrate from Oracle 9.2.0.7.0 to Oracle 10g
• Undoing accidental update after two days
• How long to export 10TB data from 9i to 10g?
• Migrating Oracle 10g from Windows 2003 to Unix
• Runs in groups
• Closest Saturday less than or equal to a date given
• Performance of IN lists
• ORA-01702: a view is not appropriate here
• Creating a cluster and cluster index
• Permissions for default user
• Measuring query response time in Oracle
• Determining size of table in Oracle database
• Sorting data in varchar2 field
• Receiving GROUP BY error in Oracle 8i but not 10g
• ORA-25143: default storage clause is not compatible with allocation policy
• Number of columns in primary and foreign keys
• How Transportable Databases and Transportable Tablespaces handle endian formats
• How tkprof works for tuning
• Migrating from Oracle 9.2.0.6 on Solaris 8 to 10g on Solaris 10



• More