i wanted to create a locally managed tablespace with uniform allocation of extents. And also want my tablespace to consist only let say 5 extents. It will use only one data file.
here is what i know:
CREATE TABLESPACE TABLE1
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 64K
DATAFILE 'C:\ORACLE\ORADATA\MYDB\TABLE1.DBF'
SIZE 5M
AUTOEXTEND AUTO;
I tried maxextents but error. I seriously have no idea whether is it possible to have a fix number of extents?