_____________________________________________________________________________________ Database Links: http://docs.oracle.com/cd/E11882_01/server.112/e25494/ds_concepts.htm#ADMIN12083 _____________________________________________________________________________________ CREATE AND USE DATABASE LINK ============================ describe DBA_DB_LINKS set pages 1000 set lines 200 grant create database link to scott; connect scott/scottpw create database link SCOTT_LNK connect to scott identified by scottpw using 'SCOTT_LNK.DE.SAMPLE.COM'; create synonym SCOTT_LNK_DF for V$DATAFILE@SCOTT_LNK; create synonym SCOTT_LNK_TS for V$TABLESPACE@SCOTT_LNK; create view SCOTT_LNK_VIEW as select df.NAME dfname, round(df.bytes/1024/1024/1024) bytes, ts.NAME TSNAME from SCOTT_LNK_DF df, SCOTT_LNK_TS ts where df.TS# = ts.TS# and df.NAME like 'C:\ORACLE\ORADATA\HAJO1%'; select OWNER, OBJECT_NAME, OBJECT_TYPE from DBA_OBJECTS where OBJECT_NAME like '%EMP%'; column DFNAME format a60 select * from SCOTT_LNK_VIEW; drop view SCOTT_LNK_VIEW; drop synonym SCOTT_LNK_DF; drop synonym SCOTT_LNK_TS; drop database link SCOTT_LNK; column HOST format a30 column DB_LINK format a30 select DB_LINK, HOST from dba_db_links; create public database link SCOTT_LNK.DE.SAMPLE.COM connect to scott identified by scottpw using 'SCOTT_LNK.DE.SAMPLE.COM'; drop public database link SCOTT_LNK.DE.SAMPLE.COM; _____________________________________________________________________________________