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 until this morning since this database is shut down
every night.
I ran the command this morning and discovered that the file was in in
PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: File created by failed Add Datafile command
Date: Thu, 24 May 2001 06:15:25 -0800
Yesterday I went to add a new datafile and the command failed because I
already had datafiles = db_files value. No problem, I increased
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
]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: File created by failed Add Datafile command
Date: Thu, 24 May 2001 06:15:25 -0800
Yesterday I went to add a new datafile and the command failed because I
already had datafiles = db_files value
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