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!

datafile maxsize....

redologgerNov 22 2011 — edited Nov 23 2011
i am confuse about the datafile maxsize.

I thot when there is a maxsize on the datafile, once it reaches the maxsize, it can no longer go beyond it. Meaning one have to create another datafile on the tablespace.

But to my new realization, the datafile still can be resize. Which cause a confusion now, as in so what is the maxsize for? if datafile still can be resize beyong the maxsize?


So now i can resize it. I am telling oracle to ignore the maxsize that i have set on that datafile?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2011
Added on Nov 22 2011
6 comments
2,902 views