-
Hi,
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.
thanks
-
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..
Thank You
-
Originally posted by pando
ctas
ctas = CREATE TABLE AS SELECT
Jeff Hunter
-
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;
Cheers,
OCP 8i, 9i DBA
Brisbane Australia
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|