• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

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.
0
sBahman
Asked:
sBahman
  • 2
1 Solution
 
MikeOM_DBACommented:
What type of Oracle file?:

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

0
 
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.
0
 
MikeOM_DBACommented:
Does your server file system support files > 2G?

If yes, then post the commands (or script) you are using to read backup file.
0
 
TalmashCommented:
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 .

tal
0
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now