truncate error,怎么回事

这个表我曾经做了个insert操作,不过由于开会,忘记提交
回来的时候客户端已经断掉
出现了错误,怎么解决呢


SQL> select * from temp_ge
  2  /

no rows selected

SQL> truncate table temp_ge
  2  /
truncate table temp_ge
               *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


SQL> truncate table_temp_ge
  2  
SQL>
SQL>
SQL> truncate table temp_ge
  2  /
truncate table temp_ge
               *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


SQL> truncate table temp_ge
  2  /
truncate table temp_ge
               *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


SQL> delete * from g
  2  
SQL>
SQL> delete from temp_ge
  2  /

0 rows deleted.

SQL> commit
  2  /

Commit complete.

SQL> truncate table temp_ge
  2  /
truncate table temp_ge
               *
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


SQL> select index_name from all_indexes where table_name=TEMP_GE'
  2  /
ERROR:
ORA-01756: quoted string not properly terminated

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8135069/viewspace-136078/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8135069/viewspace-136078/