Cannot drop a table

[helloravi]

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

[padmam]

Hi, 9th June 2001 19:06 hrs chennai

Padmam





[Edited by padmam on 06-09-2001 at 09:51 AM]

[padmam]

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

[irehman]

Can you select data from the table? Who is the owner of the table that you are trying to drop?

[padmam]

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

[helloravi]

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

[padmam]

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

[helloravi]

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