The recommendation can be checked with a regular check: Data dictionary information/EXP export structure check
1. Check
SELECT * from All_source t WHERE t.owner = ' to query user ' and T.type = ' Package BODY '
SELECT * from user_source where type = ' package '
2.EXP structure. The check method is as follows:
http://blog.csdn.net/ideality_hunter/article/details/52087012
How does Oracle export function and procedure, functions and stored procedures?
1 export to DMP format by using exp in CMD.
2 Export to SQL format using the Tools->export user objects of the Plsql tool. The status is changed from red to black, indicating that the export was successful.
Be careful not to export owner, storage, privilege, and so on.
3. Encryption of stored procedures is also possible. The documentation is as follows:
Http://www.cnblogs.com/matrixworld/p/5446254.html
How Oracle implements the import and export of functions, packages, stored procedures