Moving Teradata to Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Moving Teradata to Oracle

  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Moving Teradata to Oracle

    If I have a 100 Gig database (incl secondary indexes) on Teradata and want to put it on Oracle, do I need to reserve 100 Gig on the Oracle database?

    The only thing I could think of that might make it that I require more space is the replication of the Primary Index on Oracle (i.e requires no space in Teradata, but I imagine will require some in Oracle).

    Does anyone have any formula, rules etc to follow when considering this move.

    Thanks
    Lee

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    PRI , SEC indx?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Jul 2003
    Posts
    2
    If you are asking me what is a primary index, basically you declare the PI when creating a table, the PI determines how the data will be distributed in the database - this takes up no extra space, unlike a secondary index (or just index on Oracle).

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    OK now I get you, you mean PI is just declaring how space in DB has to allocated for that table.

    I dont think Oracle will need space in KB also when it stores such data in "DICT Objects" mantains the storage prams and so.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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