Cannot drop a table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Cannot drop a table

  1. #1
    Join Date
    Aug 2000
    Posts
    33
    Hi,

    I am using Oracle 8i on NT. Recently Iam facing a problem, that is whenever I tried to drop a table it is a giving the following error:

    ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist

    What can be the problem, If anyone have idea on this , will be very much helpful.

    Thanks in Advance
    Ravi

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution:Sorry repeated

    Hi, 9th June 2001 19:06 hrs chennai

    Padmam





    [Edited by padmam on 06-09-2001 at 09:51 AM]
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Re: Solution

    Originally posted by padmam

    Hi, 9th June 2001 19:06 hrs chennai

    Are you able to desc the table ?

    I think your DB has become corrupt contact oracle for support.

    The internal data dictionary tables has some problems.I dont know how secure you have access privilege to users and others to the DB.

    There is one more possiblity which i am sure would not have happened.

    i will investigate and report in this thread.

    Cheers

    Padmam



    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  4. #4
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Can you select data from the table? Who is the owner of the table that you are trying to drop?

  5. #5
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    solution

    Dear Ravi, 9th june 2001 19:36 hrs chennai

    See my investigation this would not have been your problem if so then you can correct it byselectting the table in

    SVRMGR> create table "padu"(a number);
    Statement processed.

    SVRMGR> desc padu
    Column Name Null? Type
    ------------------------------ -------- ----
    A NOT NULL NUMBER

    SVRMGR> select * from padu;
    A
    ----------
    0 rows selected.

    SVRMGR> create table "helloravi" (ravi varchar2(100));
    Statement processed.

    SVRMGR> desc helloravi;
    MGR-00360: object to be described does not exist

    SVRMGR> select * from helloravi;
    select * from helloravi
    *
    ORA-00942: table or view does not exist

    SVRMGR> select * from "helloravi";
    RAVI

    ----------------------------------------------------------

    0 rows selected.

    SVRMGR> drop table helloravi;
    drop table helloravi
    *
    ORA-00942: table or view does not exist

    SVRMGR> drop table "helloravi";
    Statement processed.

    look carefully for the table created in lower case with a cloumn in varchar and number datatype column.The number type data colm table is dropped but not the Varchar column datatype table.

    But this is a problem pertains to one of the errors so as i have said previously you have to contact oracle support.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  6. #6
    Join Date
    Aug 2000
    Posts
    33
    Hi,

    Thanks a lot, But at present Iam facing the problem is not able to create triggers. I had find one more problem is there is no sufficient space in the source where oracle has installed. But I had freed up space about 350mb. But still the problem persists.

    But in log file it is showing only these specified error. At present I couldn't drop any table or infact any objects. I didn't create any table withing "".
    What can be the reason ?

    Thanks in Advance
    Ravi

  7. #7
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Investigate

    Hi, 13th June 2001 15:57 hrs chennai

    I would appreciate a specific error message pasted on this thread you have found while creating the trigger.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  8. #8
    Join Date
    Aug 2000
    Posts
    33

    Dear Padmam,

    The following is the error msg.

    ORA-00036: maximum number of recursive SQL levels (50) exceeded
    ORA-06512: at "ORACLEONLINE.IPTRIG", line 2
    ORA-04088: error during execution of trigger 'ORACLEONLINE.IPTRIG'

    I had tried by increasing value of OPEN_CURSORS. Still the problem persists. I hope the reason is because of unable to update data dictionary while the DDL operations.
    There is no problem with space in Tablespaces as well as in SGA.

    What can be the problem ?

    Thank You
    Ravi

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