-"ALTER tablespace «tablespace name» coalesce space;"
(in svrmgrl if you have split space in your tablespace).
-Do create a tablespace for your own data. Indexes on one other tablespace.
Do not use system tablespace.
-ReSize properly the extent size of your tables.Keep your pctincrease 0.
-"alter table «table name» deallocate unused; "
Deallocates space until High-Water-Mark
If you are using unix and you definitly have to use exp/imp. Speed up your
tasks.
1º " exp user/pwd file=filename statistics=NONE indexes=N"
the rest you should use what it adapts best.
2º exp user/pwd file=struct rows=N
to get the structure of the DB
3. truncate your data (This you know)
4º imp user/pwd file=filename .......
5º imp user/pwd file=struct indexfile=index
grep -v 'REM' index.sql>index1.sql
6º sqlplus user/pwd @index1.sql
This should be fast enough.
J. Meirim
Alon Gilad wrote in message <362CBBFD.2B69_at_rts.co.il>...
>"Oracle does not free up space in the system table space. "
>" Is there any way to free this space other than doing a complete
>export/import of the DB ? "
>Alon
Received on Thu Oct 22 1998 - 05:47:08 CDT
