Create index parallel nologging

alter table t1 nologging;
alter table t2 nologging;

create index T1_IDX on T1 (Field1, Field2, Field3, Field4) parallel 2 nologging;
create index T2_IDX on T2 (Field1, Field2, Field3, Field4) parallel 2 nologging;

parallel 2 for 2 CPUs.

Rebuild Spatial Index

When I excute "truncate table ..." or "delete from ...", sometimes I encounter ORA-29859 or ORA-29861 error. In most cases, I just rebuild the spatial index on the geometry column and the problem will be fixed.

DROP INDEX GEO_PS_POSITION_SX;
CREATE INDEX GEO_PS_POSITION_SX ON GEO_PS_POSITION (ROUTE) INDEXTYPE IS MDSYS.SPATIAL_INDEX;