Re: Help with Database Link

David Kent wrote:
> Hi,
> I have an account on each machine '...david identified by kent' which I
> have granted connect, resource and dba privileges.
>
> When I log on to machine 1 as david/kent, I created a db link as
> follows:
>
> create database link REMOTE_CONNECT
> using 'otherhost';
>
> This command works fine.
>
> I then try the following command:
>
> select * from junk_at_REMOTE_CONNECT;
>
> The machine hangs for a minute or 2, then I get back to the Unix promt
> and I have a core dump. (I have created a table named junk on machine
> 2.)
>
> If anyone knows if this is a Workgroup server problem, or if I am doing
> something wrong (or missing something in my init.ora file), I would
> appreciate some help.

Hi David,

Did you name database link as per guidelines? Have a look at SQL Reference Manual for details.

Atul Ashar Received on Tue Feb 18 1997 - 00:00:00 CST