OraFAQ Forum: Server Administration » Cannot drop a table (merged 3)

Home » RDBMS Server » Server Administration » Cannot drop a table (merged 3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot drop a table (merged 3) [message #382688]

Fri, 23 January 2009 10:28

eagyeman
Messages: 6
Registered: May 2007

Junior Member

Oracle version is 10.2.0.1.0 on Linux.

I am trying to drop a table and I have issued both commands below to drop it which is a straigth forward drop, but none works.

drop table test cascade constraints;
drop table test;

It hangs for a long time. It is a small table with only about 30 records in it. When i issue any commnad against the table it hangs -- select, delete, update. There is nothing written in the alert log file to indicate a corruption or anything. when I check the status in dba_tables, it shows it as valid. Is there anyway I can zap this table and recreate it.

Is there anyway to do this?

Report message to a moderator

Re: Cannot drop a table [message #382692 is a reply to message #382688]

Fri, 23 January 2009 10:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I suspect that a session did a DML against this table & has not yet issued a COMMIT or ROLLBACK.
Oracle won't drop a table which has a pending transaction against it.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

[Updated on: Fri, 23 January 2009 10:35]

Report message to a moderator

Re: Drop Table [message #382694 is a reply to message #382688]

Fri, 23 January 2009 10:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

STOP reposting same question.
Once is enough!

Report message to a moderator

Re: Drop Table [message #382696 is a reply to message #382688]

Fri, 23 January 2009 10:42

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Activate a trace on the session to know on what it is waiting.
You can also query v$session_wait.

Regards
Michel

Report message to a moderator

Re: Unable to drop table [message #382704 is a reply to message #382688]

Fri, 23 January 2009 11:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

STOP reposting same problem!

Report message to a moderator

Re: Unable to drop table [message #382705 is a reply to message #382688]

Fri, 23 January 2009 11:45

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Now you are spamming with your question.
Follow what has been said.
I lock the topic.

Regards
Michel

[Updated on: Fri, 23 January 2009 11:46]

Report message to a moderator

Re: Unable to drop table [message #382761 is a reply to message #382705]

Sat, 24 January 2009 07:18

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

topic unlocked, so poster can continue in this thread instead of starting another one

Report message to a moderator

Re: Unable to drop table [message #382767 is a reply to message #382761]

Sat, 24 January 2009 09:00

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

He also could PM or report the message to get the topic unlocked.

Regards
Michel

Report message to a moderator

Previous Topic:	Problem with Temporary Tables
Next Topic:	Brave new stats in 11.1.0.7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 16:02:35 CST 2024