couple of things to check before you do anything with this file:
first, select from dba_data_files to see if Oracle thinks the file is in the
database.
second, at the OS level (this is Unix, yes?) go to that directory and do an
fuser on that file. If no processes show up, the file is not
Too be safe, rename it to datafile.old. Add your datafile. Later, after you tested
shutdown/startup, etc. of your db, then delete your old datafile.
[EMAIL PROTECTED] 05/24/01 10:15AM
Yesterday I went to add a new datafile and the command failed because I
already had datafiles = db_files
Hi Rachel,
As mentioned, I had checked DBA_DATA_FILES and it wasn't there. Hadn't
thought to use fuser, that also showed no one accessing it so I just issued
the command with REUSE and it worked fine.
Thanks!
Jay
-Original Message-
Sent: Thursday, May 24, 2001 10:51 AM
To: Multiple
Yes, either will work. I would personally prefer the reuse option, but that is
just
my preferance.
Terry
Miller, Jay wrote:
Yesterday I went to add a new datafile and the command failed because I
already had datafiles = db_files value. No problem, I increased the
parameter and waited
Whatever Jim has said is exactly right procedure... as I have experianced this
type of problem before and cured it in the same way Jim said..
Rupali
Hawkins Family wrote:
I would take a look at my controlfile first. Issue a alter database backup
controlfile to trace;.
Take a look at two