Re: Datafile question (continued)

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Wed, 03 Mar 1999 15:02:36 GMT
Message-ID: <gacD2.32349$rs2.9686284@client.news.psi.net>

Hi Ed,

Assuming you have dba privileges:

Select substr(file_name,1,60) from dba_data_files;

If the file you want to delete doesn't appear in the output it is safe to delete it (at least as far as Oracle is concerned).

regards

Jerry Gitomer

ed wrote in message <36DD70F5.B6A188C7_at_basford.demon.co.uk>...
>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.
>
Received on Wed Mar 03 1999 - 09:02:36 CST