For more information about the site, see the Site Index

• 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
• Entity-Attribute-Value constraints
• SQL to update the header records?
• A running total
• SQL to round up to nearest thousand
• CHECK constraints
• 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



• More