Shrink Oracle Tablespace

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:

SHRD0014: GLLEZL - process exiting with failure

  SYMPTOMS Journal Import completes with the following error: Error ------ ORA-01653 : unable to extend table GL.GL_IMPORT_REFERENCES ORA-01...