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

Thread: drop user cascade

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    drop user cascade

    i want to drop the user nctexmis_test and i used the following
    but i got the following error

    SQL> drop user nctexmis_test cascade;
    drop user nctexmis_test cascade
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04021: timeout occurred while waiting to lock object NCTEXMIS.YRN_DELIVERY_CHALLAN_DETAIL

    can anybody tell me what this error means?

  2. #2
    Join Date
    Feb 2007
    Posts
    1
    Please look into the DBA_DDL_LOCKS view.

  3. #3
    Join Date
    Sep 2006
    Posts
    114
    Quote Originally Posted by M.Shakeel Azeem
    i want to drop the user nctexmis_test and i used the following
    but i got the following error

    SQL> drop user nctexmis_test cascade;
    drop user nctexmis_test cascade
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04021: timeout occurred while waiting to lock object NCTEXMIS.YRN_DELIVERY_CHALLAN_DETAIL

    can anybody tell me what this error means?

    i has also faced the same error while i was trying to import the schema into separate test DB server

    ORA-04021: timeout occurred while waiting to lock object NCTEXMIS.YRN_DELIVERY_CHALLAN_DETAIL

    its very confusing for me why i am getting this error?

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