can we alter initial storage value for a table.
when i execue the following statement i am getting an error
ORA-02203: INITIAL storage options not allowed
alter table test storage(initial 200MB, next 100MB);
the reason i am trying to alter the initial storage segment is i have a table which has about 2 million records and i ia m trying to import this table data into test table which is in another instance an dhas the initial storage segment very small.
you cannot, you either move the table which is equivalent to a rebuild or export the table, then before import create an empty table with same structure and new storage parameters then import with ignore=y