OraFAQ Forum: Server Utilities » Resize of datafile

Home » RDBMS Server » Server Utilities » Resize of datafile (Oracle 9i Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Resize of datafile [message #346954]

Wed, 10 September 2008 03:45

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Hi,

I have created one tablespace name “abxed” with data file abxed.dbf and size is 2000m then I import the data successfully. ---- there is no issue ok

Now I check the datafile usage & I found only 800m is used and 1200m is free ----- ok

now I want to resize the datafile from 2000m to 1000m but i m getting the error

---------------------------------------------------------------
ORA-03297: file contains used data beyond requested RESIZE value
---------------------------------------------------------------

pls suggest & how can I resize the same

Regards

Tarun Mittal

Report message to a moderator