Re: Datafile question (continued)

From: <rspeaker_at_my-dejanews.com>
Date: Wed, 03 Mar 1999 15:11:28 GMT
Message-ID: <7bjjem$58a$1@nnrp1.dejanews.com>

Check either v$datafiles or sys.dba_data_files to see if it is listed. If not, shut down the database, rename the file at the OS level (don't delete it yet), and try to start the database back up. If it starts up okay, then you should be safe to delete the file. If Oracle screams about a missing file, shut down again and rename it back.

HTH,
Roy

In article <36DD70F5.B6A188C7_at_basford.demon.co.uk>, ed <ed_at_basford.demon.co.uk> wrote:
> I recreated the control file after MAXDATAFILES had been reached. No
> problem. However, I still have this sixth datafile, which Oracle doesn't
> know about. i.e. it wasn't in the trace file which gets run as an sql.
> How can I know it's ok to delete it as I need to add some more
> datafiles.
>
> Thanks.
>
> Ed.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 03 1999 - 09:11:28 CST