How can I solve the ORA-4030 error?
How to implement a ref cursor called in a stored procedure
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
Why am I getting the ORA-00381 error when initializing the parameter?
Performing a backup with table locks
Performance issues in Oracle 9i
What is the difference between an instance and mounting in Oracle?
How to move data faster with a database link
Export dump with files larger than 2 GB
What is Unix shell scripting?
How to get history of modified data from Oracle databases
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?
Failed stored procedure through db link in Oracle
Creating db links from Oracle 10g to 8i
Errors when importing from production to development
How do you size spatial tables and indexes?
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
Modifying SYS password in a RAC environment
Can I move a SYSTEM tablespace when the database is running?
What are the main challenges when working with both Oracle 64 bit and 32 bit versions?
Offsite database replication
RDBMS composite key definition
In Oracle Data Guard, which database is primary?
Should I store three spaces in this database field?
Why am I getting the ORA-02019 error?
When are changes recorded in the database buffer cache?
Defining Real Application Clusters (RAC) vs. Storage Area Network (SAN)
What is the ORA-03113 error?
Maximum limit Oracle DBMS datafiles
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
File permissions when doing an RMAN backup
How to archive and decommission a database
What are the differences between database migration and database upgrades?
Taking export for all schemas
Exporting with LOBs
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
Installing Oracle 11g on Linux
Using transparent gateways to access data in SQL Server
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
Using rule-based optimization to optimize a query
Taking a full offline backup
Cleaning a temporary tablespace