Solved

Filie more than 2 gig.

Posted on 2004-08-04
4
231 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This is to be the first in a series of articles demonstrating the development of a complete windows based application using the MFC classes.  I’ll try to keep each article focused on one (or a couple) of the tasks that one may meet.   Introductio…
Introduction: Dialogs (1) modal - maintaining the database. Continuing from the ninth article about sudoku.   You might have heard of modal and modeless dialogs.  Here with this Sudoku application will we use one of each type: a modal dialog …
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.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

707 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now