-
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
-
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
-
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
-
Can you select data from the table? Who is the owner of the table that you are trying to drop?
-
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
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|