Importing database using 11g imports all packages with debug info
doublevMar 15 2010 — edited Mar 17 2010We are upgrading our database from 9i to 11g using imp/exp. The problem we are seeing is that all packages/procedureas/functions are imported with debug info.
It seems that imp utility is altering import session to set PLSQL_DEBUG=TRUE. Objects on 9i database are not compiled with debug info and we are doing full import with parameters FULL=Y and IGNORE=N.
We did not find any info about this behavior anywhere so we are wondering is this the default behavior, can it be modified so that imported objects are not compiled with debug info and if not, what is the best and most efficient way to drop all debug info on objects that have them? We were hoping to use DBMS_UTILITY.COMPILE_SCHEMA but this will recompile objects preserving debug info on objects that had them before running the command. We can do ALTER PACKAGE COMPILE on all packages and this will solve our problem but it will take a very long time to recompile all of our objects since our database is very large.