Performing a backup with table locks
Moving a table with a LOB column
In Oracle, does the number of columns in a table affect the performance during SELECT/INSERT/UPDATE?
Allocating bytes as extents in Oracle
How to move data faster with a database link
How can I solve the ORA-4030 error?
How to implement a ref cursor called in a stored procedure
Why am I getting the ORA-00381 error when initializing the parameter?
Performance issues in Oracle 9i
What is the difference between an instance and mounting in Oracle?
What is Unix shell scripting?
How to get history of modified data from Oracle databases
Export dump with files larger than 2 GB
Benefits of a 3NF level of normalization
How does Oracle identify which password file to use?
What is the difference between a production DBA and a developer?
Errors when importing from production to development
Failed stored procedure through db link in Oracle
How do you size spatial tables and indexes?
Creating db links from Oracle 10g to 8i
Oracle upgrade basics
Analyzing wait events in Oracle
Can I export an Oracle database from UNIX and import to Windows?
Import on one table from dump file
How do I retrieve second transaction for each customer?
Querying metadata and data at the same time
Correlated update in Oracle
Why am I getting the ORA-01195 error when issuing a recover command?
Can I restrict data in a single schema?
Recreating advanced queuing objects during database upgrade
How would referential integrity work in this situation?
When should an Oracle database be reorganized?
Using Oracle's Virtual Private Database, aka Fine-Grained Access Control
How DDL and DML commands work in Oracle
Moving Oracle binaries
SGA sizing in Oracle
Error during RMAN backup
Can I drop a column in SYS schema?
Converting text data to an Oracle table without Oracle's SQL*Loader utility
Oracle block size during import
Allowing NULL values
How to encrypt RMAN backups
A running total
SQL to update the header records?
SQL to round up to nearest thousand
Should I port from Microsoft Access?
How can I find statistics on total memory usage and database connections?
How do you create a link between two databases inside a stored procedure?
Installing multiple Oracle homes
STATSPACK tool: transaction vs. execution measurement
Redo log file problems
Can I resize SGA while the database is up and running?
Manual upgrade vs. export and import
Can I move a SYSTEM tablespace when the database is running?
Modifying SYS password in a RAC environment
Offsite database replication
RDBMS composite key definition
What are the main challenges when working with both Oracle 64 bit and 32 bit versions?
In Oracle Data Guard, which database is primary?
Why am I getting the ORA-02019 error?
When are changes recorded in the database buffer cache?
Should I store three spaces in this database field?
Defining Real Application Clusters (RAC) vs. Storage Area Network (SAN)
Maximum limit Oracle DBMS datafiles
What is the ORA-03113 error?
Changing the Database Identifier (DBID)
Oracle error: no data found
How to drop tablespace with missing datafile
The last transaction date every month
Collapsing a one-to-many result set
Is this where we use a RIGHT OUTER JOIN?
Restoring a hot backup of a production database
How to archive and decommission a database
File permissions when doing an RMAN backup
Taking export for all schemas
Exporting with LOBs
What are the differences between database migration and database upgrades?
Importing tables with integrity constraints
Converting Long Raw to Blob
Oracle certification tips and advice
Is Oracle 11i Applications or E-Business Suite a variation of Oracle Forms?
What is the difference between a relational database and a repository?
Using the DRIVING_SITE hint
Running two instances of Oracle on one server
Solving the ORA-1650 error message
Using transparent gateways to access data in SQL Server
Installing Oracle 11g on Linux
How to manually configure DB Control in Oracle
Can I write triggers from Oracle 7 to Oracle 11?
Running a Monday-Friday report to include weekend data
Return non-matching rows from both tables
I am running out of disk space, how do I hot swap my drives out?
Parsing in Oracle
Select from one table based on condition in another
Clone database vs. standby database
Taking a full offline backup
Using rule-based optimization to optimize a query
Cleaning a temporary tablespace