Home » RDBMS Server » Server Administration » Re: Database Aliases
Re: Database Aliases [message #369144] Fri, 24 March 2000 08:57
vera
Messages: 3
Registered: March 2000
Junior Member
Hello !
If I understood right aleases these are dblinks.
An example for dblink with table EMP in scott(/tiger) schema and service name : 'tcp_boston':
CREATE DATABASE LINK BOSTON
CONNECT TO SCOTT IDENTIFIED BY TIGER
USING 'tcp_boston'

Then it can do select :
SELECT * FROM EMP@BOSTON

Regards, Vera.

Report message to a moderator

Previous Topic: Table Sizing
Next Topic: Re: COST -> RULE based optimizer
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 27 11:17:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.