Importing oracle dump file, getting error on stored procedures
Posted
by Paul Tomblin
on Server Fault
See other posts from Server Fault
or by Paul Tomblin
Published on 2010-01-06T14:21:17Z
Indexed on
2010/03/27
0:03 UTC
Read the original article
Hit count: 409
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?
© Server Fault or respective owner
