Select to view content in your preferred language

How to change order fields display in a feature class

2084
1
08-20-2010 03:27 PM
JoseSanchez
Frequent Contributor
Hi all

In SDE Oracle, is thre a way to change the order fields of the fields in a feature class.

I know that in personal geodatabase I just open Ms Access and change the order and it works
0 Kudos
1 Reply
RashanWalker
Esri Contributor
Currently in an Oracle database you can't change the order of fields in a feature class.

The feature class can be re-created with the fields in the correct order.  The "Load Object" command can then be used to populate the feature class.

Loading data with the Load Objects command
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Loading_data_with_the_Load_Objects_com...

Steps:

1.  Create a new feature class with the column in the correct order
2.  Load the data from the old feature class into the new feature class using the �??Load Objects�?� command
3.  Fields can be matched using the �??Matching Source Field�?� drop down box

*** Important Note for �??Versioned Feature Classes�?� ***
If you are loading into a versioned ArcSDE feature class with ArcMap, the data loads into the delta tables, not the base tables. After you have finished loading into any feature class or table registered as versioned without the option to move edits to the base table, compress your database to push all the records from the delta tables to the base tables. Having your data in the base tables results in faster queries than if you have large amounts of data in your delta tables..
0 Kudos