SQL & PL/SQL

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!

How big temp is necessary to collect statistics for 3GB data?

672680Nov 20 2009 — edited Apr 24 2013

I have a huge table like 13,000,000 records in it!
And when I try to collect statistics for this table, I got:

SQL> analyze table imsdba.ims_alctn compute statistics;
analyze table imsdba.ims_alctn compute statistics
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-27059: skgfrsz: could not reduce file size
OSD-04005: SetFilePointer() failure, unable to read from file
O/S-Error: (OS 112) There is not enough space on the disk.

My temp tablespace is like 600MB big. so I wonder how much space is essential to collect statistics for a huge table?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 22 2013

Added on Nov 20 2009

5 comments

524 views