Oracle temp tables

Problem: Query using Oracle temp table is hanging.

Even in SQL Editor, tried to run query, which is joining the result with Oracle Temp Table, is taking too long time.

This is not consistent…

Solution: After all the monkey business, recreated the temp tables. It is working fine.

It happen few times. Recreated and problem solved. Still dont know what is happening behind the door.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s