OS version:AIX 5.3
DB Version: 11g Rel1
I was trying to add a datafile to a tablespace. But i cannot add a file which is more than 2 gb. I am able to add as many as 2gb files. As you can see below, i've given UNLIMITED resources. But i still get 'File too large' error
$ ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimited
SQL> ALTER TABLESPACE qlmtbs_1
2 ADD DATAFILE '/u02/oradata/qlmtbs_105.dbf' SIZE 4000M;
ALTER TABLESPACE qlmtbs_1
*
ERROR at line 1:
ORA-01119: error in creating database file '/u02/oradata/qlmtbs_105.dbf'
ORA-27044: unable to write the header block of file
IBM AIX RISC System/6000 Error: 27: File too large
Additional information: 4
Message was edited by:
GarryB