Re: Export a 3 gigabyte database

From: Darryl Batten <dbatten_at_lucent.com>
Date: Fri, 12 Feb 1999 11:10:45 -0800
Message-ID: <36C47CB5.5C00E081@lucent.com>

1. use a pipe and the compress command to compress the export file
2. pipe the compressed file to split to create uniform size files

the code below shows how

Create Pipe

   #
   ExpPipe="${ExportDest}/${INSTANCE}_exp.pipe"    if [ -p "${ExpPipe}" ]; then

      if  rm "${ExpPipe}"; then
         :
      else
         TimeStamp
         print "ORAexport: not able to remove ${ExpPipe} \n"
         return ${ORAexportstatus}
      fi

   fi
   if mknod ${ExpPipe} p ; then

      :
   else

      TimeStamp
      print "ORAexport: not able to create ${ExpPipe} \n"
      return ${ORAexportstatus}

   fi

   #
   # export to pipe and compress and split
   #

   ExpLog="${ExportDest}/${DATE}_${INSTANCE}_exp.log"    ExpFile="${ExportDest}/${DATE}_${INSTANCE}_exp.Z" ${EXPORT} USERID=/ FULL=y BUFFER=256000 FILE=${ExpPipe} LOG= {ExpLog} CONSISTENT=Y >/dev/null 2>&1&
#
sleep 10 # Sleep 10 seconds to give export a head start

   #
   # compress the contents of the pipe
   #

This is the part the counts - compress the export and pipe it to split to create 1 gig files
 cat ${ExpPipe} | compress -v | split -b 1025m - ${ExpFile} &    #

Timothy Leung wrote:

> I am trying to export the Oracle 7.3.4 entire database from Sun Solaris OS.
> Since the file system does not allow a file larger than 2 Gigabytes. Is
> there any way to split the export file? Further, I have the same problem on
> NT also.
>
> Thanks in advance!
> Tim
Received on Fri Feb 12 1999 - 13:10:45 CST