Not able to resize datafiles
756020Jul 22 2010 — edited Jul 23 2010Hi All,
I need your help in understanding this issue.
When I try to resize a datafile on a production database on Oracle 10g 10.2.0.3 version, I am not able to.
The tablespace is of 69GB size and i am trying to resize a datafile which is of 32GB size and I am recieving the following error:
________________________________________________
alter datafile datafile 'D:\ORACLE\ORADATA\test.dbf' resize 32800m;
*
ERROR at line 1:
ORA-01144: File size (4198400 blocks) exceed maximum of 4194303 blocks
_______________________________________________
The tablespace is in autoextensible mode but then the user is complaining that when she tries to load the data, though the tablespace is in autoextensible mode she has to set the file to unlimited for loading the data.
Could you kindly help me here.
Thanks,
dan