Re: querying over multiple database links

Giganews Newsgroups
Subject: Re: querying over multiple database links
Posted by:  gazzag (justifi…@jamms.org)
Date: Tue, 5 Jul 2011

On Jul 5, 4:01=A0pm, Krzysztof Cierpisz <ciape.…@gmail.com> wrote:
> on database remote1 is a table I want to access =3D> table1
> I have a very limited schema/user created on remote2.
>
> remote2 has public database link to remote1, so I can access
> table1@dblink_to_remote1
>
> I have another local database db1 with database link to remote2 =3D>
> @dblink_to_remote2
>
> I would like to create a table from remote1 on my local db1.
> I can achieve that with export/import =A0(giving remote2 credentials).
>
> Is there a better solution for that task?
>
> thanks,
> chris

CREATE TABLE <table_name>
AS SELECT * FROM <table_name>@<remote_database>;

HTH
-g

Replies

In response to

querying over multiple database links posted by Krzysztof Cierpisz on Tue, 5 Jul 2011