Test drive the Oracle 10g replacement for the EXP and IMP utilities.
Oracle Data Pump (expdp, impdp) in Oracle Database 10g, 11c, 12c. Learn about the enhancements to the merge statement in Oracle Database 10g. MERGE Statement Enhancements in Oracle Database 10g.
ORACLE 10G ONLINE TEST UPGRADE
This article provides a brief description of the installation enhancements which are relevant to the OCP upgrade exam for Oracle 10g. Installation Enhancements in Oracle Database 10g. Take advantage of the improvements in Very Large Database (VLDB) support in Oracle 10g. Improved VLDB Support in Oracle Database 10g.
This feature doesn't use flashback logs or undo, so it is distinct from the other flashback technologies.įlashback Transaction Query in Oracle Database 10g -įlashback transaction query can be used to get extra information about the transactions listed by flashback version queries.įlashback Version Query (VERSIONS BETWEEN) in Oracle Database 10g -įlashback version query allows the versions of a specific row to be tracked during a specified time period using the VERSIONS BETWEEN clause. The recycle bin is a logical collection of previously dropped objects. The FLASHBACK TABLE command allows a type of point-in-time recovery (PITR) of individual tables.įlashback Table to Before Drop (Recycle Bin). The FLASHBACK DATABASE command is a fast alternative to performing an incomplete recovery, also known as a point-in-time recovery (PITR).įlashback Query (AS OF) in Oracle Database 10g -įlashback Query allows the contents of a table to be queried with reference to a specific point in time, using the AS OF clause. Reverting to LogMiner or point in time recoveries.įlashback Database in Oracle Database 10g. Use the new and enhanced features of flashback technology to view old data, track data changes and recover from accidental data loss without Use this new API to make binary copies of files on the local server or to transfer files between the local server and remote servers.įlashback New Features and Enhancements in Oracle Database 10g. Oracle 10g contains many improvements to Virtual Private Database (VPD), Fine Grained Auditing (FGA) and data encryption.ĭBMS_FILE_TRANSFER Package in Oracle Database 10g. The automatic workload repository (AWR) is the latest evolution of statspack which provides the central information store for all Oracle 10g self-tuning functionality.ĭatabase Security Enhancements in Oracle Database 10g. This article the discusses the new features which automate the tuning of SQL statements in Oracle 10g.Īutomatic Storage Management (ASM) in Oracle Database 10g -Īutomatic Storage Management (ASM) is a new feature introduced in Oracle 10g to simplify the storage and administration of Oracle files.Īutomatic Workload Repository (AWR) in Oracle Database 10g.
This article describes several methods for producing reports from the Automatic Database Diagnostic Monitor (ADDM) in Oracle 10g.Īutomatic SQL Tuning in Oracle Database 10g. Some tips on what to expect when upgrading your OCP to Oracle 10g.Īutomatic Database Diagnostic Monitor (ADDM) in Oracle Database 10g. Oracle10g: New Features For Administrators Exam Tips. Oracle Database 10g: New Features For Administrators OCP Exam Articles Oracle Database 10g Release 2 Installations.Oracle Database 10g Miscellaneous Articles.Oracle Database 10g: New Features For Administrators OCP Exam Articles.