Re-enable versioning failed on table with spatial index
430160Mar 24 2005 — edited Mar 29 2005Below is the steps I did and the error I got. If history option "NONE" is used when re-enabling version, it will be OK.
Any idea?
HELP!!!
Thanks,
Sam
create table TEST (id integer primary key, geom mdsys.sdo_geometry);
insert into USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
values ('TEST', 'GEOM', SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', 2180000, 2200000, 0.05), SDO_DIM_ELEMENT('Y',6050000, 6080000, .05)), 40986);
create index TEST_gix on TEST (geom) indextype is mdsys.spatial_index;
exec DBMS_WM.EnableVersioning('TEST', 'VIEW_WO_OVERWRITE');
exec DBMS_WM.DisableVersioning('TEST');
exec DBMS_WM.EnableVersioning('TEST', 'VIEW_WO_OVERWRITE');
BEGIN DBMS_WM.EnableVersioning('TEST', 'VIEW_WO_OVERWRITE');END;
*
ERROR at line 1:
ORA-20229: statement 'DECLARE
err_num integer;
err_msg varchar2(1000);
prfx_len integer;
BE' failed during EnableVersioning. Error:
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-201: identifier 'UNDEFINED' m
ORA-06512: at "SYS.LTDDL", line 457
ORA-06512: at "SYS.LTDDL", line 1046
ORA-06512: at "SYS.LTDDL", line 1030
ORA-06512: at "SYS.LT", line 8948
ORA-06512: at line 1