Re: Export Problem

            In addition to the compress method you can use the split command to divide the export into multiple smaller files and then use cat to import them. This would be especially useful for very large exports that could be over 2GB compressed.
Here is a KSH example on an HP9000

# Make export pipe may already exist
/sbin/mknod /hd004/export/exp_pipe p
# Begin daily export
cd /hd004/export
rm x*
split -b512m </hd004/export/exp_pipe &
exp $UNPW full=y buffer=1000000 file=/hd004/export/exp_pipe compress=y echo Complete Database export complete `date`

The syntax on a sun may be a little different but this should give you the right idea, in this example I'm exporting to a pipe and then splitting the data from the pipe into 512meg files which will be placed in the directory: /hd004/export with filenames: xaa, xab xac etc...

<amerar_at_ci.chi.il.us> wrote in message news:807caa$hmm$1_at_nnrp1.deja.com...
>
>
> Hello,
>
> I am trying to perform a full export on our production database. We are
> running Oracle 7.3.3 on Solaris 2.5x. The problem is the export keeps
> aborting. I think this has to do with some 2GB file size limit I keep
> hearing about.
>
> Is this true? Can Unix only handle a file of 2GB? How can I correct
> this? Oracle could not really provide a good solution. Going to tape
> is not an option at this time.
>
> Any suggestions?
>
> Arthur
> amerar_at_ci.chi.il.us
>
> PS. Please CC a copy to my email.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 08 1999 - 18:40:38 CST