-
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
-
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"
-
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).
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|