Re: tablespace creation parameters

Posted by ErmanArslansOracleBlog on Oct 05, 2018; 8:45am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tablespace-creation-parameters-tp6815p6817.html

What is your db version? & Do you use locally managed or dictionary managed tablespaces?

Are you aware of this fact? -> MAXEXTENTS - This storage parameter is valid only for objects in dictionary-managed tablespaces.
MAXEXTENTS is ignored for objects residing in a locally managed tablespace, unless the value of ALLOCATION_TYPE is USER for the tablespace in the DBA_TABLESPACES data dictionary view.