How to export Oracle Database and packages

/*By Jiangong SUN*/

Export a oracle database for a specific schema in command line is an easy task.

Here is how I did:

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

/*get a specific stored procedure*/

SELECT DBMS_METADATA.GET_DDL('PACKAGE','packageName') FROM dual;

/*get all schemas*/

SELECT * FROM dba_users;

/*get all packages for a specific user/schema*/

SELECT * FROM all_objects WHERE OBJECT_TYPE ='PACKAGE' and owner='schemaName' order by object_name asc;

/*command for export packages*/

expdp user/password schemas=schema_name include=package directory="d:\" dumpfile=exportPackages.dmp logfile=exportPackages.log

reference: 

http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php

http://www.oracle-base.com/articles/misc/recompiling-invalid-schema-objects.php

http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/sqloperations.htm#BABHICAF

Enjoy coding !