SELECT DBMS_METADATA.GET_DDL(owner,object_name,object_type) FROM user_objects WHERE object_type='PACKAGE';If you save the output in a file (with the SPOOL command in SQL*Plus) you now have a script to run on any other database.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.