Filie more than 2 gig.

How can i solv a problem for file more than 2 gig for oracle on AIX 5.L.
the limits file on etc is -1 and oracle have a file 2,1 gig.
When i try to make a file more than 2 gig, on oracle account get the error.
Who is Participating?
MikeOM_DBAConnect With a Mentor Commented:
Does your server file system support files > 2G?

If yes, then post the commands (or script) you are using to read backup file.
What type of Oracle file?:

database? then create tablespaces with as many 2G files as needed.
export backup? a) compress or/and b) split

sBahmanAuthor Commented:
Datafile from oracle is more than 2 gig. I havn't problem with that, but i reading the file from backup and i get error. I can't compress backup file or split.
anyhow u can split it by unix command :

split -100000 big_file

this will split u big file to smaller files each 100000 lines
and each will has same name with different extention .

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.