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)
delete table works in Toad, but not in SQL*Plus on UNIX [message #533100] Mon, 28 November 2011 05:06 Go to next message
oranooob
Messages: 88
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.

http://i.imgur.com/MIkeX.png

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.
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 Go to previous messageGo to next message
Littlefoot
Messages: 19894
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?
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 Go to previous message
oranooob
Messages: 88
Registered: May 2009
Member
thanks Littlefoot. That was the problem...
Previous Topic: Dynamic Schema Name at runtime.
Next Topic: Oracle SQL Developer Error message
Goto Forum:
  


Current Time: Mon Dec 22 20:32:47 CST 2014

Total time taken to generate the page: 0.10023 seconds