merging 2 oracle databases - Page 2 Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: merging 2 oracle databases

  1. #11
    Join Date
    Jul 2006

    >How much downtime can you actually tolerate?
    We can actually bring the databases down for say 30-35 hours on the weekend if required.

    Do you have any long, long/raw, clob or blob columns in your data?
    >NO...its just plain data.....but have huge tables (4-5 tables) containing almost 10 million records each....

    Is your data timestamped?
    >What do you mean by timestamped?

    ixion...thanks for your suggestions....will think over them and get back to you....


  2. #12
    Join Date
    Mar 2002
    Mesa, Arizona
    Does your data have date/time columns like created_on and/or last_mod_on?

    With this you could pick a point in time to copy rows to the new db, backfill using the timestamps, then switch your client/app to the new db with very little downtime. But you've got GOBS of time. Lucky...

    The nice thing about your scenario is that you can do a test migration on your new hardware.

    I'd consider pre-building your tables before you import. It's a good time to look at compression (requires a rebuild or a direct path load to actually compress .. I believe), Index Orgainzed Tables, uniform extents, etc.

    So many things to consider. 30 hours ...

    Bow to your Sensei...
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #13
    Join Date
    Jun 2006
    Quote Originally Posted by reddybc
    ixion...thanks for your suggestions....will think over them and get back to you....
    PM Sent.

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