关于处理"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/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值