Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    11

    Unanswered: Versioning enabled

    Hi,

    I tried to drop a user from a database,but i got the following error:-

    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-20031: All version enabled tables owned by 'PAY_MASTER' must be disabled
    first.
    ORA-06512: at "SYS.WM_ERROR", line 288
    ORA-06512: at "SYS.WM_ERROR", line 305
    ORA-06512: at "SYS.NO_VM_DROP_PROC", line 40
    ORA-06512: at line 3

    I understand that once version is enable i will not be able to directly disable it.How can I disable the version so that i can drop the user.
    I am aware that there is a 'purge' method but i do not know how to use it.
    please advice.
    thanks.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    drop user casade constraints;

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    sorry might be drop user cascade ;

    the cascade constraint is for tables explicitly

  4. #4
    Join Date
    Mar 2003
    Posts
    11
    Hi,

    I tried both - drop user pay_master cascade and drop table salary_pm cascade constraints for both i am getting the error below.

    drop table salary_pm_LT cascade constraints
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-20061: versioned objects have to be version disabled before being dropped
    ORA-06512: at "SYS.WM_ERROR", line 288
    ORA-06512: at "SYS.WM_ERROR", line 297
    ORA-06512: at "SYS.NO_VM_DROP_PROC", line 60

    SQL> drop user pay_master cascade;
    drop user pay_master cascade
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-20031: All version enabled tables owned by 'PAY_MASTER' must be disabled
    first.
    ORA-06512: at "SYS.WM_ERROR", line 288
    ORA-06512: at "SYS.WM_ERROR", line 305
    ORA-06512: at "SYS.NO_VM_DROP_PROC", line 40
    ORA-06512: at line 3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •