querying over multiple database links
From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Tue, 5 Jul 2011 08:01:50 -0700 (PDT)
Message-ID: <9cc3e816-8ce7-4b92-83bb-9f4da6b4ea34_at_e17g2000prj.googlegroups.com>
on database remote1 is a table I want to access => table1 I have a very limited schema/user created on remote2.
Date: Tue, 5 Jul 2011 08:01:50 -0700 (PDT)
Message-ID: <9cc3e816-8ce7-4b92-83bb-9f4da6b4ea34_at_e17g2000prj.googlegroups.com>
on database remote1 is a table I want to access => table1 I have a very limited schema/user created on remote2.
remote2 has public database link to remote1, so I can access table1_at_dblink_to_remote1
I have another local database db1 with database link to remote2 => _at_dblink_to_remote2
I would like to create a table from remote1 on my local db1. I can achieve that with export/import (giving remote2 credentials).
Is there a better solution for that task?
thanks,
chris
Received on Tue Jul 05 2011 - 10:01:50 CDT