Re: datafile size restriction

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: Thu, 3 Sep 1998 14:38:08 +0200
Message-ID: <6sm1k4$3tl$1@news.worldonline.nl>

hello Huang (parallel)

A datafile bigger than 2GB is impossible on many Unix platforms. Try creating 2 datafiles of 2Gb for the same tablespace

älter tablespace <BLAH> add datafile
  'xxx'

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl
check out : http://home.worldonline.nl/~bytelife

>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.
>
>And I was asked to run osh to raise the file size limit.
>But in my platform I can't find "osh", where can I find this file
>OR can I solve this problem using another way??
>Thanks a lot.
>Alvin, 9/3
Received on Thu Sep 03 1998 - 07:38:08 CDT