Spatial Indexes shows Tablespace Null ???

User35489 — Mon, 13 May 2013 12:01:50 GMT

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

Re: Spatial Indexes shows Tablespace Null ???

ForrestJones — Tue, 14 May 2013 14:55:30 GMT

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"

Re: Spatial Indexes shows Tablespace Null ???

User35489 — Wed, 15 May 2013 05:43:56 GMT

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

Re: Spatial Indexes shows Tablespace Null ???

VinceAngelo — Wed, 15 May 2013 10:10:45 GMT

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

Re: Spatial Indexes shows Tablespace Null ???

User35489 — Wed, 15 May 2013 10:15:57 GMT

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

Re: Spatial Indexes shows Tablespace Null ???

VinceAngelo — Wed, 15 May 2013 10:31:53 GMT

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

- V

topic Re: Spatial Indexes shows Tablespace Null ??? in Data Management Questions

Spatial Indexes shows Tablespace Null ???

Re: Spatial Indexes shows Tablespace Null ???

Re: Spatial Indexes shows Tablespace Null ???

Re: Spatial Indexes shows Tablespace Null ???

Re: Spatial Indexes shows Tablespace Null ???

Re: Spatial Indexes shows Tablespace Null ???