DROP INDEX
Updated at:
This topic describes the conversion scope of DROP INDEX DDL operations during data migration from an Oracle database to an Oracle tenant of OceanBase Database.
Syntax
DROP INDEX [ schemaName. ] indexName [ ONLINE ] [ FORCE ]
[ { DEFERRED | IMMEDIATE } INVALIDATION ];Supported operations
Dropping an index by using the DROP INDEX [ schemaName. ] indexName statement is supported. An error is returned when other clauses are used. Sample code:
DROP INDEX SC.IDX;Unsupported operations
Operations that use the following options are not supported, and an error will be returned when they are used:
ONLINE
FORCE
DEFERRED
IMMEDIATE
INVALIDATION
Is this page helpful?