故障描述
删除物化视图信息进行重建,在进行dblink的创建过程时,由于没有删除之前创建的dblink导致新的dblink无法使用之前使用过的名字。
SYS@EMREP> select db_link,owner from dba_db_links;
DB_LINK
--------------------------------------------------------------------------------
OWNER
------------------------------
PROD
PUBLIC
PROD
MVIEWADMIN
SYS@EMREP> create public database link prod
connect to hr identified by hr using 'PROD';
2 create public database link prod
*
ERROR at line 1:
ORA-02011: duplicate database link name
我们看到由于dblink已经存在,无法创建同名的dblink;
先欲将dblink drop掉报如下错误
删除物化视图信息进行重建,在进行dblink的创建过程时,由于没有删除之前创建的dblink导致新的dblink无法使用之前使用过的名字。
SYS@EMREP> select db_link,owner from dba_db_links;
DB_LINK
--------------------------------------------------------------------------------
OWNER
------------------------------
PROD
PUBLIC
PROD
MVIEWADMIN
SYS@EMREP> create public database link prod
connect to hr identified by hr using 'PROD';
2 create public database link prod
*
ERROR at line 1:
ORA-02011: duplicate database link name
我们看到由于dblink已经存在,无法创建同名的dblink;
先欲将dblink drop掉报如下错误
SYS@EMREP> drop database link PROD;
drop database link PROD
*
ERROR at line 1:
ORA-02024: database link not found
SYS@EMREP> drop database link 'prod';
drop database link 'prod'
*
ERROR at line 1:
ORA-01729: database link name expected
连接到dblink的owner用户下再次尝试drop操作
SYS@EMREP> conn mviewadmin/mviewadmin
Connected.
MVIEWADMIN@EMREP> drop database link prod;
Database link dropped.
SYS@EMREP> drop public database link prod;
Database link dropped.
操作成功
drop database link PROD
*
ERROR at line 1:
ORA-02024: database link not found
SYS@EMREP> drop database link 'prod';
drop database link 'prod'
*
ERROR at line 1:
ORA-01729: database link name expected
连接到dblink的owner用户下再次尝试drop操作
SYS@EMREP> conn mviewadmin/mviewadmin
Connected.
MVIEWADMIN@EMREP> drop database link prod;
Database link dropped.
Database link dropped.
操作成功
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29319205/viewspace-1270810/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29319205/viewspace-1270810/