ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 关于处理"ORA-00955: 名称已被现有对象占用"的错误

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

原创 Linux操作系统 作者:jianghuiv 时间:2011-04-07 11:26:02 0 删除 编辑

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

解决:   用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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2011-04-04

  • 博文量
    5
  • 访问量
    33614