flaskvacuum 0 Newbie Poster

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.