Re: ora-01113 and ora-01110

Ana,

Thanks for the clarification. Linda Wang answered this:

>SVRMGR> alter database recover automatic datafile
>'/oracle/data/DEEP/data_sub_1b.dbf';
>Statement processed.
>
>SVRMGR> alter database datafile
>'/oracle/data/DEEP/data_sub_1b.dbf'
>online; Statement processed.

ep

On 10 Jul 2000, at 16:46, achoto_at_american.edu> wrote:

From:           	achoto_at_american.edu
Subject:        	Re: ora-01113 and ora-01110
To:             	PierceED_at_csus.edu
Date sent:      	Mon, 10 Jul 2000 16:46:08 -0400

>
> Sorry, I should've said I dropped it. At the Unix level the file is there.
> And in the database it appears offline.
>
> We're on Solaris 2.6 and Oracle 8.05.
>
> Thanks
>
> Ana
>
>
>
>
> "Eric D.
> Pierce" To: achoto_at_american.edu, ORACLE-L_at_fatcity.com
> <PierceED_at_csu cc:
> s.edu> Subject: Re: ora-01113 and ora-01110
>
> 07/10/00
> 04:49 PM
> Please
> respond to
> PierceED
>
>
>
>
>
>
> How can something that was deleted still be there?
> ep
>
> Date sent: Mon, 10 Jul 2000 13:20:55 -0800
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> From: achoto_at_american.edu
> Subject: ora-01113 and ora-01110
>
> > I need some help. I deleted a datafile by mistake. I need to recover
> it.
> > The datafile is still there and offline.
Received on Mon Jul 10 2000 - 17:15:16 CDT