Oracle has several commands to reclaim unused
disk space for objects (tables and indexes).
Using the "alter table table_name shrink space
compact" command also has the benefit of
making full-table scans run faster, as less
block accesses are required. With
standard Oracle tables, you can reclaim
space with the "alter table shrink space"
command:
SQL> alter table mytable enable row movement;
Table altered
SQL> alter table mytable shrink space;
Table altered
Example:-
Actually I have gigabytes and gigabytes of tablespaces but most of them are used partially.
I heard that there is possibility to shrink them, the size of the tb will be exactly the size of the data (automatically increase) till reach the maximum defined.
I explain better my question:
Tb1 (size 10 gb)
1) NOW - dbf file of 10 gb - Data inside 1 gb
2) MY DREAM - dbf file of 1 gb - Data inside 1 gb
- Automatically increase with the data till 10gb .. at that time
tb full.
No comments:
Post a Comment