Re: Export bigger than 2 GB

From: Andrew Williamson <andrewweb_at_my-deja.com>
Date: Tue, 11 Apr 2000 12:23:31 +0100
Message-ID: <955452259.1118.0.nnrp-13.c30bdde2_at_news.demon.co.uk>

You could try compressing it as it exports?

/usr/sbin/mknod /tmp/export_pipe p
compress < /tmp/export_pipe > /tokeep.dmp.Z & or
gzip -c < /tmp/export_pipe > /tmp/tokeep.dmp.gz &

and then export to file '/tmp/export_pipe'. Using mknod allows you to use pipes where you otherwise couldn't. Once the export finishes, the compression process finishes automatically. You can use the same process to import from it if need be.

Andrew

MLJ <dinyar_ghyara_at_nospam.exchange.japan.ml.com> wrote in message news:38F266C4.9F8F8866_at_nospam.exchange.japan.ml.com...
> Hi,
> We've got solaris 2.6 running oracle 8i.
> I am trying to do an export of a schema and the export is bigger than
> 2GB and the export fails. Is there a way we can break up the export?
> Thanks
> Dinyar
>
Received on Tue Apr 11 2000 - 13:23:31 CEST

This message: [ Message body ]
Next message: Frank van Bortel: "Re: Changing values in Pop-list (In Designer 2000)"
Previous message: Andrew Williamson: "Re: how to refer unix env. variable into pl/sql block ?"
In reply to MLJ: "Export bigger than 2 GB"
Next in thread: Wayne Bastow: "Re: Export bigger than 2 GB"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message