Purpose
This page provides information on how to find the schema's that are modified during the online extraction process.
Applicable in CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
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