Then you are left with no choice than rebuilding your tablespace with new storage parameters to avoid this error.
Printable View
Then you are left with no choice than rebuilding your tablespace with new storage parameters to avoid this error.
Should I just alter tablespace to change the default parameters, Or should I drop the tablespace and recreate it?
Is there any difference between these two?
Thanks!
Altering the parameter when the tablespace is full doesn't help. You have to alter it when you drop few tables (remembered you saying you drop tables monthly) and you have some space over there...
There is difference. If you alter parameter that parameter take effect for the extents that will grown in future(I mean for the tables you will be loading). If you drop and recreate the tablespace, those parameters valid for all the tables you will be loading into tablespace.
Perhaps, you could recreate your tablespaces before you do the import. You might even do something crazy like upgrade to a 32 bit database like 8i. Isn't Oracle 7.1.x a 16 bit database?
The tablespace was empty before the new import. So I change the default parameter for the tablespace to initial 5120k, next 5120k and pct_increaase 0%. But today we did the import again, and the we got the same error message. It did not work!
Can anybody tell me why?
Thanks!
Can anybody tell me why it did not work?
Did you confirm that the storage parameters have been changed from 16384 to 5120K ? Check out your DBA_TABLESPACES view for reflected changes. By any chance are you taking exports of the tables with compress=y ? If so cahnge it to compress=n.
Yes, I did comfirm the change! The compress can only be no in this version!
These three parameters control extent sizes in the tablespace. You should not hit any fragmentation issues after setting this parameters. What error you got this time ?Quote:
Originally posted by lgaorcl
the default parameter for the tablespace to initial 5120k, next 5120k and pct_increaase 0%.
The fool-proof method would be to pre-create your tables with the correct INITIAL, NEXT, and PCTINCREASE values and import with ignore=y.