hi,
when one creates a snapshot log ( with rowid ) the following table structure
is created
Name Null? Type
----------------------------------------- -------- ----------------------
------
1. M_ROW$$ VARCHAR2(255)
2. SNAPTIME$$ DATE
3. DMLTYPE$$ VARCHAR2(1)
4. OLD_NEW$$ VARCHAR2(1)
5. CHANGE_VECTOR$$ RAW(255)
the first column holds the rowid, the 3rd the type of dml.
any idea what the others contail ?
the second column contains a fixed date '01-Jan-4000 00:00' ? In earlier
versions ( 7.0.x ) it used to contain a null for a similar snapshot log.
what is the significance of logging/nologging in snapshot creation. in
case of a recovery as and when the data is recovered from the logs the
triggers would anyway fire and populate the mlog$_ tables ?
regards,
joseph raj kumar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph Raj
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
