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.
Previous Topic: Table Sizing
Next Topic: Re: COST -> RULE based optimizer
Goto Forum:
  


Current Time: Fri Oct 23 17:25:40 CDT 2020