Column Name
| Description
|
APPLIED_SCN (DBA_LOGSTDBY_PROGRESS)
| All transactions with a commit SCN <= this value have been applied
|
APPLIED_SCN (DBA_CAPTURE)
| Everything up to this SCN has been applied
|
CAPTURED_SCN (DBA_CAPTURE)
| Everything up to this SCN has been captured
|
COMMIT_SCN (DBA_LOGSTDBY_EVENTS)
| SCN for the commit record of the transaction
|
CURRENT_SCN (DBA_LOGSTDBY_EVENTS)
| Change vector SCN for the change
|
DICTIONARY_SCN (V$LOGMNR_DICTIONARY)
|
|
DICTIONARY_SCN (GV$LOGMNR_DICTIONARY)
|
|
EARLIEST_SCN (DBA_SUBSCRIPTIONS)
|
|
EARLIEST_SCN (ALL_SUBSCRIPTIONS)
|
|
EARLIEST_SCN (USER_SUBSCRIPTIONS)
|
|
END_SCN (GV$LOGMNR_PARAMETERS)
|
|
END_SCN (V$LOGMNR_PARAMETERS)
|
|
FLASHBACK_SCN (DBA_REPEXTENSIONS)
| Flashback_scn for export or change-based recovery for replication extension
|
HIGH_SCN (GV$LOGSTDBY)
|
|
HIGH_SCN (V$LOGSTDBY)
|
|
IGNORE_SCN (DBA_APPLY_INSTANTIATED_OBJECTS)
| SCN lower bound for messages that will be considered for apply
|
INSTANTIATION_SCN (DBA_APPLY_INSTANTIATED_OBJECTS)
| Point in time when the object was instantiated at source
|
LAST_REFRESH_SCN (USER_SUMMARIES)
| The SCN of the last transaction to refresh the summary
|
LAST_REFRESH_SCN (USER_MVIEW_ANALYSIS)
| The SCN of the last transaction to refresh the materialized view
|
LAST_REFRESH_SCN (ALL_SUMMARIES)
| The SCN of the last transaction to refresh the summary
|
LAST_REFRESH_SCN (DBA_MVIEW_ANALYSIS)
| The SCN of the last transaction to refresh the materialized view
|
LAST_REFRESH_SCN (DBA_SUMMARIES)
| The SCN of the last transaction to refresh the summary
|
LAST_REFRESH_SCN (ALL_MVIEW_ANALYSIS)
| The SCN of the last transaction to refresh the materialized view
|
LATEST_SCN (USER_SUBSCRIPTIONS)
|
|
LATEST_SCN (ALL_SUBSCRIPTIONS)
|
|
LATEST_SCN (DBA_SUBSCRIPTIONS)
|
|
LOW_SCN (GV$LOGMNR_LOGS)
|
|
LOW_SCN (V$LOGMNR_LOGS)
|
|
NEWEST_SCN (DBA_LOGSTDBY_PROGRESS)
| The most recent SCN available on standby.
|
NEXT_SCN (GV$LOGMNR_LOGS)
|
|
NEXT_SCN (V$LOGMNR_LOGS)
|
|
OLDEST_REFRESH_SCN (ALL_REFRESH_DEPENDENCIES)
| The oldest scn of a dependent materialized view
|
READ_SCN (DBA_LOGSTDBY_PROGRESS)
| All log data less than this SCN has been preserved in the database
|
REQUIRED_CHECKPOINT_SCN (DBA_CAPTURE)
| the safe SCN at which the meta-data for the capture process can be purged
|
RESET_SCN (GV$LOGMNR_LOGS)
|
|
RESET_SCN (V$LOGMNR_DICTIONARY)
|
|
RESET_SCN (V$LOGMNR_LOGS)
|
|
RESET_SCN (GV$LOGMNR_DICTIONARY)
|
|
RESET_SCN_TIME (GV$LOGMNR_DICTIONARY)
|
|
RESET_SCN_TIME (GV$LOGMNR_LOGFILE)
|
|
RESET_SCN_TIME (GV$LOGMNR_LOGS)
|
|
RESET_SCN_TIME (V$LOGMNR_DICTIONARY)
|
|
RESET_SCN_TIME (V$LOGMNR_LOGS)
|
|
RESET_SCN_TIME (V$LOGMNR_LOGFILE)
|
|
SCN (ALL_SUMDELTA)
| SCN when the bulk DML occurred
|
SCN (DBA_CAPTURE_PREPARED_TABLES)
| SCN from which changes can be captured
|
SCN (DBA_FGA_AUDIT_TRAIL)
| SCN of the query
|
SCN (GV$LOGMNR_CONTENTS)
|
|
SCN (V$LOGMNR_CONTENTS)
|
|
SCN (ALL_CAPTURE_PREPARED_TABLES)
| SCN from which changes can be captured
|
SCN_NEEDED (V$RECOVERY_STATUS)
|
|
SCN_NEEDED (GV$RECOVERY_STATUS)
|
|
SOURCE_COMMIT_SCN (ALL_APPLY_ERROR)
| Original commit SCN for the transaction at the source database
|
SOURCE_COMMIT_SCN (DBA_APPLY_ERROR)
| Original commit SCN for the transaction at the source database
|
START_SCN (ALL_CAPTURE)
| The SCN from which capturing will be resumed
|
START_SCN (V$LOGMNR_PARAMETERS)
|
|
START_SCN (GV$LOGMNR_PARAMETERS)
|
|
START_SCN (DBA_CAPTURE)
| The SCN from which capturing will be resumed
|