Re: Exporting large (>8 gig) database in UNIX?

Jim Mahoney wrote:
>
> squinn_at_netcomuk.co.uk (Simon Quinn) wrote:
>
> >What is the best way to do a full export on an ORACLE database on
> >UNIX?
> >
> >The current file size limit on the version we are using is 2Gigabytes
> >and I estimate the database will be 8 Gig in size.
> >
> >What is the best way to split it into separate sections or is there an
> >option in EXP to split the export file? I am using v7.2.3.
> >
> >Thanks
> >Simon.
>
> I don't think there are any options to break up an export into 2gig
> files. The only thing I can think of would be to export by table, user
> or schema. This assumes there are no 2gig + objects.
>
> Jim

Exporting with compress yields a file about 70% of the origional:

  mknod /tmp/exp_pipe p
  nohup compress < /tmp/exp_pipe > /tmp/exp_full.dmp.Z &   nohup exp / full=y file=/tmp/exp_pipe > /tmp/exp_log 2>&1 &

  mknod /tmp/imp_pipe p
  nohup uncompress < /tmp/exp_full.dmp.Z > /tmp/imp_pipe &   nohup imp / full=y file=/tmp/imp_pipe > /tmp/imp_log 2>&1 &

Or if that is still to big try using tape. The "5000M' value is for a 5 meg tape. I have not had to do an export greater than that size but I am told that if you run interactive and the tape fills up, the export/inport will request a second/third/... tape:

  nohup exp / full=y file=/dev/rmt0 volsize=5000M > /tmp/exp_log 2>&1 &

  nohup imp / full=y file=/dev/rmt0 volsize=5000M > /tmp/imp_log 2>&1 &

-- 
                       \\|//
                       (0-0)
           +-----oOO----(_)-----------+
           | Brian P. Mac Lean        |
           | Database Analyst         |
           | brian.maclean_at_teldta.com |
           | http://www.teldta.com    |
           +-------------------oOO----+
                      |__|__|
                       || ||
                      ooO Ooo