Re: How to drop a datafile

Thank you Andrew,

My Oracle version is 8.1.7.

It is bad to have to keep it on the disk, isn't it?

Andrew Allen wrote:

> zifeng li wrote:
> >
> > Hi
> >
> > Please advise how to drop a datafile, after it was
> > accidentally created into a wrong tablespace.
>
> You did not tell us which version of Oracle you are running so I
> assume you are using a version for which the FM does not porvide
> instructions on how to do this. . .
> You cannot drop a datafile once it is attached to a tablespace. All
> you can do is resize it as small as possible, say 128k, and forget
> about it.
>
> --
> Andrew Allen
> Livonia, MI
> E- Mailto:ajalle_at_ameritech.net
Received on Wed Oct 10 2001 - 17:42:38 CDT