DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: help needed

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    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

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    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

  3. #3
    Join Date
    Jun 2001
    Posts
    316
    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
  •  


Click Here to Expand Forum to Full Width