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

Thread: COPY FROM vs Materialized view

Hybrid View

  1. 05-12-2004, 10:58 PM #1
    zainalj's Avatar
    zainalj
    zainalj is offline War advisor
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116

    Lightbulb COPY FROM vs Materialized view

    Hi,
    i want to make DB A and DB B tally at 12:00am. The master DB is A. I want to perform select,update and insert to DB B. What would be the best method to make DB B tally with DB B? Is it using "COPY FROM ..." or Materialized view?

    - DB A and DB B at different Machine.


    Thanks.
    The man called Zorro
    Reply With Quote Reply With Quote
  2. 05-13-2004, 01:03 AM #2
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I would use materialized views, or a server-side procedure running through a db link, so that the process can be controlled by the server without any client-side scheduling.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  3. 05-13-2004, 02:14 AM #3
    zainalj's Avatar
    zainalj
    zainalj is offline War advisor
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    slimdave, if "copy from .." sql command i put on the server.. it will consider server-side programming..
    i really in doubt about of choosing this two method..
    The man called Zorro
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width