# Resize datafile - don't work anymore

**URL:** <https://forums.toadworld.com/t/resize-datafile-dont-work-anymore/27908>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 5, 2013, 4:48am UTC](https://forums.toadworld.com/t/resize-datafile-dont-work-anymore/27908 "2013-12-05T04:48:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![miran.sagadin](https://avatars.discourse-cdn.com/v4/letter/m/35a633/32.png) [@miran.sagadin](https://forums.toadworld.com/u/miran.sagadin)\
**Post date:** [December 5, 2013, 4:48am UTC](https://forums.toadworld.com/t/resize-datafile-dont-work-anymore/27908/1 "2013-12-05T04:48:36Z")

</div>

Command ALTER DATABASE DATAFILE ‘/OraBase1/oradata/stenar1/PrmZav\_Data10.dbf’  
RESIZE 15500M;

produce error

ORA-01237: cannot extend datafile 119  
ORA-01110: data file 119: ‘/OraBase1/oradata/stenar1/PrmZav\_Data10.dbf’  
ORA-27041: unable to open file  
IBM AIX RISC System/6000 Error: 22: Invalid argument  
Additional information: 4

We have raw devices on aix 5.3 . and oracle 11.2

File OraBase1/oradata/stenar1/PrmZav\_Data10.db is symbolic link

$ ls -ltr PrmZav\_Data10.dbf  
lrwxrwxrwx 1 oracle dba 19 26 nov 10:26 PrmZav\_Data10.dbf -\> /  
dev/rPrmZav\_Data10

PrmZav\_Data10 is logical volume on aix and i have before increasing size of datafile increased size of logical volume. So free space on LV

or raw devise is not problem.

But adding datafile in same tablespace and on the same disk is working. This operation - resizing datafile one ore two months ago was wroking normally. I don’t

know what happened.

Thank you in advance for your answers,

Miran

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [December 5, 2013, 11:05am UTC](https://forums.toadworld.com/t/resize-datafile-dont-work-anymore/27908/2 "2013-12-05T11:05:06Z")

</div>

Does this statement work from pure Oracle SQL\*Plus?