Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 2 basic Qs. on export
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.
-----Original Message-----
Sent: Monday, January 13, 2003 4:59 PM
To: Multiple recipients of list ORACLE-L
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: VIVEK_SHARMA_at_infosys.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.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 Mon Jan 13 2003 - 20:53:48 CST
![]() |
![]() |