How can I change the initial_extent of a tablespace
Hi
I have created a tablespace as follows:
create tablespace MD_DATA
datafile'/opt/app/oradata01/HMPROD/md_data_01.dbf' size 30000m
blocksize 32k
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?
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
Reply With Quote