Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Re-enable versioning failed on table with spatial index

430160Mar 24 2005 — edited Mar 29 2005
Below 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2005
Added on Mar 24 2005
4 comments
2,388 views