Tuesday, 15 September 2009

Creating database link

I always tend to get this one wrong. It is simple. The following can be used to create a database link

CREATE DATABASE LINK name_of_link CONNECT TO username IDENTIFIED BY userpassowrd USING 'database_sid'

1 comment:

  1. Good content in this post and site. We need more fresh and good content like this. Thanks for posting great stuff it’s very useful to me
    Oracle Fusion SCM Training

    ReplyDelete