-
hi,
When I try to drop a user it gives the foll err
The following error has occurred:
ORA-00604: error occurred at recursive SQL level 2
ORA-04052: error occurred when looking up remote object
what is this?
thanx
-
Hi,
The problem is that u are trying to drop a user who has created a table in other remote database.Run the catrpc.sql script found in $ORACLE_HOME/rdbms/admin directory and then try out the command once again.
In case of any help please be free to ask me at rohitsn@altavista.com
Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com
-
But this user is on my local machine?
How is it connected to a remote d/b?
Thank u
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|