SQL> create or replace type t_dropme as  object (x number,y number, member procedure clear);
  2  /

Type created.

SQL> create or replace type body t_dropme as
member procedure clear
as
begin
x:=0;y:=0;
end;
end;
SQL> /

Type body created.

SQL> alter type t_dropme compile debug;

Type altered.

SQL> alter type t_dropme compile body debug;

Type body altered.

SQL> create table dropme ( id number, cor t_dropme);

Table created.

SQL> alter type t_dropme compile debug;
alter type t_dropme compile debug
*
ERROR at line 1:
ORA-02311: cannot alter with COMPILE option a valid type with type or table
dependents


SQL> alter type t_dropme compile body;

Type body altered.