Skip to Main Content
Forums

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!

Why 'alter database tempfile ... maxsize unlimited' doesn't work?

MorvenJun 19 2011 — edited Jun 19 2011
Hi,

Oracle 11gr2 enterprise, windows server 2008 64bit.
--
after executed 'alter database tempfile 'D:\ORACLE\ORADATA\MH\TEMP01.DBF' autoextend on maxsize unlimited;' , i found that the maxsize is still 32G, why? is it a limitation of operation system?

how can i make the tempfile bigger than that? to add another tempfile? how to write this 'alter' command to add another file?

thank you so much!
This post has been answered by CKPT on Jun 19 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2011
Added on Jun 19 2011
#general-database-discussions
10 comments
16,995 views