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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Find the query due to TEMP tablespace issue

user9256814Nov 22 2012 — edited Nov 23 2012

Hi Team,

Is there any way to find the out the query which is failed to due to temporary tablespace. I belive once operation failed due to temp tablespace(ORA-1652: unable to extend temp segment) we cannot find the query which caused this. is there any other possibility to find which query caused this.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2012

Added on Nov 22 2012

#general-database-discussions

7 comments

14,777 views