Export Metadata only in packages
Good Day Sir/Ma'am,
I would like to know if there are any other way to export or generate metadata ddl only for packages,triggers and sequence only. I tried the following
DBMS_METADATA.GET_DDL - but it requires editing when we want to run the text from SQL
Below is the export version, but it includes the other objects.
expdp user/passwd directory=DUMPDIR CONTENT=METADATA_ONLY dumpfile=dumptest.dmp schemas=scott logfile=dumptest.log
impdp user/passwd directory=DUMPDIR dumpfile=dumptest.dmp sqlfile=metaddl.sql logfile=imp_dumptest.log
The only objects I wanted to get the dll is PACKAGES, TRIGGGERS and SEQUENCE only.
I would like to know if there are any other way to export or generate metadata ddl only for packages,triggers and sequence only. I tried the following
DBMS_METADATA.GET_DDL - but it requires editing when we want to run the text from SQL
Below is the export version, but it includes the other objects.
expdp user/passwd directory=DUMPDIR CONTENT=METADATA_ONLY dumpfile=dumptest.dmp schemas=scott logfile=dumptest.log
impdp user/passwd directory=DUMPDIR dumpfile=dumptest.dmp sqlfile=metaddl.sql logfile=imp_dumptest.log
The only objects I wanted to get the dll is PACKAGES, TRIGGGERS and SEQUENCE only.
0