Printable View
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
PRI , SEC indx?
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.