Why does v$datafile not show temp01.dbf ? [message #527754] |
Thu, 20 October 2011 01:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/754ffdec6c924a1a5ade13e42cd4ea5c?s=64&d=mm&r=g) |
swaorclser
Messages: 56 Registered: August 2011
|
Member |
|
|
Hello All,
When I run following query,
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
C:\APP\ADMINISTRATOR\ORADATA\THIRDB\SYSTEM01.DBF
C:\APP\ADMINISTRATOR\ORADATA\THIRDB\SYSAUX01.DBF
C:\APP\ADMINISTRATOR\ORADATA\THIRDB\UNDOTBS01.DBF
C:\APP\ADMINISTRATOR\ORADATA\THIRDB\USERS01.DBF
TEMP01.DBF is present in C:\APP\ADMINISTRATOR\ORADATA\THIRDB, still why it is not showing?
Thanks & Regards,
swaorclser
|
|
|
|
|
Re: Why does v$datafile not show temp01.dbf ? [message #527770 is a reply to message #527768] |
Thu, 20 October 2011 02:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:v$datafile shows datafiles and TEMP01.DBF is also a DATAFILE
No, in Oracle terminology, it is NOT a data file, it is a TEMP file. Whatever you think, it is Oracle that defines the name of its objects.
Quote:It has extension as DBF
Oracle does NOT care about extension. You can name all of them ".swaorclser" if you want.
Quote:Also I came across following,
It is not because something is called "*temp*" it is a temporary file.
Once again you can name your files as you want.
By the way, there is NO checkpoint on temporary files, this is irrelevant and meaningless.
Your link returns me:
Quote:We're sorry, the page you requested was not found.
Regards
Michel
|
|
|