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

Thread: Urgent!!!! ORA-00604: error occurred at recursive SQL level 1

  1. #1
    Join Date
    Aug 2000
    Posts
    194
    Hi:

    I am trying to alter a table on another users schema.

    I loggen as a dbauser and set the current_schema as the other user and when I try the alter I get the following error.

    $ sqlplus dbausr/pwd

    SQL> alter session set current_Schema=acct_owner_01 ;

    Session altered.

    SQL> alter table customer add deliveryoptions varchar2(15) default 'P' not null ;
    alter table customer add deliveryoptions varchar2(15) default 'P' not null
    *
    ERROR at line 1:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist


    But, I could describe the table

    I could do alter on the same table without any problem, if I omit the default clause.

    SQL> alter table customer add deliveryoptions varchar2(15) ;

    Table altered.

    Does anyone know how to resolve this problem?. (in my case, I can not prefix the table with the owner name.)

  2. #2
    Join Date
    Nov 2000
    Posts
    212
    try to produce SQL trace and look into it (raw file)
    It displays recursive SQL calls and errors.

  3. #3
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    THIS IS A BUG.........don't use alter sesison option for this use....:-)

  4. #4
    Join Date
    Aug 2000
    Posts
    13

    Try this way

    Dont try putting both the constraints together I mean Default and Not null

    It should work

    Regards
    Irfan Khan

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