Re: datafile size restriction

From: "Parallel Huang" >>
I got a problem here,I run Oracle 7.1.3 on DG/UX, I need to create a datafile bigger than 2GB, But I got an error message bellow:

ORA-01119: error in creating database file '/home/RS/test.dbf' ORA-07244: ssfccf: create file failed, file size limit reached. <<

When we were on 7.1.3 our version of Unix could support files up to 4G; however, Oracle ver. 7.1.3 had a bug in it that prevented it from using file systems greater than 2G. You will probably have to upgrade to 7.3+ or 8.0+ to use files larger than 2G.

Question, do you really need a file larger than 2G or do you just need to add another file to one of your tablespaces so a table can grow to be over 2G?

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Thu Sep 03 1998 - 19:32:41 CDT