Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Tablespace MaxMb

OraFighterOct 20 2011 — edited Oct 26 2011

What is the meaning of Tablespace Maxmb column ?
Is it the maximum allowed size of Tablespace or Maximum allowed size of a Datafile?
How to set maximum allowed size of Tablespace ?
How to set Maximum allowed size of Datafile ?

I execute the command as follows?
create tablespace ts1 datafile 'e:\ts1.dbf' size 500m autoextend on maxsize 1000m;
I checked in Toad , it shows
Maxmb of tablespace TS1 is 1000
Max Extents of Datafile is 2147483645 -> it is a default value , even I mention UNLIMITED same value 2147483645 is coming.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 23 2011

Added on Oct 20 2011

#general-database-discussions

7 comments

1,013 views