|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
> I have another local database db1 with database link to remote2 =3D>
> 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?
CREATE TABLE <table_name>
AS SELECT * FROM <table_name>@<remote_database>;
querying over multiple database links posted by Krzysztof Cierpisz on Tue, 5 Jul 2011