- DataPump Parameters INCLUDE and EXCLUDE - How to Load and Unload Specific Objects.
- How does one use the import/export utilities?
- Causes and Solutions on ORA-1113 Error File Needs Media Recovery
- When and How to Recreate the Controlfile
- ORA-00214: Controlfile Version Inconsistent on Startup or Shutdown
- RMAN-06026, RMAN-06023 During Restore Using RMAN
- ORA-00257: archiver error. Connect internal only, until freed.
- SGA Components in Oracle 10g
- Pfile and Spfile in Oracle.
- Types of Metadata Views in Oracle 10g
- How does one code a matrix/crosstab/pivot report in SQL?
- Map/ concatenate several rows to a column
- What is the difference between VARCHAR, VARCHAR2 and CHAR data types?
- How does one select the TOP N rows from a table?
- How does one select the LAST N rows from a table?
- How does one select EVERY Nth row from a table?
- Original Export and Import Versus Data Pump Export and Import
- Switch From DBMS_JOB to DBMS_SCHEDULAR
- How to Create and Use OMF
- How To Drop, Create And Recreate DB Control In 10g Database
- Relocate Datafiles in Oracle Database
- Copying Files Using the Oracle Database Server
- Troubleshooting DbConsole Error - OC4J Configuration issue
- How to Start your database with non default spfile
- What is your Oracle Database Software Release.
- How to Enable Listener Logging and Tracing.
- Convert CLOB to BLOB
- Verify Physical Data Structure in Oracle.
- How to Change Database Name and DBID?
- Flashback Version Query
- Flashback Table and Flashback Drop
- ORA-01940: Cannot drop a user that is currently connected
- Different Oracle Database Status and Active State.
- How to know My Database Start with Spfile/Pfile?
- ORA-07283/ORA-32004: obsolete and/or deprecated parameter(s) specified
- Manually Creating an Oracle Database
- Database Administrator Authentication
- UDE-00008, ORA-06550 and PLS-00905 When Using Datapump
- Export/Import DataPump Parameter QUERY Specification
- Extract DDL from Dump/ Read contents of dumpfile
Oracle Tech