OraFAQ Forum: Client Tools » delete table works in Toad, but not in SQL*Plus on UNIX

Home » SQL & PL/SQL » Client Tools » delete table works in Toad, but not in SQL*Plus on UNIX (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0)

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

delete table works in Toad, but not in SQL*Plus on UNIX [message #533100]

Mon, 28 November 2011 05:06

oranooob
Messages: 84
Registered: May 2009

Member

Hi

When I delete a table in Toad it takes only a one or two secons until I receive success message.

But with SQL*Plus on UNIX I canceled the operation after 5 minutes:

$ sqlplus tmo323/IXQMISX8ttr@PROD

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Nov 28 11:54:22 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> delete table_5
  2  ;
^Cdelete table_5
       *
ERROR at line 1:
ORA-01013: user requested cancel of current operation

exact the same SQL statement.

Report message to a moderator

Re: delete table works in Toad, but not in SQL*Plus on UNIX [message #533102 is a reply to message #533100]

Mon, 28 November 2011 05:09

Littlefoot
Messages: 16993
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I suppose there was another transaction within the same (TOAD) session, such as INSERT or UPDATE which was never committed (nor rolled back). TOAD doesn't care about it because - well, it is the same session.

SQL*Plus started another session and has to wait for TOAD to commit or rollback, because it (TOAD) "holds" the table. So: go to TOAD and commit. Go to SQL*Plus and delete table_5. What happens?

Report message to a moderator

Re: delete table works in Toad, but not in SQL*Plus on UNIX [message #533103 is a reply to message #533102]

Mon, 28 November 2011 05:16

oranooob
Messages: 84
Registered: May 2009

Member

thanks Littlefoot. That was the problem...

Report message to a moderator

Previous Topic:	Dynamic Schema Name at runtime.
Next Topic:	Oracle SQL Developer Error message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 03:38:32 CDT 2013

Total time taken to generate the page: 0.14538 seconds