oracle

Sunday, 5 February 2023

DB Link

 ###

on orcltarget db

conn apptarget/password

create database link orcl_source connect to appsource identified by password using 'orclsouceserver:1521/orcl';

select * from dba_db_links;

owner dblink username Host

apptarget link orcl_source appsource orclsouceserver:1521/orcl



Posted by kundan.oradba at 05:55
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

kundan.oradba
View my complete profile

Blog Archive

  • ▼  2023 (23)
    • ►  March (7)
    • ▼  February (16)
      • Resource limit
      • Fetching the data in excel sheet
      • Partitioned table
      • Objects in the database.
      • Scheduled jobs
      • Temp tablespace datafile
      • archive destination change
      • DB Link
      • Connectivity
      • Tablepsace and datafile command example
      • DDL
      • Table, Schema & Database size
      • killing oracle session
      • v$session
      • SQL Gather stats job running since long time
      • Export and import migration 12cr2 to 19c
  • ►  2022 (3)
    • ►  May (3)
  • ►  2019 (3)
    • ►  March (3)
  • ►  2018 (2)
    • ►  November (1)
    • ►  January (1)
  • ►  2017 (5)
    • ►  December (1)
    • ►  January (4)
  • ►  2016 (12)
    • ►  November (2)
    • ►  October (4)
    • ►  August (3)
    • ►  July (2)
    • ►  April (1)
Watermark theme. Powered by Blogger.