Purpose
Specifies whether or not the import job should reuse existing datafiles for tablespace creation.
Syntax and Description
REUSE_DATAFILES={y | n}
If the default (n
) is used and the datafiles specified in CREATE TABLESPACE
statements already exist, an error message from the failing CREATE TABLESPACE
statement is issued, but the import job continues.
If this parameter is specified as y
, a warning is issued and the existing datafiles are reinitialized. Be aware that specifying Y
can result in a loss of data.
Example
The following is an example of using the REUSE_DATAFILES
parameter. You can create the expfull.dmp
dump file used in this example by running the example provided for the Export FULL
parameter.
> impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp LOGFILE=reuse.log
REUSE_DATAFILES=Y
This example reinitializes datafiles referenced by CREATE
TABLESPACE
statements in the expfull.dmp
file.
No comments:
Post a Comment