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
or you can use ctas, there are several ways
If i alter the next storage segments will that work..
when i try to use the cats from the user using a database link it says "Connection Description for remote database not found"
but when i look at the database links i see them..
i am not undertanding where the problem is..
ctas = CREATE TABLE AS SELECT
Originally posted by pando
As Jeff suggested you can use the CREATE TABLE AS SELECT, just remember also, you'll need to recreate your indexes and issue grants again to the newly table.
Sometime what I do is
a). CREATE TABLE new_table_temp AS ...
b). Take note of the grants adn indexes.
c). Drop the OLD table
d). CREATE TABLE old_name AS SELECT * FROM new_table_temp
e). Create indexes etc and grants
f). Drop table new_table_temp;
OCP 8i, 9i DBA
Click Here to Expand Forum to Full Width