sBahman
asked on
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.
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.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
database? then create tablespaces with as many 2G files as needed.
export backup? a) compress or/and b) split