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!

Which query/statement caused ORA-1652

819156Sep 22 2011 — edited Sep 23 2011

Hi,
Today when I checked the alert log file, i saw ORA-1652 unable to extend temp segment by 128 in tablespace TEMP. The error was recorded sometime in the morning at around 10am. Is it possible for me to identify the SQL statement now which caused this issue?

db version: 10.2.0.4
RHEL 4

Thanks
Neel

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2011

Added on Sep 22 2011

#general-database-discussions

6 comments

1,800 views