Home » RDBMS Server » Server Administration » tempfile
tempfile [message #403567] Sun, 17 May 2009 01:56 Go to next message
tjay
Messages: 37
Registered: September 2008
Member
Hi
Oracle 9.2.0.6.0

I cannot see any tempfile from the below query:


SQL> select * from v$tempfile;

no rows selected


However I can see the datafiles from the below query:

select * from dba_data_files where tablespace_name='TEMP';
....
....

Why?
Re: tempfile [message #403571 is a reply to message #403567] Sun, 17 May 2009 02:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be there is a permanent tablespace inappropriately named as TEMP.
Tempfiles should be listed in dba_temp_files.
Re: tempfile [message #403577 is a reply to message #403567] Sun, 17 May 2009 03:40 Go to previous messageGo to next message
tjay
Messages: 37
Registered: September 2008
Member
select * from dba_temp_files

no rows returned
Re: tempfile [message #403581 is a reply to message #403577] Sun, 17 May 2009 03:54 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You missed the main point of Mahesh Rajendran's post:
Quote:
May be there is a permanent tablespace inappropriately named as TEMP.


In addition, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: How to move tablespace from logical volume to another
Next Topic: The Network Adapter could not establish the connection
Goto Forum:
  


Current Time: Tue Dec 06 04:42:04 CST 2016

Total time taken to generate the page: 0.07778 seconds