English

Problem: Sdetable -o create_view generates a view that is not spatially enabled

Description

The command 'sdetable -o create_view' runs successfully but returns a view that is not spatially enabled.

Cause

There is a space between the column names of the -c parameter.

Solution or Workaround

  • Remove the blanks around the column/table names in the -c parameter:

    Code:
    sdetable -o create_view -T <view_name> -t <table1,table2...tablen>
    -c <table_col1,table_col2...table_coln>
    [-a <view_col1,view_col2...view_coln>] [-w <"where_claus
    [-i <service>] [-s <server_name>] [-D <database>]
    -u <DB_User_name> [-p <DB_User_password>] [-N] [-q]

  • Upgrade to ArcSDE 8.1.2.