Oracle | SDO_RDF_EXP

Oracle SDO_RDF_EXP_IMP Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Spatial Resource Description Framework export and import utilities

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_SYSTEM	S_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 sdo_rdf_exp_imp.system_callout( prepost IN PLS_INTEGER, version IN VARCHAR2);

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

      

      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.