Oracle DBMS_HIERARCHY
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Analytic view validation
AUTHID CURRENT_USER
Dependencies
DBMS_ASSERT DBMS_HCS_LIB  
Documented Yes
First Available 12.2.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source $ORACLE_HOME/rdbms/admin/
Subprograms
 
CREATE_VALIDATE_LOG_TABLE (new 12.2)
Creates a log table for use in validating hierarchies dbms_hierarchy.create_validate_log_table(
table_name       IN VARCHAR2,
owner_name       IN VARCHAR2,
ignore_if_exists IN BOOLEAN);
exec dbms_hierarchy.create_validate_log_table('UWLOGTAB', 'UWCLASS', TRUE);
 
VALIDATE_ANALYTIC_VIEW (new 12.2)
Validates an analytic view writing output to the named log table dbms_hierarchy.validate_analytic_view(
analytic_view_name       IN VARCHAR2,
analytic_view_owner_name IN VARCHAR2,
log_table_name           IN VARCHAR2,
log_table_owner_name     IN VARCHAR2);
exec dbms_hierarchy.validate_analytic_view('UWAVIEW', 'UWCLASS', 'UWLOGTAB', 'UWCLASS', TRUE);
 
VALIDATE_CHECK_SUCCESS (new 12.2)
Undocumented dbms_hierarchy.validate_check_success(
topobj_name          IN VARCHAR2,
topobj_owner         IN VARCHAR2,
log_number           IN NUMBER,
log_table_name       IN VARCHAR2,
log_table_owner_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
VALIDATE_HIERARCHY (new 12.2)
Validate a hierarchy writing output to the named log table dbms_hierarchy.validate_hierarchy(
hier_name            IN VARCHAR2,
hier_owner_name      IN VARCHAR2,
log_table_name       IN VARCHAR2,
log_table_owner_name IN VARCHAR2)
RETURN NUMBER;
TBD

Related Topics
Built-in Functions
Built-in Packages
Analytic Views
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved