Re: archiving oracle database

Another way to work around the 2GB filesystem limit, while trying to do a FULL export is to use a raw partition. A raw partition does not have a size limit and is faster. Only disadvanage is that you can not "see" the actual file.

If you need more info on this send me an email,

Pratul
DBA
AT&T (GIS) Columbia SC
appy_at_churchill.ColumbiaSC.ATTGIS.COM

>Export may be unsuitable for you, if you specify FULL=Y. This will
>attempt to export the entire database into one file. A better approach
>(and quicker) would be to run several exports in parallel, each exporting
>one or more tables. Not only will this possibly make your exports fit
>into several sub-2GB files, but it will be quicker, since it will be
>performed by several parallel processes.
>
>If this wil work for you, try to export each file to a different physical
>drive, to avoid disk contention.
>
>
>Also, when you say "39 hours to archive", do you mean archiving to tape?
>If so, then I would recommend getting several tape drives to archive in
>parallel. With just three additional tape drives, you might be able to
>reduce your time to about 10 hours!
>
>Best of luck,
>
>-Ari Kaplan
>akaplan_at_interaccess.com
  Received on Wed Aug 23 1995 - 00:00:00 CEST