Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 7.3.4 Export Utility

Oracle 7.3.4 Export Utility

From: <tychak_at_gmail.com>
Date: 4 Jan 2006 23:37:48 -0800
Message-ID: <1136446668.210198.38850@g47g2000cwa.googlegroups.com>


I'm working with Oracle 7.3.4 and I have to use "exp" to export the database for data backup.

As limited by operating system, the dump file cannot be larger than 2G. However, I need to perform a full export (full=y). Therefore, the export always fails.

Is there other ways to split the dump to multiple files? (I cannot use special device for compression or splitting as mentioned in other posts)

Can it be as the following?

full export using "full=y rows=0" to export all things without data export by table and exports all data in all tables table by table

Will there be anything such as indexes, constraints, grants, and triggers missing by the above method?

Thanks very much. Received on Thu Jan 05 2006 - 01:37:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US