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!

Delete TEMP

Beauty_and_dBestNov 14 2015 — edited Nov 15 2015

Hi ALL,

db 9.2.0.6

I select our v$tempfiles, and I got the following:

I can see that I have four online tempfiles.

But I have two TEMP tablespaces that use the two tempfiles only.

Why are the other two tempfiles not attached to a TEMP tablespace?

How do I know where are they being attached to?

Can I drop the other two tempfiles not associated with a TEMP tablespace?

Why is its status ONLINE when it is not being used or attached to a tablespace?

Please help...

Thanks a lot,

This post has been answered by Pavan Kumar on Nov 14 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2015

Added on Nov 14 2015

#general-database-discussions

20 comments

3,876 views