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!

ORA-1652: unable to extend temp

543075Sep 2 2008 — edited Sep 3 2008

I am getting following when we run report in oracle ods because of it report doesn't execute.

ORA-1652: unable to extend temp segment by 128 in tablespace

Current DB used size:10GB
Curren Temp size:50 GB(Total Group temparary space)
WORKAREA_SIZE_POLICY=AUTO
sga_max_size 9G
sga_target 9G
pga_aggregate_target 4905M

Can anybody help on this issue?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2008

Added on Sep 2 2008

#general-database-discussions

6 comments

1,448 views