Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to be freed EXTENTED space?
You don't have space to create a copy table in your database files,
but maybe you you have some free space on a separate disk drive.
If so, do as follow :
Export your table data into an export file on your extra disk drive;
Truncate your table;
Import your data.
There is NO WAY to directly remove unused space in a table Received on Wed Jun 24 1998 - 15:44:42 CDT