This content has been marked as final. Show 4 replies
malhi wrote:use this DBMS_METADATA.
Is there any way we can import a package from existing dump file.
Also Similar thread
spool test.sql select 'dbms_metadata.....(' ||owner||'.'||object_name||');' from all_objects where owner = 'UR_OWNER' and object_type in ('PACKAGE','PACKAGE BODY','PROCEDURE','FUNKTION'); spool off;
You can do this from an existing Data Pump dump file, but not from an old exp/imp dumpfile.
There are 2 ways to do this. Both were listed here.
1. sqlfile option. impdp and use sqlfile=pkgs.sql include=package_body ... then look at the pkgs.sql file to find the packages you want.
2. include=package_body:"in ('PKGA', 'PKGB')
You can use #2 as part of the sql file (#1) if you want to make your .sql file smaller.