skip to main | skip to sidebar

Oracle stuff

Monday, 8 November 2010

db link full spec

DROP DATABASE LINK "apollo";
CREATE DATABASE LINK "apollo"
connect TO xxxxxx
IDENTIFIED BY "xxxxxxx"
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS=(PROTOCOL=tcp)(HOST=10.24.0.11)(PORT=1521)))(connect_data=(SID=MIS10G1)))';
SELECT * FROM dual@apollo
Posted by Richard E Hall at 07:33 No comments:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2020 (1)
    • ►  February (1)
  • ►  2018 (1)
    • ►  October (1)
  • ►  2014 (11)
    • ►  August (2)
    • ►  June (3)
    • ►  May (3)
    • ►  April (3)
  • ►  2013 (12)
    • ►  December (6)
    • ►  November (1)
    • ►  August (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
  • ►  2012 (9)
    • ►  November (1)
    • ►  August (1)
    • ►  June (1)
    • ►  May (1)
    • ►  March (3)
    • ►  February (1)
    • ►  January (1)
  • ►  2011 (9)
    • ►  November (2)
    • ►  October (1)
    • ►  May (1)
    • ►  March (2)
    • ►  February (2)
    • ►  January (1)
  • ▼  2010 (9)
    • ▼  November (1)
      • db link full spec
    • ►  October (4)
    • ►  June (1)
    • ►  March (2)
    • ►  January (1)
  • ►  2009 (11)
    • ►  November (1)
    • ►  October (2)
    • ►  July (2)
    • ►  April (1)
    • ►  March (1)
    • ►  February (2)
    • ►  January (2)
  • ►  2008 (14)
    • ►  December (2)
    • ►  November (1)
    • ►  August (1)
    • ►  July (2)
    • ►  June (3)
    • ►  March (1)
    • ►  February (4)
  • ►  2007 (36)
    • ►  November (4)
    • ►  October (4)
    • ►  September (5)
    • ►  August (23)

Contributors

  • Richard E Hall
  • Richard Hall