Re: resize datafile

You do not need to shutdown/dismount database to resize a datafile.

alter database
datafile '&file_name' resize &new_amount;

can re-size the datafile to the &new_amount if there is no data beyond the &new_amount.
If there is any data beyond this point, ORACLE will not allow this re-sizing and it will say so.

Examine dba_extents to determine at which block_ID data may reside in a given file.
Gaps (fragmented) datafiles may prevent resizing the datafile in which case you must drop and rebuild the object (i.e. export and import). So, there is no danger in resizing other than potential frustration in not being able to resize the datafile to the value you wish. Received on Tue Dec 15 1998 - 00:35:14 CST