Moving Teradata to Oracle

[lbrown37]

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

[abhaysk]

PRI , SEC indx?

[lbrown37]

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).

[abhaysk]

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.