For more information about the site, see the Site Index

• ORA-03001 error with dynamic query
• Foreign key referencing unique key in parent table
• Parsing, converting and loading image with XML
• Configuring ASM instance in Oracle 10g
• System vs. object privileges
• Can an RMAN script write to a shared URL path?
• ORA-00932 using length function
• Correct use of CLOB datatype
• Displaying users/schemas with password from Administrator
• Changing passwords for seeded applications accounts
• Bad application performance on Oracle RAC
• Selecting even rows
• Changing datatype of one column
• ORA-28500 with database link
• Key roles of database administrator
• DB exception with two errors
• Writing procedure or function inside trigger
• PL/SQL ignores ASCII null characters
• Oracle stored procedure to return multiple rows
• Datepart function in Oracle
• Help building billion-row system
• Implementing Virtual Private Database
• Importing text file to Oracle table
• Bytes of data in LONG datatype column
• ORA-02068 with database link
• PL/SQL code to implement ETL function
• Difference between two dates in hours
• ORA-0942 error with embedded views
• Using BLOB with ctx_doc.filter
• ORA-04091: table is mutating
• "Not a valid month" error
• Can I spool a file from a PL/SQL procedure?
• Trigger to track user password changes in table
• Unable to flush file data
• Multiple Oracle instances in Unix
• GREATEST and LEAST
• Two ways to SUM a complex expression
• Skipping record that already exists with insert statement
• Create automated backup for Oracle 9i database
• ConnString value for dblink syntax
• Taking tablespace out of recovery mode without restoring it
• Migrating RAC database with Veritas Storage Foundation
• Opening database with lost redo log files
• ORA-12528 error
• Restoring an Oracle backup to a new Windows server
• Starting applications via buttons in Oracle Forms
• Command to view stored procedure
• Checking PL/SQL packages
• Executing procedures with desktop icon
• Sending spool file as mail attachment
• Instant grouping!
• Pattern matching
• Who made changes and with what executable?
• Error due to shared pool size
• Stored procedure to auto-transfer data between servers
• Finding tables with BLOB field
• Native service internal error
• Moving column values from one table to another
• Granting read and write and read-only access
• Client laptop losing connectivity after idle time
• Database migration from DB2 to Oracle
• Spooling true error messages only
• Learning more about data warehousing and Teradata
• Latest entry with single select statement
• Inserting a BLOB in an Oracle table
• Difference among types of checkpoints
• Internal error code with unique argument
• Avoiding mutation errors while writing triggers
• ORA-14400: Inserted partition key does not map to any partition
• Can't remember password for one of multiple databases
• Moving Oracle folder to external hard drive
• Taking export backup of standby database
• Privileges to use RMAN to create backup to another machine
• SQL*Plus not working
• IMP-00009 error during import to remote machine
• Migrating from stand-alone server to blade server
• Storing image file in table
• Pointing to local directory in PL/SQL procedure
• Selecting records with variable value
• Getting PLS-00201 error while exporting schema
• Aggregating time intervals
• Why and how are ref cursors used?
• Executing procedure with in/out parameter
• Explanation of ref cursor
• Matching test DB plan to production without Plan Stability
• Row affected by last DML operation
• Oracle on Unix/Linux vs. Windows
• Exception name for table or view that does not exist
• Extracting from LONG datatype column
• OCP but no experience
• Setting events to avoid "snapshot too old" errors
• Strategy for migrating high-volume database
• Functional advantages of 10g over 8i
• "Host" command in stored procedures
• Version control in Raptor
• Full table scan instead of range scan
• Using stored outlines in "RULE" mode
• Creating partitions on fastest area of disk
• Fluctuating build times for static tables
• Function-based index or Oracle Text?



• More