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
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
I would take a look at my controlfile first. Issue a "alter database backup
controlfile to trace;".
Take a look at two things:
1. What is your maxdatafiles set to?
2. Does this new datafile appear in the datafile list?
If it doesn't, I would not delete this datafile, but just rename it so you
: "Miller, Jay" <[EMAIL PROTECTED]>
>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
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_fil
TECTED]>
>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
&g
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 f