| SE_table_migrate_attribute_binary | |
Migrates LONG RAW attribute columns in a table to BLOB (Oracle databases only)
SE_table_migrate_attribute_binary (SE_CONNECTION handle, const ACHAR *table_name, const ACHAR *column_name, const ACHAR *keyword);
| connection | The connection handle |
| table_name | The name of the table containing the LONG RAW column to be migrated |
| column_name | The name of the LONG RAW attribute column to be migrated to BLOB |
| config_keyword | The DBTUNE configuration keyword specifying the ATTRIBUTE_BINARY BLOB storage, plus storage clauses for the BLOB data such as tablespaces |
SE_table_migrate_attribute_binary changes the data type of a column from LONG RAW storage to BLOB based on the configuration keyword specified. Applies to tables in Oracle databases only.
SE_SUCCESS
SE_ATTR_NOEXIST
SE_DB_IO_ERROR
SE_DBMS_DOES_NOT_SUPPORT
SE_INVALID_COLUMN_TYPE
SE_INVALID_LAYER_NAME
SE_INVALID_PARAM_VALUE
SE_INVALID_POINTER
SE_INVALID_RELEASE
SE_LOCK_CONFLICT
SE_NET_FAILURE
SE_NO_ACCESS
SE_NO_PERMISSIONS
SE_NO_ROWID_COLUMN
SE_NOT_TABLE_OWNER
SE_OUT_OF_LOCKS
SE_TABLE_NOEXIST
SE_TABLE_SCHEMA_IS_LOCKED
SE_TEMP_IO_ERROR
∙ It is strongly recommended to create a backup of data before migration. For example, this could be in the form of an sdeexport file.
∙ If the table was registered as versioned, migrating the LONG RAW column to a BLOB data type will also update the column in the Adds table. If the table has archiving enabled, the archive table’s LONG RAW column will also be updated.
∙ Storage migration can only be done by the user who owns the table.