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 Autoextend Failure

534640May 27 2009 — edited May 28 2009

Dear All,
We are using Oracle 10g 10.2.0.1 on HP.
I have created a temporary tablespace and have added 6 datafiles with initial size of 1G and have set the autoextend clause on with 100M increment and maxsize 10G.

Current size of tablespace is 6G. I am getting following error again and again on Enterprise Manager Console.
Tablespace [TEMP02] only has [0 megabytes ] free space

I have checked the mount points and we have enough space on all the mount points where our datafiles reside.
Can Anyone help me resolving this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2009

Added on May 27 2009

#general-database-discussions

11 comments

4,291 views