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!

seeing temp datafiles

694352Apr 8 2009 — edited Apr 9 2009

Hi
I want to see my datafiles in my temp tablespace, but cant see with the following query..
What might be the reason?
Oracle 9i

SELECT tablespace_name, file_name, bytes
FROM dba_temp_files WHERE tablespace_name = 'TEMP';

no rows returned

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2009

Added on Apr 8 2009

#general-database-discussions

19 comments

6,441 views