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