Importing oracle dump file, getting error on stored procedures

Question

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?

score 0 · Answer 1 · answered Jan 06 '10 at 14:52

0

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

answered Jan 06 '10 at 14:52

gm3dmo

score 0 · Answer 2 · answered Jan 06 '10 at 21:45

0

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).

answered Jan 06 '10 at 21:45

Gary

Nope. As a matter of fact, when I browse the database using SQLDeveloper, I can see the stored procedures there. – Paul Tomblin Jan 07 '10 at 00:27

2 Answers2