| tempfile [message #403567] |
Sun, 17 May 2009 01:56  |
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 #403581 is a reply to message #403577] |
Sun, 17 May 2009 03:54  |
 |
Michel Cadot
Messages: 68665
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
