Hi Jose,

Your data is spread over the datafile, so you have to do a export of all data which resides on this datafile (tablespace) then drop those objects, resize your datafile (tablespace) and import objects.

HTH

regards

Volker Schoen
E-Mail: mailto:v.[Email address protected]
http://www.inplan.de




-----Ursprüngliche Nachricht-----
Von: Jose Rodrigo da Silva [mailto:oracledba-ezmlmshield-x44703089.[Email address protected]
Gesendet: Donnerstag, 30. Dezember 2004 16:02
An: LazyDBA Discussion
Betreff: Resize Datafile

Hi,

When try

ALTER DATABASE
DATAFILE '/prd/oracle/oradata/sir/SIARREC.dbf' RESIZE 20M

Get ORA - 03297 file contains used data beyond requested RESIZE value, erro messenge

Please someone have an solution for this....

Thank´s

José Rodrigo
DBA
61 4117235



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page