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 --- [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. 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: [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). ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "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: [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).
