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!

temp tablespace

don123Sep 13 2017 — edited Sep 13 2017

There is a procedure running and got ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1

I tried to extend temporary tablespace autoextend on, i got following error.

ORA-32773: operation not supported for smallfile tablespace TEMP1.

How to resolve this?

This post has been answered by Mustafa KALAYCI on Sep 13 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2017

Added on Sep 13 2017

#general-database-discussions

4 comments

840 views