Solved

Filie more than 2 gig.

Posted on 2004-08-04
4
233 Views
Last Modified: 2013-12-26
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
Comment
Question by:sBahman
  • 2
4 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 11714893
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
 

Author Comment

by:sBahman
ID: 11714954
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
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 40 total points
ID: 11715804
Does your server file system support files > 2G?

If yes, then post the commands (or script) you are using to read backup file.
0
 
LVL 6

Expert Comment

by:Talmash
ID: 11715904
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

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article, I'll describe -- and show pictures of -- some of the significant additions that have been made available to programmers in the MFC Feature Pack for Visual C++ 2008.  These same feature are in the MFC libraries that come with Visual …
Introduction: Database storage, where is the exe actually on the disc? Playing a game selected randomly (how to generate random numbers).  Error trapping with try..catch to help the code run even if something goes wrong. Continuing from the seve…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question