DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: database links alternative

  1. #1
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    Hi all,

    I have 2 very large databases supporting different applications/projects. what is the alternative to using dblink to retrieve data from either one from another database?

    thanks,
    leonard905
    leonard905@yahoo.com

  2. #2
    Join Date
    Apr 2001
    Posts
    219
    Write a Java program or use imp/exp.
    ______________________
    Applications come and go,
    but the data remains!

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Your application can make two DB connections to gather that data from both side then manually process and sort it. Depending on what you are trying to do this can be a complete pain in the butt and very slow.

    If you want it to be seamless you don't have a lot of choice but to use DB links, but you don't need to use them directly. Rather than having the data distributed you could consider replicating it. Materialized views (snapshots) allow one-way transfer of data, or two-way if the updatable option is used. If you wanted to you could use advanced replication but this increases the complexity drastically.

    Cheers

    [Edited by TimHall on 07-18-2002 at 05:42 PM]
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Tim gave you a very good suggestion. Yes, use the DB links but transfer the data via MVs. This will be the quickest way. Build the MV logs on the first node (this is a quick process). Build then the MVs on the second node. Then distribute it the way you want.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width