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 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 A_INDEX_ROWID "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" A_INDEX_SHAPE "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" A_INDEX_STATEID "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" A_INDEX_USER "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" A_INDEX_XML "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" A_INDEX_RASTER "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" D_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE D_INDEX_STATE_ROWID "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" D_INDEX_DELETED_AT "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" RAS_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE RAS_INDEX_ID "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" BND_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE BND_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" BND_INDEX_ID "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" AUX_STORAGE "PCTFREE 0 INITRANS 4" # TABLESPACE AUX_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 # TABLESPACE NOLOGGING" BLK_STORAGE "PCTFREE 0 INITRANS 4 # TABLESPACE LOB(BLOCK_DATA) STORE AS ( # TABLESPACE ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE) " BLK_INDEX_COMPOSITE "PCTFREE 0 INITRANS 4 # TABLESPACE 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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

タグ付けされた投稿をもっと見る

Accepted answers

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"

All comments

VinceAngelo

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

- 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

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

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

ForrestJones

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.