Hi,
I tried to create a layer with SDO_GEOMETRY storage format. I want to save de layer in a tablespace named SDE_DADES and the index data in tablespace SDE_INDEX.
I can create the layer, but I have a problem with the index.
I have defined the SDO_GEOMETRY in dbtune whit the next parameters:
##SDO_GEOMETRY
ATTRIBUTE_BINARY "BLOB"
COMMENT "Any general comment for SDO_GEOMETRY keyword"
GEOMETRY_STORAGE "SDO_GEOMETRY"
RASTER_STORAGE "BLOB"
RDT_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 NOLOGGING "
RDT_STORAGE "PCTFREE 0 INITRANS 4"
S_INDEX_ALL "PCTFREE 10 INITRANS 4 TABLESPACE SDE_INDEX STORAGE (FREELISTS 4 MINEXTENTS 1 PCTINCREASE 0)"
S_STORAGE "PCTFREE 10 PCTUSED 90 INITRANS 4 TABLESPACE SDE_INDEX STORAGE (FREELISTS 4 PCTINCREASE 0)"
SDO_INDEX_SHAPE "TABLESPACE SDE_INDEX"
B_INDEX_USER "TABLESPACE SDE_INDEX PCTFREE 0 INITRANS 4 NOLOGGING"
F_INDEX_FID "PCTFREE 10 INITRANS 4 TABLESPACE SDE_DADES STORAGE (FREELISTS 4 MINEXTENTS 1 PCTINCREASE 0)"
F_INDEX_LEN "PCTFREE 10 INITRANS 4 TABLESPACE SDE_DADES STORAGE (FREELISTS 4 MINEXTENTS 1 PCTINCREASE 0)"
F_STORAGE "PCTFREE 10 PCTUSED 90 INITRANS 4 TABLESPACE SDE_INDEX STORAGE (FREELISTS 4 PCTINCREASE 0)"
B_STORAGE "PCTFREE 10 PCTUSED 90 INITRANS 4 TABLESPACE SDE_DADES STORAGE (FREELISTS 4 PCTINCREASE 0)"
F_INDEX_AREA "PCTFREE 10 INITRANS 4 TABLESPACE SDE_DADES STORAGE (FREELISTS 4 MINEXTENTS 1 PCTINCREASE 0)"
SDO_COMMIT_INTERVAL 1000
UI_TEXT "User Interface text description for SDO_GEOMETRY"
END
And when I look the SQL of the layer in SQLDEVELOPER, I can see that the index is:
CREATE INDEX "SDE"."A801_IX1" ON "SDE"."ABOCADOR" ("SHAPE")
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARAMETERS ('SDO_COMMIT_INTERVAL = 1000, TABLESPACE SDE_INDEX');
And this is wrong. I need that when i create the layer, the index will be created by this script (with out comma😞
CREATE INDEX "SDE"."A801_IX1" ON "SDE"."ABOCADOR" ("SHAPE")
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" PARAMETERS ('SDO_COMMIT_INTERVAL = 1000 TABLESPACE SDE_INDEX');
May I change any parameter in specified for SDO_GEOMETRY?
Can anybody helpme?
Thank's a lot,
Laureano