Spatial Indexes shows Tablespace Null ???

User35489

Dear Admins,

I created a DBTUNE file with customized keyword, directing to below given example.

##CART_VECTOR_DEFAULT

GEOMETRY_STORAGE    "ST_GEOMETRY"
ST_GEOM_LOB_STORAGE  " STORE AS (
#                      TABLESPACE <lob segment tablespace_name>
                       ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE) "

ATTRIBUTE_BINARY    "BLOB"
RASTER_STORAGE     "BLOB"
B_STORAGE           "PCTFREE 0 INITRANS 4" TABLESPACE SDE_TS
B_INDEX_ROWID       "PCTFREE 0 INITRANS 4 TABLESPACE  TS_NDX NOLOGGING"
B_INDEX_USER        "PCTFREE 0 INITRANS 4 TABLESPACE  TS_NDX NOLOGGING"
B_INDEX_XML         "PCTFREE 0 INITRANS 4 TABLESPACE  TS_NDX NOLOGGING"
B_INDEX_RASTER      "PCTFREE 0 INITRANS 4 TABLESPACE NOLOGGING"
B_INDEX_TO_DATE     "PCTFREE 0 INITRANS 4 TABLESPACE  TS_NDX NOLOGGING"
B_INDEX_SHAPE       "PCTFREE 0 INITRANS 4 TABLESPACE  TS_NDX NOLOGGING"

S_STORAGE           "PCTFREE 0 INITRANS 4" TABLESPACE TS_SNDX
S_INDEX_ALL         "PCTFREE 0 INITRANS 4 TABLESPACE  TS_SNDX NOLOGGING"
S_INDEX_SP_FID      "PCTFREE 0 INITRANS 4 TABLESPACE  TS_SNDX NOLOGGING"
F_STORAGE           "PCTFREE 0 INITRANS 4 TABLESPACE  SDE_TS
F_INDEX_FID         "PCTFREE 0 INITRANS 4 TABLESPACE   TS_NDX NOLOGGING"
F_INDEX_AREA        "PCTFREE 0 INITRANS 4 TABLESPACE   TS_NDX NOLOGGING"
F_INDEX_LEN         "PCTFREE 0 INITRANS 4 TABLESPACE   TS_NDX NOLOGGING"

A_STORAGE           "PCTFREE 0 INITRANS 4"
#                    TABLESPACE   <Default ADDS table tablespace name>
A_INDEX_ROWID       "PCTFREE 0 INITRANS 4
#                    TABLESPACE   <ADDS Table default index tablespace name>
                     NOLOGGING"
A_INDEX_SHAPE       "PCTFREE 0 INITRANS 4
#                    TABLESPACE   <ADDS Table default index tablespace name>
                     NOLOGGING"
A_INDEX_STATEID     "PCTFREE 0 INITRANS 4
#                    TABLESPACE   <ADDS Table default index tablespace name>
                     NOLOGGING"
A_INDEX_USER        "PCTFREE 0 INITRANS 4
#                    TABLESPACE   <ADDS Table default index tablespace name>
                     NOLOGGING"
A_INDEX_XML         "PCTFREE 0 INITRANS 4
#                    TABLESPACE   <ADDS Table default index tablespace name>
                     NOLOGGING"
A_INDEX_RASTER      "PCTFREE 0 INITRANS 4
#                    TABLESPACE   <ADDS Table default index tablespace name>
                     NOLOGGING"

D_STORAGE           "PCTFREE 0 INITRANS 4"
#                    TABLESPACE <default DELETES Table tablespace name>
D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4
#                    TABLESPACE <DELETES Table default index tablespace name>
                     NOLOGGING"
D_INDEX_DELETED_AT  "PCTFREE 0 INITRANS 4
#                    TABLESPACE <DELETES Table default index tablespace name>
                     NOLOGGING"

RAS_STORAGE         "PCTFREE 0 INITRANS 4"
#                    TABLESPACE <RAS Table tablespace name>
RAS_INDEX_ID        "PCTFREE 0 INITRANS 4
#                    TABLESPACE <RAS Table tablespace name>
                     NOLOGGING"

BND_STORAGE         "PCTFREE 0 INITRANS 4"
#                    TABLESPACE <BND Table tablespace name>
BND_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4
#                    TABLESPACE <BND Table tablespace name>
                     NOLOGGING"
BND_INDEX_ID        "PCTFREE 0 INITRANS 4
#                    TABLESPACE <BND Table tablespace name>
                     NOLOGGING"

AUX_STORAGE         "PCTFREE 0 INITRANS 4"
#                    TABLESPACE <AUX Table tablespace name>
AUX_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4
#                    TABLESPACE <AUX Table tablespace name>
                     NOLOGGING"

BLK_STORAGE         "PCTFREE 0 INITRANS 4
#                    TABLESPACE <BLK Table tablespace name>
                     LOB(BLOCK_DATA) STORE AS (
#                    TABLESPACE <lob segment tablespace_name>
                     ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE) "
BLK_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4
#                    TABLESPACE <BLK Table tablespace name>
                     NOLOGGING"

UI_TEXT             "User Interface text for DEFAULTS"

XML_DOC_UNCOMPRESSED_TYPE   "CLOB"

XML_IDX_TEXT_UPDATE_METHOD "NONE"

XML_DOC_MODE               "COMPRESSED"

XML_DOC_LOB_STORAGE        "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5 DISABLE STORAGE IN ROW" TABLESPACE SDE_XML

XML_DOC_VAL_LOB_STORAGE    "NOCACHE NOLOGGING CHUNK 4K PCTVERSION 5 DISABLE STORAGE IN ROW" TABLESPACE SDE_XML

XML_DOC_STORAGE     "PCTFREE 0 INITRANS 4" TABLESPACE SDE_XML

XML_DOC_INDEX       "PCTFREE 0 INITRANS 4 TABLESPACE SDE_XML NOLOGGING"

XML_IDX_STORAGE     "PCTFREE 0 INITRANS 4" TABLESPACE SDE_XML

XML_IDX_TEXT_TAG_STORAGE   ""

XML_IDX_INDEX_PK    "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING"

XML_IDX_INDEX_ID    "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING"

XML_IDX_INDEX_TEXT  ""

XML_IDX_TEXT_UPDATE_MEMORY ""


XML_IDX_INDEX_TAG   "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING"

XML_IDX_INDEX_DOUBLE "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING"
                     
XML_IDX_INDEX_STRING "PCTFREE 0 INITRANS 4 TABLESPACE XML_NDX NOLOGGING"                  

XML_COLUMN_STORAGE    "SDE_XML"
# Example for setting XML_COLUMN_STORAGE to native XML type.
#XML_COLUMN_STORAGE    "DB_XML"
#XMLDB_INDEX_TAG       "YES"
#XMLDB_INDEX_FULLTEXT  "NO"
END


But for my surprise i view the information about the Spatial Index for a layer is created in TableSpace = Null
What could be the reason ?

Please input your valuable comments

My Environment: RHEL 6, Oracle 11.2.0.3.0, ArcSDE 10.1 SP1

With best regards

Thanks
Abdullah

ForrestJones

Hi Abdullah,

Is the correct value in the sde.dbtune table? The tablespace info might not be there. The end quote might be in the wrong place:

S_STORAGE "PCTFREE 0 INITRANS 4" TABLESPACE TS_SNDX

should maybe be:

S_STORAGE "PCTFREE 0 INITRANS 4 TABLESPACE TS_SNDX"