Oracle SDO_RDF_EXP_IMP
Version 21c

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 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
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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
SDO_RDF_MIG
SDO_RDF_REL2RDF_INTERNAL
SDO_RDF_SYS
SEM_RDFCTX_DR
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx