Database Reference
In-Depth Information
you are ready to perform a restore of tables or table partitions using RMAN. Now let's look
at some of the restrictions related to the restore of tables and table partitions.
Restrictions When Restoring and Recovering
Database Tables and Partitions
There are some restrictions related to table and partition-level recoveries. These include
the following:
■
You cannot restore tables that belong to the
SYS
schema.
■
Tables that are stored in the
SYSTEM
and
SYSAUX
tablespaces cannot be restored.
■
Tables and table partitions in standby databases cannot be restored.
■
If a table to be restored has a
NOT NULL
constraint assigned to it, then you can't use the
REMAP
option of the
RECOVER TABLE
command.
Next, we will discuss the various options that you can use when restoring tables or
table partitions.
Options to Consider When Performing Table or
Table Partition Restores
When you issue the commands to restore a table or a partition, you will want to take
advantage of various options. Table 7.4 provides a list of these parameters and their use.
TABle 7.4
RMAN Parameters Used When Restoring Tables
Parameter Name
Purpose
AUXILIARY DESTINATION
Location used to create the auxiliary instance-related files.
DUMP FILE
The name of the Data Pump export file.
DATAPUMP DESTINATION
The directory where the Data Pump export file should be cre-
ated. This directory should have been created in the database
using the
CREATE DIRECTORY
command.
NOTABLEIMPORT
Indicates that the export file should be created. However, the
contents should not be imported into the target database.
REMAP TABLE
Renames the table in the target database when it's created.
REMAP TABLESPACE
Creates the tables in a different tablespace of the target
database.
Search WWH ::
Custom Search