|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
DROP SEQUENCE to UPDATE, 7 of 27
TYPE statement to drop the specification and body of an object, a varray, or nested table type.
The object, varray, or nested table type must be in your own schema or you must have the
TYPE system privilege.
Specify the schema containing the type. If you omit
schema, Oracle assumes the type is in your own schema.
Specify the name of the object, varray, or nested table type to be dropped. You can drop only types with no type or table dependencies.
type_name is a statistics type, this statement will fail unless you also specify
FORCE. If you specify
FORCE, Oracle first disassociates all objects that are associated with
type_name, and then drops
type_name is an object type that has been associated with a statistics type, Oracle first attempts to disassociate
type_name from the statistics type and then drop
type_name. However, if statistics have been collected using the statistics type, Oracle will be unable to disassociate
type_name from the statistics type, and this statement will fail.
type_name is an implementation type for an indextype, the indextype will be marked
Unless you specify
FORCE, you can drop only object, nested table, or varray types that are standalone schema objects with no dependencies. This is the default behavior.
See Also: CREATE INDEXTYPE
FORCE to drop the type even if it has dependent database objects. Oracle marks
UNUSED all columns dependent on the type to be dropped, and those columns become inaccessible.
Caution: Oracle does not recommend that you specify
The following statement removes object type