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
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

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: 64152
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=

Regards
Michel
Previous Topic: SQL Loader Problem after Migration from 9.2.0.7 to 10.2.0.3
Next Topic: database exp/imp...!!
Goto Forum:
  


Current Time: Sat Dec 10 01:21:53 CST 2016

Total time taken to generate the page: 0.09911 seconds