Change Data Capture (CDC) identifies data in relational tables that has been added to, modified, or removed and publishes the changed data in a form that is usable by an application.
Subprocedures: CREATE_CHANGE_TABLE Create a change table in a specified schema and create corresponding Change Data Capture metadata. ALTER_CHANGE_TABLE Add or drop columns for an existing change table, or change the properties of an existing change table. DROP_SUBSCRIBER_VIEW Allow the publisher to drop a subscriber view from the subscriber's schema. The view must have been created by a prior call to the PREPARE_SUBSCRIBER_VIEW procedure. DROP_SUBSCRIPTION Allow a publisher to drop a subscription that was created with a prior call to the GET_SUBSCRIPTION_HANDLE procedure. DROP_CHANGE_TABLE Drop an existing change table when there is no more activity on the table. PURGE Monitor usage by all subscriptions, determine which rows are no longer needed by subscriptions, and remove the unneeded rows to prevent change tables from growing endlessly.
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
V$LOG V$LOGFILE V$LOGHIST V$LOGMNR_CONTENTS V$LOGMNR_DICTIONARY V$LOGMNR_LOGS V$LOGMNR_PARAMETERS V$LOG_HISTORY
© Copyright SS64.com 1999-2013
Some rights reserved