Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Purpose
Use the DROP
TYPE
BODY
statement to drop the body of an object type, varray, or nested table type. When you drop a type body, the object type specification still exists, and you can re-create the type body. Prior to re-creating the body, you can still use the object type, although you cannot call the member functions.
See Also:
DROP TYPE for information on dropping the specification of an object along with the body
CREATE TYPE BODY for more information on type bodies
Prerequisites
The object type body must be in your own schema or you must have the DROP
ANY
TYPE
system privilege.
Syntax
drop_type_body::=
Semantics
schema
Specify the schema containing the object type. If you omit schema
, then Oracle Database assumes the object type is in your own schema.
type_name
Specify the name of the object type body to be dropped.
Restriction on Dropping Type Bodies You can drop a type body only if it has no type or table dependencies.
Example
Dropping an Object Type Body: Example The following statement removes object type body data_typ1
, which was created in "Object Type Examples":
DROP TYPE BODY data_typ1;