| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: free up datafile space problem ???
Janet,
You can only reduce the datafile by the amount of contiguous free space at the end of the datafile. Back up your DB before you try any of this. I never play with tablespace and datafiles without a current backup. Use alter tablespace coalesce, then query dba_free_space, dba_data_files and dba_segments to see how much reduction you can get. If you've got a bunch of free space sandwiched in between used space, you're going to have to do an export/import to reorg the tablespace and significantly reduce the datafile size(s).
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Janet Linsy
<janetlinsy_at_ya To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
hoo.com> cc:
Sent by: Subject: free up datafile space problem
???
root_at_fatcity.c
om
08/07/2001
01:40 PM
Please respond
to ORACLE-L
Hi all,
I have a data file of 2G and the free bytes is
1,413,079, the used bytes is only 683,829. I like to
resize it. When I issue:
alter database datafile
'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize
1000M, I got:
ERROR at line 1:
ORA-03297: file contains used data beyond requested
RESIZE value
But apparently, the file does NOT contain data beyond 1000M. Am I missing something?
Thank you.
Janet
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: janetlinsy_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Aug 07 2001 - 14:42:50 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: DBarbour_at_austin.isd.tenet.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |