oracle查询时出现00955,创建表时出现ORA-00955: name is already used by an existing object

今天练习闪回查询时出现以下错误

SQL> create table test as select * from dept;

ORA-00955: name is already used by an existing object

查询一下：

SQL> select OBJECT_NAME,CREATED,STATUS,TIMESTAMP from user_objects where OBJECT_name='TEST';

发现有同名的存储过程，于是做了如下查询：

SQL> select OBJECT_NAME,CREATED,STATUS,TIMESTAMP from user_objects where OBJECT_TYPE='PROCEDURE';

或

SQL> select * from all_source where type='PROCEDURE';

然后将其drop掉：

SQL> drop procedure test;

Procedure dropped.

在创建，发现成功了。

SQL> create table test as select * from dept;

Table created.

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