Here is my suggestion: 1. Use file= and filesize= option (8i Rel 2?) to create multiple disk files, copy them to tape. Reload when importing.
2a. Export should not be considered a database backup. (IMHO). In future releases, full=y may not be available. 2b. Depends. If export starts at 10:00 with option consistent=y then no updates after 10:00 will be seen by export. You will get a read consistent image of the database (as of 10:00). With consistent=n (default), updates to rows not yet read by exp will be included in the exported data. There is a good discussion about this in the Oracle8i/9i Utilities Guide. - Kirti -----Original Message----- Sent: Monday, January 13, 2003 4:59 PM To: Multiple recipients of list ORACLE-L 1) Large Export Dumps , if Directly Exported to TAPE Devices , Can Import be safely Done therefrom ? FILE=<Device name> OR is it advisable to compress / Split the Export Dump Files onto Storage Box & thereafter backup the Same onto Tape ? 2) With Oracle 8i & 9i Does export backup fired at a certain Time take ALL Objects's Data existing as at that point in time ? Assuming exp Command is issued to export a Full Database Containing many Tables at 10:00 hours . Assuming Update is Done to Some Table which is yet to be Exported at 10:01 , Will the export backup contain the Updated OR NON-Updated Data ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).