|
|
| |
 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 2 -
Streams
Components and Processes
DDL LCRs
-
object_name - This is the name of
the database object on which the DDL statement was executed.
-
object_type - This is the type of
database object on which the DDL statement was run, for example
TABLE or PACKAGE.
-
ddl_text - This is the text of the
DDL statement.
-
logon_user - This is the logon user,
which is the user whose session executed the DDL statement.
-
base_table_owner - This is the base
table owner. If the DDL statement is dependent on a table, the
base table owner is the owner of the table on which it is
dependent.
-
base_table_name - This is the base
table name. If the DDL statement is dependent on a table, the
base table name is the name of the table on which it is
dependent.
-
tag - This is a raw tag that can be
used to track the LCR.
-
transaction_id - This is the
identifier of the transaction in which the DDL statement was
run.
-
scn - This is the SCN when the
change was written to the redo log.
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
|
|
