Master OracleApps

Pages

  • Home
  • XML Publisher
  • UTL_FILE

Thursday, April 2, 2015

DB LINK Creation 


CREATE DATABASE LINK "DB_LINKNAME"
 CONNECT TO user_name
 IDENTIFIED BY password
 USING '(DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=HOST_NAME)
      (PORT=1523)
    )
    (CONNECT_DATA=
      (INSTANCE_NAME=INS_NAME)
      (SERVICE_NAME=SERVICE_NAME)
    )
  )';
Posted by siva at 4:55 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

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

Blog Archive

  • ►  2018 (3)
    • ►  May (2)
    • ►  January (1)
  • ▼  2015 (12)
    • ▼  April (12)
      • AR Invoice Information: SELECT rct.trx_number,...
      • ATTACHMENTS AT FORM Level: SELECT fds.short_te...
      • DB LINK Creation  CREATE DATABASE LINK "DB_LINK...
      • UPDATE Person Details Through API: /******...
      • UPDATE Organization Details Through API: /*****...
      • UPDATE Customer Account Details Through API:  DE...
      • KILL THE SESSIONS: SELECT * FROM  v$access WHER...
      • Organization  and Classifications Through API: ...
      • TCA Queries The SQL queries involving follow...
      • FND_PROFILE AND FND_GLOBAL:  Following are ...
      • Pick Confirm using API: INV_PICK_WAVE_PICK_CONF...
      • Email Sending Program by using UTL_SMTP Mail. P...
  • ►  2013 (40)
    • ►  April (29)
    • ►  March (4)
    • ►  February (7)

About Me

siva
View my complete profile
Picture Window theme. Powered by Blogger.