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!

what are SYS.ORA_TEMP_1_DS_% tables?

Insaponata-OracleFeb 7 2012 — edited Feb 7 2012

Hi,
in my 11.2.0.2 database sometimes I see that there are some mysterious temporary tables with the same name like 'SYS.ORA_TEMP_1_DS_%'.

I'm not running any dbms_stats function. The mentioned temporary tables appears and disappears intermittently so I don't have a proliferation problem... I'm just wondering who and why is creating these tables? They seems to be a kind of system-wide temporary tables... what "DS" is standing for? Could it be "Data Set" ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2012

Added on Feb 7 2012

#general-database-discussions

4 comments

4,965 views