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!

extend max size of temp tablespace

user8869798Jul 4 2011 — edited Jul 4 2011

Hi,
I can't seem to find the correct syntax for extending the max size for a temp tablespace.

Would this be correct?
alter database
TEMPFILE 'xyz'
autoextend ON
next 10M
maxsize 1500M

thank you.

This post has been answered by 585179 on Jul 4 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2011

Added on Jul 4 2011

#general-database-discussions

12 comments

36,226 views