Home » RDBMS Server » Server Administration » Cannot drop a table (merged 3)
Cannot drop a table (merged 3) [message #382688] Fri, 23 January 2009 10:28 Go to next message
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?
Re: Cannot drop a table [message #382692 is a reply to message #382688] Fri, 23 January 2009 10:35 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
STOP reposting same question.
Once is enough!
Re: Drop Table [message #382696 is a reply to message #382688] Fri, 23 January 2009 10:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Unable to drop table [message #382704 is a reply to message #382688] Fri, 23 January 2009 11:39 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
STOP reposting same problem!


Re: Unable to drop table [message #382705 is a reply to message #382688] Fri, 23 January 2009 11:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
topic unlocked, so poster can continue in this thread instead of starting another one
Re: Unable to drop table [message #382767 is a reply to message #382761] Sat, 24 January 2009 09:00 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
He also could PM or report the message to get the topic unlocked.

Regards
Michel
Previous Topic: Problem with Temporary Tables
Next Topic: Brave new stats in 11.1.0.7
Goto Forum:
  


Current Time: Sun Dec 04 22:28:12 CST 2016

Total time taken to generate the page: 0.06861 seconds