-
i dropped the dblink and created it afresh with the connector description as below - i got the following result - cudn't undstand from where did UII.US.ORACLE.COM emerge ?????????
SQL> drop database link uii.world;
Database link dropped.
SQL> create database link UII.WORLD connect to strmadmin identified by strmadmi
npd using 'UII.WORLD';
Database link created.
SQL> select * from uii.ar_classes@uii.world;
select * from uii.ar_classes@uii.world
*
ERROR at line 1:
ORA-02085: database link UII.WORLD connects to UII.US.ORACLE.COM
SQL> select * from user_db_links;
DB_LINK
--------------------------------------------------------------------------------
USERNAME PASSWORD
------------------------------ ------------------------------
HOST
--------------------------------------------------------------------------------
CREATED
---------
UII.WORLD
STRMADMIN STRMADMINPD
UII.WORLD
21-SEP-04
SQL>
thanks and regards.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|