Re: Q: Exporting large databases,tables (> 2gig)
Date: 1996/11/20
Message-ID: <w1MopCADu1kyEwFe_at_ahardy.demon.co.uk>#1/1
In article <328DD4E5.3D15_at_kna.com>, "Krishna K. Kurup"
<krishnak_at_kna.com> writes
[snip]
Krishna,
>Question 1: Does anyone knows about such a patch ? The export was being
>run on an hp-T500, but it could be run on the sequent box also. (i.e. if
>the patch exists for either OS; Note that the patch is not an OS patch,
>but an Oracle patch)
I *believe* that the 2Gb limit is OS related, most Unix OS are limited to 2Gb files, so a patch for Oracle isn't going to help it break the OS limits.
The usual tricks are to export through pipes and compress to a file which will hopefully be less than 2Gb, or to export individual groups of tables.
>Question 2: Has anyone created oracle datafiles of greater than 2 gig.
>Are there any problems related to the same ? (unrelated to the problem
>definition above)
Once again, individiual datafiles *should* be limited by the OS. A tablespace may consist of a number of datafiles, so this isn't much of a limitation.
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603) PGP key available on request
Look at it this way: MSDOS is an overgrown program loader; the MacOS is an overgrown user interface. Neither is an operating system, but the second is better for running applications. -- Paul Placeway Received on Wed Nov 20 1996 - 00:00:00 CET