关于处理"ORA-00955: 名称已被现有对象占用"的错误

产生情形一：命名重复  ：名称并不一定是表,还可以是其它对象,如视图,快照

解决：   用desc   命令看一下是否已经存在该对象（也许跟索引、序列、视图等重名了）  ，

                 若有放弃用这个命名，若不是根据错误提示再解决。

产生情形二：再配置OEM 时出现，我再配置时，查看日志记录，前面都正确，就在最后一行出现：

                 第1行出现错误：ORA-00955: 名称已被现有对象占用"的错误

查找资料

     Cause: An attempt was made to create a database object (such as a table, view, cluster, index, or synonym) that already exists. A user's database objects must have distinct names.
Action: Enter a unique name for the database object or modify or drop the existing object so it can be reused.  
 
 Posts about ORA-00955
ORA-00955: name is already used by an existing object
Can any one tell me why I get this error? Surely if using CREATE OR REPLACE it should not matter if the object already exists? CREATE OR REPLACE PACKAGE package_printertype_scitex AS * ERROR at line
DATAFILE??
On 10/18/05 oracle-l-bounce@(protected) <oracle-l-bounce@(protected) > wrote > > The best way to find out is to try it. You will probably find that it > depends. If you use a LMT and do uniform. e
Debug DDL trigger
Not true see below for an example on 9204 SQL > get t1.sql 1 conn t1/t1 2 create table t1.some_tbl tablespace cons 3 as select * from dba_objects where rownum < 100 4 / 5 drop trigger raj_test_trig 6
10.1.0.4 patchset 2 catcpu.sql slop
w2k3 server std ed 32 bit. Oracle 10g R1 10.1.0 patchset 3 applied (10.1.0.4) While running the 10.1.0.4 patchset 2 post-installation script. (catcpu.sql) against a newly created database there
replication with Indexes
Hi If we run the sql as you suggested will show error ORA-00955 name is already used by an existing object Pl advice >From Stephen.Lee@(protected) >Reply-To oracle-l@(protected) >To oracl
 

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

转载于:http://blog.itpub.net/25595756/viewspace-691862/