Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to drop a datafile?
Hi:
I have added a datafile to abc non-system tablespace, and decided that I should drop the datafile. I am in startup restrict mode, so I know for sure that the newly added datafile is "clean".
Can I:
ALTER DATABASE my_db
DATAFILE 'abc' OFFLINE DROP?
TIA
Cheong
Received on Wed Apr 21 1999 - 21:41:36 CDT