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 - 01:29:20 CDT
