Home / server / Questions / 100039
In Process
Paul Tomblin
Asked: 2010-01-07 06:21:17 +0800 CST

Importing oracle dump file, getting error on stored procedures

  • 772

I export an oracle "schema" using 

exp userid=/ file=pt.dmp log=pt.log owner=FOO buffer=10000000 statistics=NONE direct=Y

and then import it into a different schema on the same oracle instance on the same SID using 

imp userid=/ file=pt.dmp fromuser=FOO touser=paul

When I try to access the stored procedures, I get 

ORA-29541: class PAUL.ESMQOracleStoredProc could not be resolved

Any idea why one user can resolve this but another one can't?

oracle export import stored-procedures

2 Answers

  1. I think you need "FULL" on the export. see this url:

    link text

    • 0

  2. Did you get any failures in the import ? Possibly an object didn't get created or replaced (maybe an object with the same name already existed).

    • 0