Distributed Oracle database link problems

  Concept: 

  Examples of instance-create the database set db_name \ 

  Domain name-domain database as our host and network http address as a domain, such as: us.oracle.com 

  The overall situation of global_name-db_name.domain_name 

  Services of service name-client server to connect to the label name 

  Create: 

  CREATE [PUBLIC] DATABASE LINK Linkname 

  [CONNECT TO username IDENTIFIED By password] 

  [USING'connectstring '] 

  Of which: Linkname the name of the database link 

  Username user accounts 

  password Password 

  connectstring remote database connection string 

  Delete: 

  drop database link linkname; 

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • DZone
  • Netvouz
  • NewsVine
  • Technorati

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button