Storage INITIAL
Hi everyone,
I was wondering if anyone can advise me on this? The [http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/logical.htm|documentation] is not very helpfull to me.
Imagine I have a huge table of 10g unpartioned and I would like to partition it by a given date. But I don't need to it online. So, I may create a new table, copy the data and then rename the table to the old name.
The table that needs to be redefined is more than 10GB. So, I was wondering if I create the new table and specify a STORAGE (INITIAL 10G and NEXT 1G) is ok?
Because, on the tablespace, I have initial_extent is 65536 (64MB), next_extends is NULL and max_extends is 2147483645 (1.99GB). The initial seems to be very small to me. Also, the table is growing very fast (500MB a week). And in that table, I'm only going to have inserts (99.9 % of inserts and 0.1% select - no update, no delete). The tablespace is defined in auto for automatic segment space managment.
What advise can you give me to create that new table?
Thanks in advance for your answers