Is any single table more than 2G ? If not, just break
up the export into individual schemas and/or tables.
For those tables that are more than 2G, you could
compress via a pipe - for NT might mean running export
over sqlnet from a unix box.
hth
connor
- Luc.Demanche_at_astrazeneca.com wrote: > Hi DBAs,
>
> Because of some requirements from one of our vendor,
> we still have a
> database running Oracle7.3.4 on WindowsNT and since
> this package is no
> longer used, so we
> want to export the content of this database.
> The database is around 60G, one table is 55G. So a
> simple export on release
> 7 will crash when I will get 2G of dump file.
>
> The export utility for release 7 doesn't allow us to
> create multiple files,
> but the export utility for release 8 does.
> I know that they recommend to always use the lower
> version of export, but is
> there a way to use export 8i and create multiple
> files on a Oracle7.3.4
> database?
>
> If not, what can I do?
>
> Thanks
> Luc
>
> ---------
> Luc Demanche
> AstraZeneca R&D Montreal
> Oracle Database Administrator
> 514.832.3200 x2356
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author:
> INET: Luc.Demanche_at_astrazeneca.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
web:
http://www.oracledba.co.uk
web:
http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jan 09 2004 - 08:14:42 CST
