Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Dropping a datafile from a tablespace
As an Oracle amateur, I am seeking help with the following problem:
I used Alter Tablespace add datafile to add a file to my user_data tablespace to the tune of about 90 Mb. The usefulness of this datafile has expired, so I reached for the Alter Tablespace drop datafile command... which doesn't exist. After a thorough search of TFM, I don't see a polite way to reclaim the space.
TIA, Sam Kome Received on Mon Feb 03 1997 - 00:00:00 CST