Hi All,

I want to reduce my datafiles.When I try to do so I get this error "ORA-03297: file contains 50 blocks of data beyond requested RESIZE value".

Is there any way of resizing the datafiles whithout doing an export and import as an export and import will result in downtime?
I want to know of any method to reduce my datafiles with out any downtime?

TIA

Mike


---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Oracle LazyDBA home page