First page Back Continue Last page Graphics
…Data Pump Features…
Import remapping capabilities
- Change name of datafiles
- Change owner
- Change tablespace
Reuse existing datafiles
Notes:
Datapump provides three import parameters for changing the attributes of objects in the dump file:
REMAP_DATAFILE – Change the name or path of the datafile. In addition to simple renaming and path changes when importing to a different server, this provides a method of importing from different platforms. Note that I have not been able to get this parameter to support ASM.
REMAP_SCHEMA – Similar to the TOUSER parameter supplied with original import, this provides the ability to import into a different schema from which it came. Note that if import creates a new user the password is invalid (to prevent unauthorized logins) and must be changed before login.
REMAP_TABLESPACE – Place all imported objects in the specified target tablespace.
The REUSE_DATAFILES parameter, when set to “Y”, will reinitialize and reuse any existing datafiles when the CREATE TABLESPACE statement is executed. The default is “N”; if the datafile exists, in this case an error is generated from the CREATE TABLESPACE, but the job continues.