Maximum Datafile Size Question

ORACLE: 7.1.3 I am trying to create a 12GB tablespace. I have created a 12289MB (12GB + 1MB) logical raw disk device named /dev/rdsk/jrnl.dbf that consists of striped pieces from 16 disks. I wanted to use the ~12GB raw device as my sole datafile for the tablespace. However, when I tried to create the 12GB tablespace using this device as the datafile, I got the following error immediately after issuing the create tablespace command:

        ORA-07244: ssfccf: create file failed, file size limit reached.

Does Oracle have a 2GB datafile limit even when the datafile is on a raw disk device? If so, is there a way I can put multiple datafiles on the same raw disk device? I would like to limit the number devices I must create for datafiles to as few as possible because of operating system specific limits. The command I issued to create the tablespace was:

        create tablespace jrnl datafile '/dev/rdsk/jrnl.dbf' size 12288M;

Any help is appreciated.

Jamie Sutton Received on Mon Feb 27 1995 - 06:55:04 CET