1 2 3 4 5 6 7 8 9 10 11 12
| BEGIN
declare schema_name varchar2(200); username varchar2(64); begin
select sys_context('userenv', 'CURRENT_SCHEMA') into schema_name from dual;
select user into username from dual;
if username != schema_name then mdsys.sdo_meta.change_all_sdo_geom_metadata(schema_name, 'FORUM_EMPLOI','GEOMETRY',mdsys.SDO_dim_array(MDSYS.SDO_DIM_ELEMENT('','640000','680000','.005'),MDSYS.SDO_DIM_ELEMENT('','6835000','6870000','.005')),'2154') ; else delete from user_sdo_geom_metadata where table_name= 'FORUM_EMPLOI' and column_name= 'GEOMETRY';INSERT INTO USER_SDO_GEOM_METADATA values ('FORUM_EMPLOI','GEOMETRY',mdsys.SDO_dim_array(MDSYS.SDO_DIM_ELEMENT('','640000','680000','.005'),MDSYS.SDO_DIM_ELEMENT('','6835000','6870000','.005')),'2154') ; end if; end;
COMMIT;
END;
/
CREATE INDEX "ECONOMIE"."Q_FORUM_EMPLOI" ON "ECONOMIE"."FORUM_EMPLOI" ("GEOMETRY")
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARAMETERS ('tablespace=ECONOMIE_INDX')PARALLEL 1 ;
ALTER INDEX "ECONOMIE"."Q_FORUM_EMPLOI" NOPARALLEL; |
Partager