DBA Data[Home] [Help]

VIEW: SYS.DBA_STREAMS_RENAME_TABLE

Source

View Text - Preformatted

select rule_owner, rule_name, from_schema_name, to_schema_name,
       from_table_name, to_table_name, precedence, step_number
  from DBA_STREAMS_TRANSFORMATIONS
  where declarative_type = 'RENAME TABLE'
View Text - HTML Formatted

SELECT RULE_OWNER
, RULE_NAME
, FROM_SCHEMA_NAME
, TO_SCHEMA_NAME
, FROM_TABLE_NAME
, TO_TABLE_NAME
, PRECEDENCE
, STEP_NUMBER
FROM DBA_STREAMS_TRANSFORMATIONS
WHERE DECLARATIVE_TYPE = 'RENAME TABLE'