Importing only stored procedures from fullexport.dmp file

[bfunky]

Is there a way to export only stored procedures and packages from a fullexport.dmp file? I have some that keep erroring out and won't recompile. I have imported from a 9i database to a 10G database. There were no errors in the import log file but a have a handful of packages that won't recompile so I thought I would just try re-importing all stored procedures and packages and see what happens. Otherwise it's another 11 hours of import and I don't want to do that if I don't have to.

[marist89]

1. drop the packages
2. imp with ignore=no

Of course, this won't be much faster as imp will have to read the entire .dmp file.

Your better bet would be just fix the packages.