创建表时出现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.
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博客 ” ，链接：https://blog.itpub.net/29668428/viewspace-1169439/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
