Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2009
    Posts
    3

    Unanswered: Transfer/Move Data

    I'm trying to discuss Best/Efficient Ways to transfer data from multiple Oracle Databases to a Central Oracle Database.

    We have a requirement to move data from multiple Oracle Databases to a Central Oracle Database periodically and purge the data at source after 'n' number of days.

    We are thinking to build some code that can run in batch and extract data from source in flat files and use SQL Loader/External Tables etc. to load data in the central repository.

    Does anyone have a better way of doing it?

    Thank You

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Does anyone have a better way of doing it?
    DBLINK because there is no need to induce overhead of flat files.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2009
    Posts
    3
    Yes! dblinks can be used but I didn't mention that these are distributed in different geos, hence network can be a constraint so I think breaking the process into pieces could actually help...

    What say?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >hence network can be a constraint
    Is true anytime data gets moved from place A to place B.
    How do flat files improve bandwidth constraint?
    Flat files double amount of disk I/Os to move the data;
    and adds NOTHING to actual solution.

    >so I think breaking the process into pieces could actually help...
    Same can be done via DBLINK.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Sep 2009
    Posts
    3
    Flat files definately have I/O constraints but the data would be extracted from the distributed servers once a day and then the flat file(s) can be compressed and I think compression would turn that file's size to ~1/10 and can be safely copied over to destination and loaded into the primary database.

    Thanks

Posting Permissions

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