How can I change the initial_extent of a tablespace
I have created a tablespace as follows:
create tablespace MD_DATA
datafile'/opt/app/oradata01/HMPROD/md_data_01.dbf' size 30000m
extent management local autoallocate;
The tablesapce has about 48 datafiles total 1.5 Terabytes
How can I change the initial_extent to 32 M and allocation_type to uniform without dropping and recreate the tablespace with all of the datatypes?
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.