When attempting to import an SDE export file using the 'sdeimport -o append' or 'sdeimport -o init' commands, you may receive the following error message:
Export file and layer attribute schemas are not compatible.
The spatial column is the last column in both the export file and the SDE layer business table. This is a known limit for SDE 3.x.
Solution or Workaround
Arrange the columns in the SDE layer business table in such a way that the spatial column is not last in the table.
A. Use 'sdeexport' to export the original SDE layer to a new SDE export file. If problems occur with this procedure, the original SDE layer is preserved in the export file.
B. To use the same layer name, use 'sdetable -o delete' to remove all the tables associated with the original SDE layer from the database.
C. Use 'sdetable -o create' to create a new SDE table. Be sure to use the '-d' option to specify the column definitions. Make sure the spatial column is not last.
D. Use 'sdelayer -o add' to spatially enable the table.
E. Use 'sdeimport -o init' to import the previously exported file into the new layer.
SDE doesn't care if the columns in the export file and the SDE layer are not in exactly the same order. SDE is only concerned with having matching column names.