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