Beyond moving user data into another tablesapace

346
0
08-29-2022 06:10 AM
yockee
by
Occasional Contributor II

Hi,

I have successfully moving one of my feature class into another tablespace. Previously, SDE system tables and user data are in one tablespace. It turns out that Its not just the feature classes that can be moved into another tablespace, but the indexes as well. going further, there are LOB column too.

Questions are :

1. When I move the user data (feature class) to another tablespace, do I have to move the indexes and LOB column ? There are, generally, 3 kinds of indexes : Domain, Normal and LOB indexes. NORMAL index is easy to move, but not for the Domain and Lob indexes. I just want to move them all (all indexes, table, and LOB column)

2. What are the associating DBTUNE keyword for that point number 1 ?

3. Is it safe for the integrity of the database to move all the indexes and the LOB column ?

Oracle 19c, ArcGIS Pro 2.6, SDE 10.9, Geometry storage : ST_GEOMETRY
Thanks. Need your advice.

0 Kudos
0 Replies