its like the high water mark in a table but its at the
datafile side instead.
if any block in the datafile has ever had data in it, you
can't shrink it below that point.
hth, joe
>>> janetlinsy_at_YAHOO.COM 08/07/01 02:40PM
>>>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 toresize
it. When I issue:alter database
datafile'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize1000M, I
got:ERROR at line 1:ORA-03297: file contains used data beyond
requestedRESIZE valueBut apparently, the file does NOT contain
data beyond1000M. Am I missing something?Thank
you.Janet__________________________________________________Do
You Yahoo!?Make international calls for as low as $.04/minute with Yahoo!
Messenger<A
href="
http://phonecard.yahoo.com/">
http://phonecard.yahoo.com/--
Please see the official ORACLE-L FAQ: <A
href="
http://www.orafaq.com">
http://www.orafaq.com-- Author: Janet
Linsy INET: janetlinsy_at_yahoo.comFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list
you want to be removed from). You mayalso send the HELP command for
other information (like subscribing).
Received on Tue Aug 07 2001 - 13:03:58 CDT
