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 · Accepted solution]

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"

[User35489]

Hi FOJO,

Thanks for your input,
I tried making changes you highlighted. Still the index created goes in "So called 'Null' as viewed by SQL Developer" Tablespace

Any more ideas ? Dudes . .

-AS

[VinceAngelo]

Did you just change it in the file, or did you change it in the file then use
'sdedbtune' to update it in the SDE.DBTUNE table?

Please mark FJ's answer as the solution.

- V

[User35489]

Did you just change it in the file, or did you change it in the file then use
'sdedbtune' to update it in the SDE.DBTUNE table?

Please mark FJ's answer as the solution.

- V

Hi Angelo,

I exported dbtune, made changes and imported it back..
I think the issue is with SQL Developer, when i view the details for tables, it shows null in Tablespace. But just now when i viewd properties by selecting EDIT it showed me the correct tablespace.

Any ways the answer given be FOJO helped me to correct the mistake of quote placement.

Thanks FOJO, Vince

Regards

[VinceAngelo]

Welcome to the wonderful world of ACID.  You need to refresh open cursors
to see changed database contents.

- V