Avoiding Dynamic Allocation
Disadvantages
Create a locally managed tablespace:
CREATE TABLESPACE user_data_1
DATAFILE ‘oracle8/oradata/db1/lm_1.dbf’
SIZE 100M
   EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 2M;