Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot resize the datafile

RKDec 6 2010 — edited Dec 6 2010

Hi All,

Previously i have enable the autoextened on for datafile but now i disable the autoextend but after autoextened off i cannot resize the datafile.

Please find the below example.

Total Free Free
Tablespace Data File Space [MB] Space [MB] %
--------------- --------------------------------------------------------------------------- ----------- ----------- --------------------------------------------------------------------------------
TRUSTWARE01 E:\ORACLE\PRODUCT\10.2.0\ORADATA\WPABETA\TRUSTWARE01 14556.75 9275.13 63.72
D:\ORACLE\ORADATA\WPABETA\TRUSTWARE02.DBF 17764.88 12684.81 71.40
D:\ORACLE\ORADATA\WPABETA\TRUSTWARE05.DBF 3225.56 397.13 12.31
*************** ----------- -----------
SQL>

SQL> alter database datafile 'D:\ORACLE\ORADATA\WPABETA\TRUSTWARE02.DBF' resize 10240M;
alter database datafile 'D:\ORACLE\ORADATA\WPABETA\TRUSTWARE02.DBF' resize 10240M
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2011

Added on Dec 6 2010

#database, #general-database-discussions

9 comments

1,280 views