Skip to Main Content

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!

TableSpace Auto Extend on

ZerandibJan 17 2011 — edited Jan 18 2011
Hello,

We are having a tablespace called PSAPSR3. (In Tablespace Auto extend is Enabled & Datafile autoextend mode also ON)
There it having 9 Datafiles.
---- 5 DataFiles are filled. (Reached to Its maximum size)
Totally in this tablespace, now Its 98% Used. (Total Size is 89 GB and It already used 87 GB)

I Want to know... ;
Since the TableSpace is in Auto-extend mode , Will this add DataFile Automatically in the Tablespace?

If not, what is the purpose of marking Tablespace as AutoExtend ON.

Regards,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2011
Added on Jan 17 2011
4 comments
1,615 views