Re: Hot Backups

From: Doug Harris <ah513_at_Freenet.carleton.ca>
Date: Thu, 25 Nov 1993 15:39:22 GMT
Message-ID: <CH20tM.AAL_at_freenet.carleton.ca>

In a previous article, cds016_at_isadmin1.comm.mot.com (David Schmitt) says:

>      When running exports...


>	You can keep the database up, but then you sacrifice


>	logical consistency _between_ tables (logical consistency is maintained

>	_within_ a table, however).


   The Oracle7 export has a new option CONSISTENT=Y which provides logical
consistency between tables. It is unfortunately incompatible with 

incremental exports. exp is essentially performing a SET TRANSACTION READ ONLY at the beginning of the export.

-- 
   - Doug Harris
     Database Administrator,
     System Development Division,
     Statistics Canada             ### Standard Disclaimer Applies ###

Received on Thu Nov 25 1993 - 16:39:22 CET