Select between servers

Scripts Diversos para o Oracle SQL*Plus. (Relacionado a ferramenta Oracle SQL*Plus, para questões de SQL, usar o forum SQL)
Post Reply
prsantos
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 13
Joined: Thu, 21 Feb 2008 4:08 pm
Location: RJ
Paulo Roberto - Desenvolvedor/Analista
(21) 9-7018-4747

Good Morning.


How do I select records from different tables on different servers and different intences without having to create a dblink?

Thank you very much.


ex. Select ...
Top
burga
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Thu, 26 Nov 2009 1:05 pm
Location: SP
Ricardo H. Tajiri

By the database you do not! : Roll:

I do not know if in any application of ETL you can, but I believe not too ...
Top
prsantos
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 13
Joined: Thu, 21 Feb 2008 4:08 pm
Location: RJ
Paulo Roberto - Desenvolvedor/Analista
(21) 9-7018-4747

Huh! Can not run a Select pointing to another instance on another server?
Top
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Contact dr_gori
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

But a dblink is just that!

You register a server, a user, puts his tnsnames on the server you are and it literally connects to the other bank - using the user and password registered.

I do not understand why it can not be dblink: - /
Top
Post Reply

Return to “SQL*Plus”

  • Information

  • Who is online

    Users browsing this forum: No registered users and 11 guests