SDO_GEOMETRY - DBTUNE

LaureanoRapoport — Fri, 29 Jul 2011 07:33:36 GMT

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

Re: SDO_GEOMETRY - DBTUNE

PaulDziemiela — Fri, 29 Jul 2011 13:36:01 GMT

Hi Laureano,

Try the following noting the equals sign.

SDO_INDEX_SHAPE "TABLESPACE = SDE_INDEX"

See
http://webhelp.esri.com/arcgisserver/9.3.1/java/index.htm#geodatabases/about_o-659090405.htm

Cheers,
Paul

topic Re: SDO_GEOMETRY - DBTUNE in Data Management Questions

SDO_GEOMETRY - DBTUNE

Re: SDO_GEOMETRY - DBTUNE