| Datafile-Question [message #62543] |
Wed, 28 July 2004 04:42  |
Alex
Messages: 190
Registered: August 1999
|
Senior Member |
|
|
Hi,
I have a question about a datafile in one of mine db's.
Situation:
Today I looked on a 7.3.-db on a windows-system to study the struktur for the case of a migration on a 9.2.-db per export/import. Via dba-studio and svrmgrl I dicovered a second datafile, which belongs to the system-tablespace. The mysrerious thing is: this datafile has no ending (like .oa or .dbf) and there is path! But from its 50 m are 0,98 used!
Question:
Where is this file? What is it? And how it was made? I wasn't able to make such a file in my test enviroment!
To show, this is the result of
select name of v$datafile;
F:ORANTDATABASEdbnameSYSTEMdbname.ORA
F:ORANTDATABASEdbnameTBSdbname.ORA
F:ORANTDATABASEdbnameTBSdbnameRBTBS1.ORA
SYS3
F:ORANTDATABASEdbnameSYSTEMLL_DATA.ORA
F:ORANTDATABASEdbnameSYSTEMLL_IND.ORA
F:ORANTDATABASEdbnameSYSTEMLL_TEMP.ORA
SYS3 ????
|
|
|
|
| Re: Datafile-Question [message #62553 is a reply to message #62543] |
Wed, 28 July 2004 10:32  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Hi,
This is a normal datafile with a strange name. Do a
find for it on your system - it's probably in
ORACLE_HOME/dbs/ or ORACLE_HOME/database/.
Best is to rename it before somebody deletes it!
Best regards.
Frank
|
|
|
|
| Re: Datafile-Question [message #62557 is a reply to message #62553] |
Wed, 28 July 2004 21:28 |
Alex
Messages: 190
Registered: August 1999
|
Senior Member |
|
|
Thanks,
I found it...on a other hard drive like the other stuff.
I still wonder how oracle regognize this file without path, but I am glad that this ghost-file exists!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
