| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> MLOG$_ ?
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: rkjoseph_at_now-india.net.in
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: 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 Thu May 24 2001 - 21:55:23 CDT
 |
 |