Getting ORA-30373 when using DBMS_REPCAT_RGT.INSTANTIATE_OFFLINE or DBMS_REPCAT_RGT.INSTANTIATE_ONLINE (Doc ID 1067783.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.5 to 11.2.0.2.0 - Release: 10.1 to 11.2
Information in this document applies to any platform.

Symptoms

When running the following we get the error detailed:

SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 dt_num NUMBER;
3 BEGIN
4 dt_num := DBMS_REPCAT_RGT.INSTANTIATE_OFFLINE(
5 refresh_template_name => 'DT_SHAPE',
6 user_name => 'RK_MVIEW',
7 site_name => 'rkdb2.world',
8 next_date => sysdate,
9 interval => 'sysdate + (1/144)');
10 DBMS_OUTPUT.PUT_LINE('Template ID = ' || dt_num);
11 END;
12 /
DECLARE
*
ERROR at line 1:
ORA-30373: object data types are not supported in this context
ORA-06512: at "SYS.DBMS_REPCAT_RGT_CUST", line 1991
ORA-06512: at "SYS.DBMS_REPCAT_RGT", line 1330
ORA-06512: at line 4





Changes

We have the following objects setup:

create user rk_mview identified by <pword> default tablespace users;
grant dba to rk_mview;

connect rk_mview/pword

create table jtx_jobs_aoi
(objectid number(38), job_id number(10),shape mdsys.sdo_geometry, se_anno_cad_data blob);

alter table jtx_jobs_aoi add constraint jtx_pk primary key (objectid);

connect sys/oracle@11GRKDB1 as sysdba

create user REPADMIN identified by REPADMIN default tablespace users;
grant dba to repadmin;

begin
dbms_repcat_admin.grant_admin_any_schema(username => 'REPADMIN');
end;
/

begin
dbms_defer_sys.register_propagator(username => 'REPADMIN');
end;
/
grant execute any procedure to REPADMIN;







Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms