Solved

Filie more than 2 gig.

Posted on 2004-08-04
4
235 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
bigDiff challenge 17 135
Detect file exist or not 3 202
Problem to event 3 113
Authenticate using sesu from script 7 116
Here is how to use MFC's automatic Radio Button handling in your dialog boxes and forms.  Beginner programmers usually start with a OnClick handler for each radio button and that's just not the right way to go.  MFC has a very cool system for handli…
If you use Adobe Reader X it is possible you can't open OLE PDF documents in the standard. The reason is the 'save box mode' in adobe reader X. Many people think the protected Mode of adobe reader x is only to stop the write access. But this fe…
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.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

733 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