Default: NO
Purpose
Specifies whether the import job should reuse existing data files for tablespace creation.
Syntax and Description
REUSE_DATAFILES=[YES | NO]
If the default (n
) is used and the data files specified in CREATE TABLESPACE
statements already exist, then an error message from the failing CREATE TABLESPACE
statement is issued, but the import job continues.
If this parameter is specified as y
, then the existing data files are reinitialized.
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. See "FULL".
> impdp hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp LOGFILE=reuse.log REUSE_DATAFILES=YES
This example reinitializes data files referenced by CREATE
TABLESPACE
statements in the expfull.dmp
file.