How to move large data warehouse for upgrade?
How do DML transactions affect redo log buffer?
Preparation for OCP in 9i
Need deeper understanding of Oracle and RMAN
How do I know if the column is BLOB or BFILE?
Linking SQL Server to Oracle server
Can't get into new database with same username/password
Dropping old partitions
ON DELETE RESTRICT
Data model for foreign key referencing primary key
Delete all but two rows in each group
Tune procedures and queries before or after implementing RAC?
What is Oracle's default sorting behavior?
Checkpoints of good database design
Beginner data integration questions
Method other than imp/exp for backup of Oracle 7.3
Does RMAN generate separate backup set for each block size?
How to export a tablespace in 9i?
Validation process followed in GL interfaces
Logging changed vectors during DMLs
Can I take a compressed backup with RMAN?
Export failing with EXP-00002
Questions about tablespace and user
ORA-00904 error on select statement
Query sometimes returns ORA-1403
Equivalent Oracle syntax of SQL:1999 syntax
Can't get data with synonym name
Advanced features of Oracle 10g
Deleting a duplicate record from a table
Make new columns null?
Multiple SIDs in same database?
Is Oracle easy to learn?
What is High Water Mark?
Best HA and OS options for data warehouse
Using a pre-existing list
Using roles/grants vs. public synonym
SQL statement gets very long very fast
ORDER BY a specified sequence
What other certifications will increase my market value?
Latest entry based on timestamp
Steps for recovery after making copy of database
Import terminated successfully with warnings
Importing 8i dump to 9i
Comparison of RMAN and SQL-BackTrack
Recovering corrupted SYSTEM tablespace
Are offline backups a waste of time?
Database crashing after upgrade
Cannot open shared object file
Refreshing production database into test database
Questions about DBA career
What session is consuming the tablespace?
Execution time increases with packaged code
Package slow after upgrade
Temp space usage increases when query includes view
EXISTS subquery or OUTER JOIN?
Complex query with DECODE
Deleting Parent and Child rows
Year-to-date period totals
Finding SQL that caused an error
Opening database automatically after restart
ORA-01552 with import command
Error messages with import/export
Can I audit the export of tables by certain users?
Close cursor after for loop?
Generating a CSV file
Error during export of 10g database
Can't connect to shut down the database
Check if date is greater than 2000 in PL/SQL
Obtaining Oracle and SQL*Plus for home practice
What is a cluster? What is RAC?
Can I install Oracle Client 7.3.4 on Windows 2003 Server?
Cross-platform upgrade to 10g
Oracle9i installation on Linux 9
JVM error during installation
What should I know before applying patches?
Practice installing Oracle software on Solaris
FRM-10142 error message
Listener failing to start
Uninstalling Oracle 8
Steps for migrating database and Forms/Reports to 10g
"Oracle not available" message when creating database
Can't write to /tmp
Security risk with certain Oracle products?
Updating patches to increase performance of server
Database mounting but not opening
Backing up Linux database on Windows system
Archive files not automatically transferring after power failure
Where to write the imp command?
Retrieving Oracle SID name in Reports
Unix shell script for incremental backups
Format of dump files changed
Steps for database replication
Definitions of composite primary key and tuple
Script to shut down database with Windows scheduler
How do I find which services are running and close them?
How to change forgotten password?
Help with 9i installation and configuration
Getting "null pointer exception" error
Restricting sys user with password