You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?
When running the tablespace point-in-time commandrecover tablespace usersuntil time '10/06/2008:22:42:00'auxiliary destination 'c:\oracle\auxiliary';You receive the following error:What is the likely cause of the error?
You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose.What are the prerequisites for performing the active database duplication? (Choose all that apply.)
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.You executed the following commands to achieve this:RMAN> CONNECT CATALOG rco11/password@catdbRMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?
The INV_HISTORY table is created using the command:The following data has been inserted into the INV_HISTORY table:You would like to store the data belonging to the year 2006 in a single partition and issue the command:SQL> ALTER TABLE inv_history -MERGE PARTITIONS -FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')),FOR(TO_DATE('15-apr-2006'))INTO PARTITION sys_py;What would be the outcome of this command?
