Skip to main content

Oracle datapump import only a package

In the par file INCLUDE/EXCLUDE parameters can be added in order to filter metadata. For instance only a package can be imported:

Content of the par file:
DIRECTORY = export_dir
DUMPFILE = exported_data.dmp
LOGFILE = import_only_package.log
INCLUDE = PACKAGE:"= 'PKG_NAME_HERE'"


import command here:
$ impdp schema_name_here@sid_name_here PARFILE=parfile.par

Comments

Popular posts from this blog