Oracle | SDO_RDF_EXP

Oracle SDO_RDF_EXP_IMP Version 21c

General Information

Library Note

Morgan's Library Page Header

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 Undocumented

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_SYSTEM	SDO_RDF_INTERNAL
DBMS_STANDARD	DBMS_UTILITY	V_$OPTION

Documented No

First Available 12.2

Security Model Owned by SYS with

Source {ORACLE_HOME}/md/admin/sdordfeximh.sql

Subprograms

INSTANCE_CALLOUT_IMP	SYSTEM_CALLOUT	SYSTEM_CALLOUT_IMP
INSTANCE_EXPORT_ACTION

INSTANCE_CALLOUT_IMP

Called for each registered instance during import sdo_rdf_exp_imp.instance_callout_imp( obj_name IN VARCHAR2, obj_schema IN VARCHAR2, obj_type IN NUMBER, prepost IN PLS_INTEGER, action OUT VARCHAR2, alt_name OUT VARCHAR2

conn sys@pdbdev as sysdba

      

      CREATE TABLE test (

      testcol DATE);

      

      SELECT type#

      FROM obj$

      WHERE name = 'TEST';

      

      DECLARE

       actout v$session.action%TYPE;

       altout obj$.name%TYPE;

      BEGIN

        sdo_rdf_exp_imp.instance_callout_imp('TEST', 'SYS', 2, 1, actout, altout);

         dbms_output.put_line('Action: ' || actout);

         dbms_output.put_line('Alt Name: ' || altout);

      END;

      /

      Action:

      Alt Name:

      

      PL/SQL procedure successfully completed.

INSTANCE_EXPORT_ACTION

Called for each registered instance during export. Return action='EXPORT' for 12.1 target Need to skip or return pre-created Views for older targets for downgrade to work properly sdo_rdf_exp_imp.instance_export_action( obj_name IN VARCHAR2, obj_schema IN VARCHAR2, obj_type IN NUMBER, tgt_version IN VARCHAR2, action OUT VARCHAR2, alt_name OUT VARCHAR2, where_clause OUT VARCHAR2);

TBD

SYSTEM_CALLOUT

Undocumented

~20 second run time sdo_rdf_exp_imp.system_callout( prepost IN PLS_INTEGER, version IN VARCHAR2);

exec sdo_rdf_exp_imp.system_callout(1, '21.1');

      

      PL/SQL procedure successfully completed.

SYSTEM_CALLOUT_IMP

Fix up processing when prepost=1 sdo_rdf_exp_imp.system_callout_imp(prepost IN PLS_INTEGER);

exec sdo_rdf_exp_imp.system_callout_imp(1);

      

      PL/SQL procedure successfully completed.