How can we successfully restore a table?
You must select all the tablespaces on which this table resides to successfully restore a table.
What are the tables that can be restored in Oracle 11g2?
You can restore tables under non-system tablespaces in Oracle 11g2.
Can we perform table restore from one schema to another schema?
No. Currently, we do not support restoring the tables to a different schema. However, you can select “ Do not import “ while running table restore, which will save the dump file. Later, run your import script against this dump file.
How are table indexes handled during restore?
When you include the indexes during a table restore, note that only the index definition is restored and not the indexed data.
Can we manually import tables from the auxiliary instance?
Once the tables are restored to the auxiliary instance, use the CommCell Console to export the data from the auxiliary instance and import it to a destination that you choose, or leave the data in the staging path and import the data manually by using Oracle import utilities.
How are stored procedures restored?
Stored procedures are restored from the Schema level. The schema is the collection of data objects created by the user to contain or reference their data. If one of the table within the schema is selected for restore, all the stored procedures for that schema will also get restored.
Can we restore tables when there is a schema change in the database?
No. Table restores are not supported when there are schema changes in the database.
Why is the cleanup not occurring for staging area during table level restores?
This happens as the data files from staging area and auxiliary instance are not cleaned up when table level restore fails in export/import phase. This will allow you to run the export and import jobs manually without restoring the database again.