Tuesday, December 22, 2015

Create/Delete database link

CREATE:
CREATE DATABASE LINK my_db_link CONNECT TO current_user USING 'my_db';
CREATE PUBLIC DATABASE LINK my_db_link CONNECT TO remote_user IDENTIFIED BY psicorp
USING 'my_db';
DROP:
DROP DATABASE LINK my_db_link;

DROP PUBLIC DATABASE LINK my_db_link;

No comments:

Post a Comment

How to Create TEMPORARY tablespace and drop existing temporary tablespace in oracle 11g/12c

1. Create Temporary Tablespace Temp create temporary tablespace temp2 tempfile '/mnt/mnt04/oradata/temp01.dbf'size 2000M;  2. Move D...