recover table - cheeyoung/sqlplus-public GitHub Wiki
recoverObject
This subclause specifies which files to recover. Refer to recoverObject::= for the syntax diagram.
| Syntax Element | Description |
|---|---|
| TABLE schema.table[:partition] | Specifies the tables or table partitions that must be recovered. The target database must be in read-write mode. |
Before performing the recovery, RMAN checks if there is sufficient space on the target host to store files for the auxiliary instance that is used during recovery. If sufficient space does not exist, then RMAN displays an error message and exits.
You can assign new names for recovered tables or table partitions in the target database by using the REMAP TABLE option.
When the recovered tables are imported into the target database, if a table with the same name exists in the target database, an error message is displayed indicating that the REMAP TABLE clause must be used to rename the tables.
When you recover only certain partitions from a partitioned table, each partition is imported into the target database as separate table. If REMAP TABLE is not used to rename recovered objects, RMAN names each table by using a concatenation of the table name and partition name. The table names of the recovered objects are in the format tablename_partitionname. If a table with this name exists in the target database, RMAN appends _1 to the generated table name. If a table with this name too exists, RMAN appends _2 to the table name, and so on.
See Example 3-8