| Tablespace file size maximum stuck at 2G [message #151446] |
Wed, 14 December 2005 22:08  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
We have created a new 7.3.2 database on a new machine and can not create files larger than 2G for the tablespace.
We are getting two messages: ORA-07209: sfofi: file size limit was exceeded and ORA-07244: ssfccf: create file failed, file size limit reached. Googling these error messages leads us to the same result "Run OSH to raise the file size limit."
But how do you run the OSH to "raise the file size limit"? It only appears to have one option '-l' and all that does is TELL us the current maximum file size.
Any answers or URLs will be gratefully received.
David
|
|
|
|
| Re: Tablespace file size maximum stuck at 2G [message #151459 is a reply to message #151446] |
Wed, 14 December 2005 23:14  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
hi,
I found the following information in the old FAQ section of this site but now its renovated and i dont know where to find it.
So i am copying the information that i had from the previous FAQ section.
How does one overcome the Unix 2 Gig file limit?
This example uses the Unix split command to create multiple files, each smaller than the Unix (and imp/exp) 2 Gigabyte file size limit. This method can typically be used for import, export and SQL*Loader operations.
cd /tmp/data
rm exp.dmp
mknod exp.dmp p # mkfifo on certain Unix flavours
split -b2047m </tmp/data/exp.dmp &
exp scott/tiger file=/tmp/data/exp.dmp record=n tables=tableX
cd /tmp/data
rm exp.dmp
mknod exp.dmp p
cat xaa xab xac xad >/tmp/data/exp.dmp &
imp scott/tiger file=/tmp/data/exp.dmp commit=y tables=tableX
Hope it will help you.
Regards,
tarun
|
|
|
|
| Re: Tablespace file size maximum stuck at 2G [message #151498 is a reply to message #151459] |
Thu, 15 December 2005 03:17 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Many filesystems cannot expand more than 2g.
What is your OS?
Check your ULIMIT.
In certain OS (AIX etc) you need to turn on the LARGE FILE option for filesystems more than 2g.
If you cannot workaround the OS filesystem limitation,
Then have your datafiles less than 2g and create multiple datafiles in the same tablespace.
If this database is about to handle HUGE volume of data make sure you are not reaching maxdatafiles/db_files.
[Updated on: Thu, 15 December 2005 03:21] Report message to a moderator |
|
|
|
|
|
| Re: Tablespace file size maximum stuck at 2G [message #151604 is a reply to message #151498] |
Thu, 15 December 2005 18:32 |
|
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Mahesh,
Thank you for the information.
We are running AIX 4.2(.3?) but may have to go to 4.3 to get the larger file sizes.
We have checked the 'ulimit' command and although it says 'unlimited' we can't create files larger than 2G. It is this inability to create file larger than 2G that is causing Oracle (via OSH) to fail.
What is the LARGE FILE option to which you refer?
Yes, multiple files and maxdatafiles/db_files could be an issue.
Upd: I have found a reference to 'smit jfs' which has a 'Large File Enabled' characteristic in it. We will play with it and see what happens.
David
PS If I find the answer to LARGE FILE I will update this post.
[Updated on: Thu, 15 December 2005 19:47] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
