Re: Export bigger then 2G with Oracle7.3.4

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Fri, 09 Jan 2004 06:59:27 -0800
Message-ID: <F001.005DC44C.20040109065927@fatcity.com>

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.

are you certain that you want to use exp/imp for a 55 GB table?

> So a simple export on release
> 7 will crash when I will get 2G of dump file.

It likely won't. I've seen a dump file on 7.3.4.4.5/NT4 sp6 of 8 GB. Max supported filesize with a 4KB block was 32 GB for datafiles.

> 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?

export FULL=Y ROWS=N.
export all tables except for the 55 GB one via exp73.exe and unload the 55 GB table, load it via sqlldr.exe of the target database version.

>
> Thanks
> Luc

hth.

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.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).

Received on Fri Jan 09 2004 - 08:59:27 CST