Toad World® Forums

Resize datafile - don't work anymore

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

Does this statement work from pure Oracle SQL*Plus?