Saturday, January 2, 2016

How to find DB links in Oracle??

select * from DBA_DB_LINKS   - All DB links defined in the database.
select * from ALL_DB_LINKS    - All DB links the current user has access to.
select * from USER_DB_LINKS - All DB links owned by current user.

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...