Is This Content Helpful?
We're glad to know this article was helpful.
Adding an SDO_GEOMETRY spatial column to a business table with the command 'sdelayer –o add' results in the following error:
"ORA-01758: table must be empty to add mandatory (NOT NULL) column"
The business table must not contain rows prior to the operation. If the table already contains rows, the operation fails. This is a known issue.
There are two options for the addition of an SDO_GEOMETRY column in this case.