Rem Rem $Header: sdo/admin/semrelod.sql /st_sdo_11.2.0/12 2011/07/16 04:43:00 sdas Exp $ Rem Rem semrelod.sql Rem Rem Copyright (c) 2009, 2011, Oracle and/or its affiliates. Rem All rights reserved. Rem Rem NAME Rem semrelod.sql - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem MODIFIED (MM/DD/YY) Rem sdas 07/15/11 - export from 11.2.0.3 - truncate RDF_PARAM$_TBL Rem table Rem spsundar 05/13/11 - rename sem_contains_score to sem_contains_count Rem matperry 05/04/11 - always recreate views and triggers Rem sdas 03/14/11 - export from 11.2.0.3 Rem matperry 03/10/11 - refactor post reload steps to semu111post and Rem semu112post Rem matperry 03/08/11 - update for named graph migration Rem matperry 12/03/10 - update for refactored semgeo packages Rem sdas 11/22/10 - XbranchMerge sdas_ng_11.2.0.2.0_11.2.0.3.0 from Rem st_sdo_11.2.0 Rem sdas 11/22/10 - XbranchMerge sdas_ng_11.2.0.2.0 from Rem matperry 08/26/10 - coordinate with semu112ng.sql for NG path upgrade Rem sdas 08/11/10 - XbranchMerge sdas_bug-9937565 from st_sdo_11.2.0 Rem vkolovsk 07/29/10 - XbranchMerge Rem vkolovsk_rdf_ols_set_triple_label_11.2.0.2.0 from Rem st_sdo_11.2.0 Rem vkolovsk 07/28/10 - XbranchMerge vkolovsk_bug-9724396 from Rem sdas 07/25/10 - create RDF_PRIV$ view if absent in network Rem sdas 07/19/10 - allow loadMethod spec in prllidx_create type spec Rem matperry 07/01/10 - create parallel rdfctx types on upgrade Rem vkolovsk 06/11/10 - tweak recreate rdf triggers: dont do it if Rem version enabled Rem vkolovsk 06/11/10 - recreate triggers - needed for upgrading OLS data Rem to 11.2.0.2 Rem vkolovsk 06/10/10 - remove sdo_sem_magic package Rem vkolovsk 06/08/10 - fix install of OLS Rem vkolovsk 06/04/10 - remove magic set packages from loading Rem matperry 05/05/10 - comment out default install of geo Rem vkolovsk 05/04/10 - add session-specific application context Rem vkolovsk 04/23/10 - XbranchMerge vkolovsk_bug-9646520 from main Rem vkolovsk 04/21/10 - change RL -> OWL2RL Rem vkolovsk 04/19/10 - add RL rulebase Rem matperry 04/02/10 - update for optional RDFGEO component Rem matperry 03/10/10 - update SEM_VERSION to 11202 Rem matperry 02/16/10 - make sure RDFOLS_SECUREACCESS trigger does not Rem make installation invalid Rem matperry 12/14/09 - update SEM_VERSION to 112_P1 Rem matperry 12/10/09 - add call to convert_old_rdf_data Rem matperry 12/07/09 - add checks for xsd_time and xsd_boolean data Rem validity Rem matperry 05/26/09 - add check for rdfctx_admin role before trying to Rem install rdfctx Rem ayalaman 05/19/09 - reload CTX, WM and SA implementations Rem matperry 05/18/09 - set rdf_match to a dummy function if semantic Rem data needs migration from 11.1 to 11.2 Rem matperry 02/11/09 - Created Rem ---------------------------------------------------------------------- -- Loads PL/SQL packages and loads sdordf.jar -- ---------------------------------------------------------------------- set echo off; alter session set current_schema=MDSYS; Rem RDF Match stuff @@sdordfa.sql Rem Load RDF types and packages @@sdordfh.sql @@sdordfxh.sql @@prvrdftp.plb Rem Load SEM context @@sdosemctxh.sql Rem Load SEM log @@sdosemlogh.sql Rem Load SEM utility @@sdosemutlh.sql Rem Load SEM owlfast inference @@sdoseminfh.sql @@sdoseminfhh.sql @@sdoseminfih.sql Rem Load SEM owlfast validation @@sdosemvalh.sql Rem MS related @@sdoseminfmh.plb @@sdordfai.plb Rem MS related --@@sdoseminfmr.plb @@sdordfm.plb @@sdordfrb.sql Rem Load RDF package body @@sdordfb.plb @@sdordfxb.plb Rem Add context: CREATE OR REPLACE CONTEXT SDO_SEM_CTX using MDSYS.SDO_SEM_CTX accessed globally; Rem Add session-specific context: CREATE OR REPLACE CONTEXT SDO_SEM_CTX_SESSION using MDSYS.SDO_SEM_CTX_SESSION; Rem Load context implementations @@sdosemctxb.plb Rem Load Log implementations @@sdosemlogb.plb Rem Load clique building package @@sdosemsam.plb Rem Load SEM implementations @@sdosemutlb.plb @@sdoseminfb.plb @@sdoseminfhb.plb @@sdoseminfib.plb @@sdosemvalb.plb Rem SEM operators @@sdosemopih.plb @@sdosemopib.plb @@sdosemop.plb @@sdosemopst.plb Rem SEM Triggers @@sdosemtrig.plb REM RDF upgrade and data migration @@sdosemdmh.sql @@sdosemdmb.plb REM RDF/OWL downgrade preparation package @@sdosemdgh.sql @@sdosemdgb.plb @@sdosemdgu.plb alter session set current_schema=SYS; -- load sdordf @@semloadj.sql alter session set current_schema=MDSYS; -- --- reload implementations for optional components (WM, CTX, OLS & VPD) -- COLUMN :script_name1 NEW_VALUE comp_file1 NOPRINT VARIABLE script_name1 VARCHAR2(30) COLUMN :script_name2 NEW_VALUE comp_file2 NOPRINT VARIABLE script_name2 VARCHAR2(30) COLUMN :script_name3 NEW_VALUE comp_file3 NOPRINT VARIABLE script_name3 VARCHAR2(30) declare refcount number := 0; begin refcount := 0; begin execute immediate 'select count(*) from mdsys.rdf_parameter where namespace = ''COMPONENT'' and attribute = ''RDFCTX''' into refcount; exception when others then null; end; if (refcount > 0) then :script_name1 := '@prvtrdfctx.plb'; else -- make sure rdfctx_admin role doesn't exist before install -- refcount := 0; begin execute immediate 'select count(*) from dba_roles where role = ''RDFCTX_ADMIN''' into refcount; exception when others then null; end; if (refcount > 0) then -- conflicting RDFCTX_ADMIN role exists: log error and don't do anything -- :script_name1 := dbms_registry.nothing_script; SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'Not installing RDFCTX: a conflicting RDFCTX_ADMIN role exists'); else :script_name1 := '@sdordfctx.sql'; end if; end if; refcount := 0; begin execute immediate 'select count(*) from mdsys.rdf_parameter where namespace = ''COMPONENT'' and attribute = ''RDFOWM''' into refcount; exception when others then null; end; if (refcount > 0) then :script_name2 := '@prvtrdfwm.plb'; else :script_name2 := dbms_registry.nothing_script; end if; refcount := 0; begin execute immediate 'select count(*) from mdsys.rdf_parameter where namespace = ''COMPONENT'' and attribute in (''RDFVPD'', ''RDFOLS'')' into refcount; exception when others then null; end; -- in both cases, install sdordfsa.sql - this is more upgrade friendly if (refcount > 0) then :script_name3 := '@sdordfsa.sql'; -- :script_name3 := '@pvtrdfsa.plb'; else :script_name3 := '@sdordfsa.sql'; end if; end; / show errors; set define on; SELECT :script_name1 FROM DUAL; @&comp_file1 set define on; SELECT :script_name2 FROM DUAL; @&comp_file2 set define on; SELECT :script_name3 FROM DUAL; @&comp_file3 alter session set current_schema=MDSYS; ------------------------------------------------------------- ----- do any post processing on an existing RDF network ----- -- *) if no network then no post-processing necessary -- -- *) if pre-11.2.0.1.0, then run stacked post-processing -- -- from semu111post -- -- *) if valid 11.2.0.1.0 or later, then run -- -- post-processing from semu112post -- ------------------------------------------------------------- declare network_exists number := 0; rdf_parameter_exists number := 0; valid_112 number := 0; cnt number := 0; begin -- see if RDF Network is present in DB select count(*) into network_exists from all_tables where table_name='RDF_VALUE$' and owner='MDSYS'; if (network_exists > 0) then -- see what type of install we are dealing with -- select count(*) into rdf_parameter_exists from all_objects where owner = 'MDSYS' and object_name = 'RDF_PARAMETER'; if (rdf_parameter_exists > 0) then -- look for a valid 11.2.0.1.0 or later install -- execute immediate 'select count(*) from mdsys.rdf_parameter where namespace = :1 and attribute = :2 and description in (:3, :4)' into valid_112 using 'MDSYS','SEM_VERSION','UPGRADING_VALID','VALID'; if (valid_112 > 0) then :script_name1 := '@semu112post.sql'; else :script_name1 := '@semu111post.sql'; end if; else :script_name1 := '@semu111post.sql'; end if; -- no rdf network -- else :script_name1 := dbms_registry.nothing_script; -- if there is no network, but we're upgrading, we still need -- to update rdfctx operators -- see if we are upgrading execute immediate 'select count(*) from mdsys.rdf_parameter where namespace = :1 and attribute = :2 and description in (:3, :4)' into cnt using 'MDSYS','SEM_VERSION','UPGRADING_VALID','UPGRADING_INVALID'; -- keep going if we are upgrading if (cnt > 0) then -- first see if rdfctx is installed cnt := 0; begin execute immediate 'select count(*) from mdsys.rdf_parameter where namespace = ''COMPONENT'' and attribute = ''RDFCTX''' into cnt; exception when others then null; end; -- if rdfctx is installed then keep going if (cnt > 0) then -- sem_contains operator definitions -- begin execute immediate ' alter operator sem_contains add binding (VARCHAR2, VARCHAR2, VARCHAR2, INTEGER, mdsys.RDF_ALIASES) return NUMBER WITH INDEX CONTEXT, SCAN CONTEXT SemContextIndexMethods COMPUTE ANCILLARY DATA USING mdsys.sem_rdfctx_oper.sem_contains'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: alter sem_contains add binding (VC,VC,VC,INT,RDF_ALIASES): '||SQLERRM); end; begin execute immediate ' alter operator sem_contains add binding (CLOB, VARCHAR2, VARCHAR2, INTEGER, mdsys.RDF_ALIASES) return NUMBER WITH INDEX CONTEXT, SCAN CONTEXT SemContextIndexMethods COMPUTE ANCILLARY DATA USING mdsys.sem_rdfctx_oper.sem_contains'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: alter sem_contains add binding (CL,VC,VC,INT,RDF_ALIASES): '||SQLERRM); end; begin -- sem_contains_select -- -- for sem_contains_select, we only have one binding because bindings are -- keyed by the argument signature. We can't drop the only binding for an -- operator, so we have to (1) add a dummy one, (2) drop the old one, -- (3) add the new one, (4) drop the dummy one execute immediate ' alter operator sem_contains_select add binding (VARCHAR2, VARCHAR2) return NUMBER WITH INDEX CONTEXT, SCAN CONTEXT SemContextIndexMethods COMPUTE ANCILLARY DATA USING mdsys.sem_rdfctx_oper.sem_contains'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: alter sem_contains_select add dummy binding: '||SQLERRM); end; begin execute immediate ' alter operator sem_contains_select drop binding (NUMBER)'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: alter sem_contains_select drop old binding: '||SQLERRM); end; begin execute immediate ' alter operator sem_contains_select add binding (NUMBER) return CLOB ANCILLARY TO mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2), mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2, VARCHAR2), mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2, VARCHAR2, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2, VARCHAR2, INTEGER, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (CLOB, VARCHAR2), mdsys.SEM_CONTAINS (CLOB, VARCHAR2, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (CLOB, VARCHAR2, VARCHAR2), mdsys.SEM_CONTAINS (CLOB, VARCHAR2, VARCHAR2, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (CLOB, VARCHAR2, VARCHAR2, INTEGER, mdsys.RDF_ALIASES) USING mdsys.sem_rdfctx_oper.sem_rdfctx_select'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: alter sem_contains_select add new binding: '||SQLERRM); end; begin execute immediate ' alter operator sem_contains_select drop binding (VARCHAR2, VARCHAR2)'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: alter sem_contains_select drop dummy binding: '||SQLERRM); end; begin -- sem_contains_count ... new operator in 11.2.0.3.0 -- execute immediate ' create or replace operator sem_contains_count binding (NUMBER) return NUMBER ANCILLARY TO mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2), mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2, VARCHAR2), mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2, VARCHAR2, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (VARCHAR2, VARCHAR2, VARCHAR2, INTEGER, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (CLOB, VARCHAR2), mdsys.SEM_CONTAINS (CLOB, VARCHAR2, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (CLOB, VARCHAR2, VARCHAR2), mdsys.SEM_CONTAINS (CLOB, VARCHAR2, VARCHAR2, mdsys.RDF_ALIASES), mdsys.SEM_CONTAINS (CLOB, VARCHAR2, VARCHAR2, INTEGER, mdsys.RDF_ALIASES) USING mdsys.sem_rdfctx_oper.sem_rdfctx_count'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: add sem_contains_count: '||SQLERRM); end; begin execute immediate ' grant execute on sem_contains_count to public'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: grant sem_contains_count: '||SQLERRM); end; begin execute immediate ' create or replace public synonym sem_contains_count for mdsys.sem_contains_count'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: create sem_contains_count synonym: '||SQLERRM); end; begin -- alter indextype to support new bindings -- execute immediate ' alter indextype SemContext add SEM_CONTAINS(VARCHAR2, VARCHAR2, VARCHAR2, INTEGER, mdsys.RDF_ALIASES), add SEM_CONTAINS(CLOB, VARCHAR2, VARCHAR2, INTEGER, mdsys.RDF_ALIASES) using SemContextIndexMethods with local range partition'; exception when others then SYS.DBMS_SYSTEM.KSDWRT(SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semrelod: alter SemContext indextype: '||SQLERRM); end; end if; end if; end if; end; / SELECT :script_name1 FROM DUAL; @&comp_file1 alter session set current_schema=MDSYS; set define on; -- all link$ views and application table triggers need to be recreated -- due to link$ modifications and trigger modifications declare network_exists number; begin -- see if RDF Network is present in DB select count(*) into network_exists from all_tables where table_name='RDF_VALUE$' and owner='MDSYS'; if (network_exists > 0) then begin execute immediate 'begin mdsys.sdo_rdf_internal.recreate_link_views; end;'; exception when others then SYS.DBMS_SYSTEM.KSDWRT( SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semu112post: recreate_link_views: '||SQLERRM); end; begin execute immediate 'begin mdsys.sdo_rdf_internal.recreate_stats_partitions; end;'; exception when others then SYS.DBMS_SYSTEM.KSDWRT( SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semu112post: recreate_stats_partitions: '||SQLERRM); end; begin execute immediate 'begin mdsys.sdo_rdf_internal.recreate_app_triggers; end;'; exception when others then SYS.DBMS_SYSTEM.KSDWRT( SYS.DBMS_SYSTEM.TRACE_FILE, 'SEM_INSTALL: semu112post: recreate_app_triggers: '||SQLERRM); end; end if; end; / ------ set validity of installation ------- @@semvalidate.sql alter session set current_schema=SYS; prompt STEP: set up for export ------------------------------------------------------------------------------ -- prepare for export from 11.2.0.3 ------------------------------------------------------------------------------ prompt STEP: load exp/imp package ------------------------------------------------------------------------------ -- load the package for export/import (must be loaded as SYS to access dbms_zhelp) @@ sdordfeximh.sql @@ sdordfeximb.plb prompt STEP: delete exp/imp related rows -- for idempotence: cleanup at the beginning --------------------------------- delete from SYS.EXPPKGACT$ where package='SDO_RDF_EXP_IMP' and schema='SYS'; delete from SYS.impcalloutreg$ where package='SDO_RDF_EXP_IMP' and schema='SYS' and tag='SEMANTIC'; ------------------------------------------------------------------------------ prompt STEP: insert row for pre-export callout -- arrange for pre-export invocation of MDSYS.SDO_RDF_EXP_IMP.system_callout INSERT INTO SYS.EXPPKGACT$ values ('SDO_RDF_EXP_IMP','SYS',5,0); -- the sem network may not be present, so many of the tables and views absent too -- This is ok because export does not complain if tables/views registered -- in impcalloutreg$ are absent at export time! prompt STEP: create the RDF_PARAMETER related exp/imp objs and register all views -- VIEWs: register to ensure export ------------------------------------------ -- RDF_PARAM$ view: create it, create the _TBL table, then register the view create or replace view MDSYS.RDF_PARAM$ as select * from MDSYS.RDF_PARAMETER; create table MDSYS.RDF_PARAM$_TBL as select * from MDSYS.RDF_PARAM$ where 0=1; truncate table MDSYS.RDF_PARAM$_TBL; insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 0, 'MDSYS', 'RDF_PARAM$', 4 /*view*/, 'semantic technologies: exp/imp registered object'); -- RDF_MODEL$ view insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 0, 'MDSYS', 'RDF_MODEL$', 4 /*view*/, 'semantic technologies: exp/imp registered object'); prompt STEP: register all relevant tables for exp/imp -- TABLEs: register to ensure export ----------------------------------------- -- RDF_GRANT_INFO$: transient table created by system_callout() call during export insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_GRANT_INFO$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_RULEBASE$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_RULEBASE$', 2 /*iot*/, 'semantic technologies: exp/imp registered object'); -- RDF_RULE$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_RULE$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_PRECOMP$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_PRECOMP$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_PRECOMP_DEP$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_PRECOMP_DEP$', 2 /*iot*/, 'semantic technologies: exp/imp registered object'); -- RDF_SYSTEM_EVENT$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_SYSTEM_EVENT$', 2 /*iot*/, 'semantic technologies: exp/imp registered object'); -- RDF_MODEL_INTERNAL$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_MODEL_INTERNAL$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_LINK$: plus INDEXes insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_LINK$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_VALUE$: plus INDEXes insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_VALUE$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- SEM_INDEXTYPE_METADATA$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'SEM_INDEXTYPE_METADATA$', 2 /*iot*/, 'semantic technologies: exp/imp registered object'); -- SEM_SIM_INDEXTYPE_METADATA$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'SEM_SIM_INDEXTYPE_METADATA$', 2 /*iot*/, 'semantic technologies: exp/imp registered object'); -- RDF_TS$: plus INDEXes insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_TS$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_CLIQUE$ (partitioned): plus (?) INDEXes insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_CLIQUE$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_DELTA$ (partitioned): plus (?) INDEXes -- uses ROWIDs (in ROW_ID col) insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_DELTA$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_COLLISION$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_COLLISION$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_HIST$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_HIST$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_NAMESPACE$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_NAMESPACE$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_NODE$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_NODE$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_PATH$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_PATH$', 2 /*table*/, 'semantic technologies: exp/imp registered object'); -- RDF_NETWORK_INDEX_INTERNAL$ insert into sys.impcalloutreg$ (package,schema,tag,class,level#,flags,tgt_schema,tgt_object,tgt_type,cmnt) values ('SDO_RDF_EXP_IMP','SYS', 'SEMANTIC', 3, 1, 4 /*KU$_ICRFLAGS_GET_DEPENDENTS*/, 'MDSYS', 'RDF_NETWORK_INDEX_INTERNAL$', 2 /*table*/, 'semantic technologies: exp/imp registered object');