A search with "ORA-01480" turned up this bug report. I avoided Oracle 10.2.0.4
and have moved on to 11g (11.1.0.7), and I haven't seen this problem.
- V
Is your database 10g or 11g, or did you have this problem with both databases?
I rarely use 'sdelayer' to create geometry columns. I wonder if the problem is
more with 'sdelayer' than the underlying SE_layer_create API call.
I'm also wondering if it has to do with the lack of coordinate reference information
(no "-G" and "-x" [or "-R"]). What happens if you define a proper coordref?
The 'sdelayer' command accepts a flag to register the rowid column during
'-o add' -- what happens if you skip the 'sdetable -o alter_reg' and just add
"-C objectid" to 'sdelayer -o add'?
The objectid column is required to be NOT NULL -- what happens if you
define it that way with 'sdetable -o create'?
- V