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

Thread: Extracting a data

  1. 09-24-2003, 05:31 AM #1
    bang_dba
    bang_dba is offline Senior Member
    Join Date
    Sep 2002
    Posts
    376

    Extracting a data

    I have to extract some data from a table in Database A to Database B.
    The table structure on both the d/b are same. A daily job will extract the data from A to B using a DB link.

    What is the best way to ensure that only newly inserted records in the table in A is extracted to the table in B.
    Can somebody give me the common logic used.
    Reply With Quote Reply With Quote
  2. 09-24-2003, 05:56 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Do you have a timestamp or sequence column in the table, if so this is probaly the best way to select the data to be copied. Otherwise you could consider using MERGE

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 10-06-2003, 06:01 AM #3
    bang_dba
    bang_dba is offline Senior Member
    Join Date
    Sep 2002
    Posts
    376
    Thanx jovery,
    Can u pls explain me how this MERGE can be done....?
    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