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

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


Popular posts from this blog

Find and replace with sed command in Linux

Find and replace feature is always handy. It can turn into a torture when it comes to change or delete a simple constant string in a text file. There is a handy tool in linux for doing these kind of tihngs. Actually sed is not a text editor but it is used outside of the text file to make changes.