DB Migration
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: DB Migration

  1. #1
    Join Date
    Mar 2002
    Posts
    301

    DB Migration

    Hi ,

    i want to migrate a DB from Oracle 9i to Oracle10g.
    How is the best method to do this.
    The new db wil be on another server as the last one and my DB is 3 Tera Byte big.


    Bensmail

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    same os or different os? how do you plan to move 3tb of data between servers?

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    I don't plan yet.
    They will be on different OS.

    I think exp/imp will be heavy.
    DBCA I think we must be on the same server to use it.

    Any Idea?

    Bensmail

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    upgrade current server to 10g and then use TTS might be your fastest method

  5. #5
    Join Date
    Mar 2002
    Posts
    301
    What's TTS? Is that Trasportable Tablespace?
    If this is the case? should i create first all users in target DB?


    bensmail

  6. #6
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    You have two options:

    1. Upgrade to 10g and then TTS.
    2. Exp/imp 9i to 10g accross platforms (refer metalink doc 277650.1).

    I think both is going to cost you the same.

    Choice is yours!

    Goodluck!!
    "What is past is PROLOGUE"

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no they wont cost the same, the import on the new server will be much quicker with TTS as the actual data doesnt have to be imported, only the metadata

    Yes you will need to create the users

  8. #8
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    what do you mean with upgrade and than TTS?


    Upgrade that what i want to do? Can you please develop?

    Thanx
    Bensmail

  9. #9
    Join Date
    Mar 2002
    Posts
    301
    Should i export with Full=Y and ROWS=N and import in the new db.
    And than TTS!

    Bensmail

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    tim to read the manuals for transportable tablespaces I believe

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