Oracle Restore Options (Table Restore)

Use this dialog box to choose the table restore options:

Paths selected for Restore

Displays all selected users and tables.

Auxiliary Instance

Specifies the instance name that is used to duplicate the source database with the required tablespaces to export the table from RMAN backup.

Database Name

Specifies the auxiliary database name.

Database Client

Specifies the auxiliary database client name.

PFile

Specifies the initialization parameter init<SID>.ora file for the auxiliary instance.

Browse

Click to browse and select the PFile.

Staging Path

Specifies the path used as the staging area to store datafiles for the auxiliary instance and the complete export tables before importing.

Browse

Click to browse and select a staging path.

Import Options

Lists the options for importing the tables.

Do not Import

Select to export the table and leave it in the staging area.

Import to Source Database

Select to import the table to the source database.

Import to a Different Database

Select to import the table to a different database.

Select Import Database

Specifies the SID of the database to where the tables will be imported.

Select a Client

Select the client on which the import database resides.

Drop Table

When selected, the existing tables will be deleted from the destination database before importing the tables.

.Back to Top