Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Utility package with objects supporting DBMS_ADVISOR.TUNE_MVIEW
prvt_tune_mview.validate_tune_mview(
mv_crate_stmt IN CLOB,
xmv_array OUT VARRAY,
mvowner OUT VARCHAR2,
mvname OUT VARCHAR2,
mvname_pos OUT BINARY_INTEGER,
refresh_pos OUT BINARY_INTEGER,
as_pos OUT BINARY_INTEGER,
refresh_type OUT BINARY_INTEGER,
mv_flags OUT BINARY_INTEGER,
text_match_only OUT BOOLEAN,
complete_ref OUT BOOLEAN,
already_fr OUT BOOLEAN,
already_rw OUT BOOLEAN,
tuneable OUT BOOLEAN,
is_single_qb OUT BOOLEAN,
has_like OUT BOOLEAN,
check_mvlog IN BOOLEAN,
mlog_only OUT BOOLEAN,
REASON_BUF IN OUT VARCHAR2);