If using datapump, the option is SQLFILE.
The file_name specifies where the import job will write the DDL that would be
executed during the job. The SQL is not actually executed, and the target system
remains unchanged. The file is written to the directory object specified in the
DIRECTORY parameter, unless another directory_object is explicitly specified
here. Any existing file that has a name matching the one specified with this parameter
is overwritten.
Example:
impdp hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp SQLFILE=dpump_dir2:filename
If using original import the option is SHOW=Y.
The SHOW parameter can be used only with the FULL=y, FROMUSER, TOUSER, or
TABLES parameter.
No comments:
Post a Comment