Home » RDBMS Server » Server Utilities » Resize of datafile (Oracle 9i Windows 2003)
Resize of datafile [message #346954] Wed, 10 September 2008 03:45 Go to next message
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member

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


Tarun Mittal

Re: Resize of datafile [message #346965 is a reply to message #346954] Wed, 10 September 2008 04:29 Go to previous message
Michel Cadot
Messages: 65150
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you can use the Search button in the menu bar?
http://www.orafaq.com/forum/?SQ=8aa47d0a8c3a38f71c5426ae1a614c83&t=search&srch=file+contains+used+data+beyond+requested+RESIZ E+value&btn_submit=Search&field=all&forum_limiter=&search_logic=AND&sort_order=DESC&author=

Previous Topic: SQL Loader Problem after Migration from to
Next Topic: oracle database to another oracle test server
Goto Forum:

Current Time: Mon Aug 21 14:52:51 CDT 2017

Total time taken to generate the page: 0.14526 seconds