Dropping a type with force option from the Schema Browser does not work.
Below is an example of the issue:
1) Create two types:
CREATE TYPE A AS OBJECT (A NUMBER);
CREATE TYPE B AS TABLE OF A;
2) In the Schema Browser, try to drop type A. With "Do Not Use Force Option", error "ORA-02303: cannot drop or replace a type with type or table dependents" appears as expected. With "Use Force Option", the same error occurs.
Manually running "DROP TYPE A FORCE;" works without errors.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center