Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Resize Datafile

Resize Datafile

From: Josef Huber <josef.huber_at_ennstal.at>
Date: Tue, 22 Sep 1998 08:47:49 +0200
Message-ID: <36074976.0@news.profinet.at> 





Hello,



I want to resize a datafile,


ALTER DATABASE DATAFILE 'C:\ORANT\DATABASE\dat01PROF.ORA' RESIZE 200M;



Error Message:


ORA-03297 File has 5312 datablocks over the RESIZE-value



What can i do ?




Ciao,


Joe


Received on Tue Sep 22 1998 - 01:47:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US