--- [EMAIL PROTECTED] 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. Pd __________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).