Source Extractors - SQL Extractor - Information - How to find the Modified Schemas during Extraction

Purpose

This page provides information on how to find the schema’s that are modified during the online extraction process.

Applicable in CAST Version

Query for Extractor

When running the CAST Database extractor, you may come across the following message 

"Some objects from 'Schema A' have been compiled during the extraction: initial 'Last Compilation Date' is '2018-01-08 13:36:57.0', new 'Last Compilation Date' is '2018-01-08 13:37:13.0'"  
  
If you need to check, what the objects that have been modified in this step are, you can run the below query.

    select *
    from %prefixSysView%_objects do
    where do.owner = '<your Schema Name>'
    and do.object_type in ('TYPE', 'TYPE BODY', 'PACKAGE', 'PACKAGE BODY', 'PROCEDURE', 'FUNCTION', 'TRIGGER', 'TABLE', 'MATERIALIZED VIEW', 'SEQUENCE', 'INDEX', 'SYNONYM', 'VIEW')

The state %prefixSysView% is defined in your extraction log file.

You can search for: prefixSysView.

Query Example is given below.

You have to replace the value of prefixSysView as seen in the Extraction log file in your query.

    select *
    from dba_objects do
    where do.owner = '<your Schema Name>'
    and do.object_type in ('TYPE', 'TYPE BODY', 'PACKAGE', 'PACKAGE BODY', 'PROCEDURE', 'FUNCTION', 'TRIGGER', 'TABLE', 'MATERIALIZED VIEW', 'SEQUENCE', 'INDEX', 'SYNONYM', 'VIEW')

Notes/comments

Ticket # 17536

Related Pages