This is correct.
But Jose, I am wondering if you are really meaning to shrink the datafile or expand it. I ask this because every now and then I accidently put in the wrong number (thinking I am trying to expand the datafile) and, once I get the error that you got, I realize that I accidently tried to shrink the datafile by leaving off a zero on my resize value.
Just thought I would throw that in ... it's happened to me often enough that I thought perhaps this is what has happened to you.
Randy Netz
Oracle DBA
816-860-3921 (work)
816-686-1639 (cell)
-----Original Message-----
From: v [mailto:oracledba-ezmlmshield-x21789076.[Email address protected]
Sent: Thursday, December 30, 2004 8:05 AM
To: LazyDBA Discussion
Subject: AW: Resize Datafile
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
--------
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