Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Export bigger then 2G with Oracle7.3.4
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.
Pd
-- 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
![]() |
![]() |