Rem ########################################################################## Rem Rem Copyright (c) 2001, 2006, Oracle. All rights reserved. Rem Rem NAME Rem catodm.sql Rem Rem DESCRIPTION Rem Run all sql scripts for Data Mining Installation Rem Rem RETURNS Rem Rem NOTES Rem This script must be run while connected as SYS Rem Rem MODIFIED (MM/DD/YY) Rem dmukhin 12/08/06 - bug 5557333: AR scoping Rem dmukhin 10/27/06 - bug 5462460: alter reverse expression Rem mmcracke 08/03/06 - Remove OC persistence object types Rem bmilenov 07/19/06 - Rename fields in dm_glm_coeff Rem bmilenov 07/17/06 - Add 3 output column to dm_glm_coeff Rem bmilenov 06/19/06 - Add more columns to dm_glm_coeff type Rem bmilenov 05/30/06 - Change output type of get_model_details_glm Rem bmilenov 05/23/06 - Change GLM get model details types Rem ramkrish 03/27/06 - add GLM Rem mmcracke 05/23/06 - Move ora_mining_tables_nt type here. Rem xbarr 05/22/06 - Merge odmcrt.sql to catodm.sql Rem amozes 05/15/06 - support scoping for nested data Rem dmukhin 05/12/06 - prj 18876: scoring cost matrix Rem dmukhin 03/24/06 - ADP: add types Rem mmcracke 03/10/06 - dmsyssch.sql table creates moved to ddm.bsq Rem mmcracke 03/10/06 - dmsyssch.sql type creates moved here Rem mmcracke 03/10/06 - dmsyssch.sql view creates moved to catalog.sql Rem mmcracke 03/10/06 - all dbmsdmxxx.sql moved to dbmsodm.sql Rem mmcracke 03/10/06 - all prvtdmxxx.plb moved to prvtodm.sql Rem mmcracke 03/08/06 - Create ODM TYPES here Rem mmcracke 09/29/05 - Change DMSYS to SYS Rem xbarr 11/05/04 - remove validation proc from dmsys Rem pstengar 08/24/04 - add prvtdmpa.plb Rem fcay 06/30/04 - Use dbmsdmpa.sql Rem svenkaya 06/29/04 - added prvtdmj Rem xbarr 06/28/04 - run dmsyssch.sql only Rem xbarr 06/23/04 - Merge dmpproc to dmproc, remove dmapi/dmutil Rem mmcracke 06/21/04 - Merge dmpsyssch.sql into dmsyssch.sql Rem cbhagwat 06/18/04 - Change blast name Rem amozes 06/23/04 - remove hard tabs Rem cbhagwat 06/09/04 - code reorg Rem xbarr 06/07/04 - update ojdm Rem xbarr 10/20/03 - update pmml dtd loading Rem fcay 06/23/03 - Update copyright notice Rem xbarr 06/02/03 - remove dmpsysup Rem xbarr 03/10/03 - add dmcl.plb Rem xbarr 03/08/03 - remove odmerr.sql Rem xbarr 02/26/03 - fix error in odm.log Rem xbarr 02/03/03 - add odmproc Rem xbarr 01/27/03 - add dmpsysup Rem xbarr 01/06/03 - add PL/SQL api code for Beta Rem xbarr 11/19/02 - add blast Rem xbarr 10/10/02 - remove odmcrt from script. To be run by dminst Rem xbarr 09/25/02 - xbarr_txn104463 Rem xbarr 09/24/02 - updated for 10i installation to be called by odminst Rem xbarr 09/24/02 - replicated from 9202 branch Rem xbarr 08/02/02 - xbarr_txn102957 Rem xbarr 06/06/02 - relocate odmdbmig script to in dm/admin/odmu901.sql Rem xbarr 03/12/02 - add dmerrtbl_mig Rem xbarr 03/08/02 - add registry information in dba_registry Rem xbarr 03/07/02 - add error table loading Rem xbarr 03/07/02 - use separate sqlldr related file Rem xbarr 03/07/02 - remove odmupd line Rem xbarr 01/24/02 - add dmmig.sql for R2 privileges Rem xbarr 01/21/02 - add PMML dataset addition Rem xbarr 01/14/02 - commented out dmupd. Will be replaced by dmconfig Rem xbarr 01/14/02 - use .plb Rem xbarr 12/10/01 - Merged xbarr_update_shipit Rem xbarr 12/04/01 - Merged xbarr_migration_scripts Rem Rem xbarr 12/10/01 - Updated script name and location Rem xbarr 12/03/01 - Updated to be called by ODMA Rem xbarr 10/27/01 - Creation Rem Rem ######################################################################### alter session set current_schema = "SYS"; Rem PL/SQL API exp/imp privilegs DELETE FROM exppkgact$ WHERE SCHEMA='SYS' AND package='DBMS_DM_MODEL_EXP' AND class IN (2,3,6) AND level# IN (1000,2000,4000); INSERT INTO exppkgact$ (package, schema, class, level#) VALUES ('DBMS_DM_MODEL_EXP', 'SYS', 2, 2000); INSERT INTO exppkgact$ (package, schema, class, level#) VALUES ('DBMS_DM_MODEL_EXP', 'SYS', 3, 4000); INSERT INTO exppkgact$ (package, schema, class, level#) VALUES ('DBMS_DM_MODEL_EXP', 'SYS', 6, 1000); commit; -- ORA_MINING_NUMBER_NT create or replace type ora_mining_number_nt as table of number / create or replace public synonym ora_mining_number_nt for sys.ora_mining_number_nt / grant execute on ora_mining_number_nt to public with grant option / -- ORA_MINING_VARCHAR2_NT create or replace type ora_mining_varchar2_nt as table of varchar2(4000) / create or replace public synonym ora_mining_varchar2_nt for sys.ora_mining_varchar2_nt / grant execute on ora_mining_varchar2_nt to public with grant option / -- ORA_MINING_TABLE_TYPE create or replace type ora_mining_table_type as object (table_name varchar2(30), table_type varchar2(30)) / create or replace public synonym ora_mining_table_type for sys.ora_mining_table_type / grant execute on ora_mining_table_type to public with grant option / -- ORA_MINING_TABLES_NT create or replace type ora_mining_tables_nt as table of sys.ora_mining_table_type / create or replace public synonym ora_mining_tables_nt for sys.ora_mining_tables_nt / grant execute on ora_mining_tables_nt to public / -- DM_MODEL_SIGNATURE_ATTRIBUTE create or replace type dm_model_signature_attribute as object (attribute_name varchar2(30) ,attribute_type varchar2(106)) / create or replace public synonym dm_model_signature_attribute for sys.dm_model_signature_attribute / grant execute on dm_model_signature_attribute to public with grant option / -- DM_MODEL_SIGNATURE create or replace type dm_model_signature as table of dm_model_signature_attribute / create or replace public synonym dm_model_signature for sys.dm_model_signature / grant execute on dm_model_signature to public with grant option / -- DM_MODEL_SETTING create or replace type dm_model_setting as object (setting_name varchar2(30) ,setting_value varchar2(128)) / create or replace public synonym dm_model_setting for sys.dm_model_setting / grant execute on dm_model_setting to public with grant option / -- DM_MODEL_SETTINGS create or replace type dm_model_settings as table of dm_model_setting / create or replace public synonym dm_model_settings for sys.dm_model_settings / grant execute on dm_model_settings to public with grant option / -- DM_PREDICATE create or replace type dm_predicate authid current_user as object (attribute_name varchar2(4000) ,attribute_subname varchar2(4000) ,conditional_operator char(2) /* =, <>, <, >, <=, >= */ ,attribute_num_value number ,attribute_str_value varchar2(4000) ,attribute_support number ,attribute_confidence number) / create or replace public synonym dm_predicate for sys.dm_predicate / grant execute on dm_predicate to public with grant option / -- DM_PREDICATES create or replace type dm_predicates as table of dm_predicate / create or replace public synonym dm_predicates for sys.dm_predicates / grant execute on dm_predicates to public with grant option / -- DM_RULE create or replace type dm_rule as object (rule_id integer ,antecedent dm_predicates ,consequent dm_predicates ,rule_support number ,rule_confidence number ,rule_lift number ,antecedent_support number ,consequent_support number ,number_of_items integer) / create or replace public synonym dm_rule for sys.dm_rule / grant execute on dm_rule to public with grant option / -- DM_RULES create or replace type dm_rules as table of dm_rule / create or replace public synonym dm_rules for sys.dm_rules / grant execute on dm_rules to public with grant option / -- DM_ITEM create or replace type dm_item as object ( attribute_name varchar2(4000), attribute_subname varchar2(4000), attribute_num_value number, attribute_str_value varchar2(4000)) / create or replace public synonym dm_item for sys.dm_item / grant execute on dm_item to public with grant option / -- DM_ITEMS create or replace type dm_items as table of dm_item / create or replace public synonym dm_items for sys.dm_items / grant execute on dm_items to public with grant option / -- DM_ITEMSET create or replace type dm_itemset as object (itemset_id integer ,items dm_items ,support number ,number_of_items number) / create or replace public synonym dm_itemset for sys.dm_itemset / grant execute on dm_itemset to public with grant option / -- DM_ITEMSETS create or replace type dm_itemsets as table of dm_itemset / create or replace public synonym dm_itemsets for sys.dm_itemsets / grant execute on dm_itemsets to public with grant option / -- DM_CENTROID create or replace type dm_centroid as object (attribute_name varchar2(4000) ,attribute_subname varchar2(4000) ,mean number ,mode_value varchar2(4000) ,variance number) / create or replace public synonym dm_centroid for sys.dm_centroid / grant execute on dm_centroid to public with grant option / -- DM_CENTROIDS create or replace type dm_centroids as table of dm_centroid / create or replace public synonym dm_centroids for sys.dm_centroids / grant execute on dm_centroids to public with grant option / -- DM_HISTOGRAM_BIN create or replace type dm_histogram_bin as object (attribute_name varchar2(4000) ,attribute_subname varchar2(4000) ,bin_id number ,lower_bound number ,upper_bound number ,label varchar2(4000) ,count number) / create or replace public synonym dm_histogram_bin for sys.dm_histogram_bin / grant execute on dm_histogram_bin to public with grant option / -- DM_HISTOGRAMS create or replace type dm_histograms as table of dm_histogram_bin / create or replace public synonym dm_histograms for sys.dm_histograms / grant execute on dm_histograms to public with grant option / -- DM_CHILD create or replace type dm_child as object (id number) / create or replace public synonym dm_child for sys.dm_child / grant execute on dm_child to public with grant option / -- DM_CHILDREN create or replace type dm_children as table of dm_child / create or replace public synonym dm_children for sys.dm_children / grant execute on dm_children to public with grant option / -- DM_CLUSTER create or replace type dm_cluster as object (id number ,cluster_id varchar2(4000) ,record_count number ,parent number ,tree_level number ,dispersion number ,split_predicate dm_predicates ,child dm_children ,centroid dm_centroids ,histogram dm_histograms ,rule dm_rule) / create or replace public synonym dm_cluster for sys.dm_cluster / grant execute on dm_cluster to public with grant option / -- DM_CLUSTERS create or replace type dm_clusters as table of dm_cluster / create or replace public synonym dm_clusters for sys.dm_clusters / grant execute on dm_clusters to public with grant option / -- DM_CONDITIONAL create or replace type dm_conditional as object (attribute_name varchar2(4000) ,attribute_subname varchar2(4000) ,attribute_str_value varchar2(4000) ,attribute_num_value number ,conditional_probability number) / create or replace public synonym dm_conditional for sys.dm_conditional / grant execute on dm_conditional to public with grant option / -- DM_CONDITIONALS create or replace type dm_conditionals as table of dm_conditional / create or replace public synonym dm_conditionals for sys.dm_conditionals / grant execute on dm_conditionals to public with grant option / -- DM_NB_DETAIL create or replace type dm_nb_detail as object (target_attribute_name varchar2(30) ,target_attribute_str_value varchar2(4000) ,target_attribute_num_value number ,prior_probability number ,conditionals dm_conditionals) / create or replace public synonym dm_nb_detail for sys.dm_nb_detail / grant execute on dm_nb_detail to public with grant option / -- DM_NB_DETAILS create or replace type dm_nb_details as table of dm_nb_detail / create or replace public synonym dm_nb_details for sys.dm_nb_details / grant execute on dm_nb_details to public with grant option / -- DM_ABN_DETAIL create or replace type dm_abn_detail as object (rule_id integer ,antecedent dm_predicates ,consequent dm_predicates ,rule_support number) / create or replace public synonym dm_abn_detail for sys.dm_abn_detail / grant execute on dm_abn_detail to public with grant option / -- DM_ABN_DETAILS create or replace type dm_abn_details as table of dm_abn_detail / create or replace public synonym dm_abn_details for sys.dm_abn_details / grant execute on dm_abn_details to public with grant option / -- DM_NMF_ATTRIBUTE create or replace type dm_nmf_attribute as object (attribute_name varchar2(4000) ,attribute_subname varchar2(4000) ,attribute_value varchar2(4000) ,coefficient number) / create or replace public synonym dm_nmf_attribute for sys.dm_nmf_attribute / grant execute on dm_nmf_attribute to public with grant option / -- DM_NMF_ATTRIBUTE_SET create or replace type dm_nmf_attribute_set as table of dm_nmf_attribute / create or replace public synonym dm_nmf_attribute_set for sys.dm_nmf_attribute_set / grant execute on dm_nmf_attribute_set to public with grant option / -- DM_NMF_FEATURE create or replace type dm_nmf_feature as object (feature_id number ,mapped_feature_id varchar2(4000) ,attribute_set dm_nmf_attribute_set) / create or replace public synonym dm_nmf_feature for sys.dm_nmf_feature / grant execute on dm_nmf_feature to public with grant option / -- DM_NMF_FEATURE_SET create or replace type dm_nmf_feature_set as table of dm_nmf_feature / create or replace public synonym dm_nmf_feature_set for sys.dm_nmf_feature_set / grant execute on dm_nmf_feature_set to public with grant option / -- DM_SVM_ATTRIBUTE create or replace type dm_svm_attribute as object (attribute_name varchar2(4000) ,attribute_subname varchar2(4000) ,attribute_value varchar2(4000) ,coefficient number) / create or replace public synonym dm_svm_attribute for sys.dm_svm_attribute / grant execute on dm_svm_attribute to public with grant option / -- DM_SVM_ATTRIBUTE_SET create or replace type dm_svm_attribute_set as table of dm_svm_attribute / create or replace public synonym dm_svm_attribute_set for sys.dm_svm_attribute_set / grant execute on dm_svm_attribute_set to public with grant option / -- DM_SVM_LINEAR_COEFF create or replace type dm_svm_linear_coeff as object (class varchar2(4000) ,attribute_set dm_svm_attribute_set) / create or replace public synonym dm_svm_linear_coeff for sys.dm_svm_linear_coeff / grant execute on dm_svm_linear_coeff to public with grant option / -- DM_SVM_LINEAR_COEFF_SET create or replace type dm_svm_linear_coeff_set as table of dm_svm_linear_coeff / create or replace public synonym dm_svm_linear_coeff_set for sys.dm_svm_linear_coeff_set / grant execute on dm_svm_linear_coeff_set to public with grant option / -- DM_GLM_COEFF create or replace type dm_glm_coeff as object (class varchar2(4000) ,attribute_name VARCHAR2(4000) ,attribute_subname VARCHAR2(4000) ,attribute_value VARCHAR2(4000) ,coefficient NUMBER ,std_error NUMBER ,test_statistic NUMBER ,p_value NUMBER ,vif NUMBER ,std_coefficient NUMBER ,lower_coeff_limit NUMBER ,upper_coeff_limit NUMBER ,exp_coefficient BINARY_DOUBLE ,exp_lower_coeff_limit BINARY_DOUBLE ,exp_upper_coeff_limit BINARY_DOUBLE ) / create or replace public synonym dm_glm_coeff for sys.dm_glm_coeff / grant execute on dm_glm_coeff to public with grant option / -- DM_GLM_COEFF_SET create or replace type dm_glm_coeff_set as table of dm_glm_coeff / create or replace public synonym dm_glm_coeff_set for sys.dm_glm_coeff_set / grant execute on dm_glm_coeff_set to public with grant option / -- DM_MODEL_GLOBAL_DETAIL create or replace type dm_model_global_detail as object (global_detail_name VARCHAR2(30) ,global_detail_value number) / create or replace public synonym dm_model_global_detail for sys.dm_model_global_detail / grant execute on dm_model_global_detail to public with grant option / -- DM_MODEL_GLOBAL_DETAILS create or replace type dm_model_global_details as table of dm_model_global_detail / create or replace public synonym dm_model_global_details for sys.dm_model_global_details / grant execute on dm_model_global_details to public with grant option / -- dm_nested_numerical create or replace type dm_nested_numerical as object (attribute_name varchar2(4000) ,value number) / create or replace public synonym dm_nested_numerical for sys.dm_nested_numerical / grant execute on dm_nested_numerical to public with grant option / -- DM_NESTED_NUMERICALS create or replace type dm_nested_numericals as table of dm_nested_numerical / create or replace public synonym dm_nested_numericals for sys.dm_nested_numericals / grant execute on dm_nested_numericals to public with grant option / -- DM_NESTED_CATEGORICAL create or replace type dm_nested_categorical as object (attribute_name varchar2(4000) ,value varchar2(4000)) / create or replace public synonym dm_nested_categorical for sys.dm_nested_categorical / grant execute on dm_nested_categorical to public with grant option / -- DM_NESTED_CATEGORICALS create or replace type dm_nested_categoricals as table of dm_nested_categorical / create or replace public synonym dm_nested_categoricals for sys.dm_nested_categoricals / grant execute on dm_nested_categoricals to public with grant option / -- DM_RANKED_ATTRIBUTE create or replace type dm_ranked_attribute as object (attribute_name varchar2(4000), attribute_subname varchar2(4000), importance_value number, rank number(38)) / create or replace public synonym dm_ranked_attribute for sys.dm_ranked_attribute / grant execute on dm_ranked_attribute to public with grant option / -- DM_RANKED_ATTRIBUTES create or replace type dm_ranked_attributes as table of dm_ranked_attribute / create or replace public synonym dm_ranked_attributes for sys.dm_ranked_attributes / grant execute on dm_ranked_attributes to public with grant option / -- DM_TRANSFORM create or replace type dm_transform as object ( attribute_name varchar2(4000), attribute_subname varchar2(4000), expression clob, reverse_expression clob) / create or replace public synonym dm_transform for sys.dm_transform / grant execute on dm_transform to public with grant option / -- DM_TRANSFORMS create or replace type dm_transforms as table of dm_transform / create or replace public synonym dm_transforms for sys.dm_transforms / grant execute on dm_transforms to public with grant option / -- DM_COST_ELEMENT create or replace type dm_cost_element as object ( actual varchar2(4000), predicted varchar2(4000), cost number) / create or replace public synonym dm_cost_element for sys.dm_cost_element / grant execute on dm_cost_element to public with grant option / -- DM_COST_MATRIX create or replace type dm_cost_matrix as table of dm_cost_element / create or replace public synonym dm_cost_matrix for sys.dm_cost_matrix / grant execute on dm_cost_matrix to public with grant option /