help: create database link

From: <guanjian_at_my-dejanews.com>
Date: Mon, 01 Mar 1999 14:57:07 GMT
Message-ID: <7be9rt$hte$1@nnrp1.dejanews.com>

hi,

i have a problem on create a database link.

i have two server sun1, sun2, on themi installed oracle database. at sun1 net8 i config the service svr as local, sun2_svr point the database server on sun2.
at sun2 net8, svr as local,sun1_svr as the database server on sun1.

now at sun2, i create a database link:
create database link sun1_svr

	connect to system identified by manager
	using 'sun1_svr';

but when i use the database link, error reported:

SQL: select * from test_table_at_sun1_svr; ERROR: ORA-02085: database link SUN1_SVR.WORLD connects to 805.WORLD

and i change the database link name, still get this error.

who can tell me, how to use the database link?

thanks a lot

yours
probing

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 08:57:07 CST