Menu
I am using SQL Developer 3.0.04 and am trying to export a package. I have 2 questions:
Can I export both package specification and body in a single export (resulting in 1 export.sql file)?
The export.sql file is somewhat compressed, any way I can have it in text format with linefeeds etc so I can read it better?
253
Using the main menu, select Tools->Database Export. An Export wizard will open. At the top of the screen, enter a directory and file name.
Go to VIEW menu, click on find DB objects option. In the find db object pane put the name of the package and select the DB. Both, the spec and body will appear, double click to open.
SELECT DBMS_METADATA. GET_DDL('TABLE', TABLE_NAME) FROM USER_TABLES; Next way to get separate DDL scripts is to : Go to FILE -> DATA MODELLER -> EXPORT -> DDL FILE.
In SQL-Developer right click the Package Specification and select Save Package Spec and Body... This will generate one file with both the spec and body.
133
Instead of navigating to the package object and doing export there, use \Tools\Database Export to generate a single file.
21
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
