Toad World® Forums

Request for generating drop force clause on types ddl


#1

Hi!

To avoid the error
ORA-02303 cannot drop or replace a type with type or table dependents
please add a preference and the logic the generate following ddl fragment:

DROP TYPE ty_test FORCE
/

CREATE OR REPLACE
TYPE ty_test IS OBJECT


#2

Hi Torsten,

Enhancement request has been raised.

Gwen


#3

Why is this an enhancement request as this has worked in previous version?


#4

Hi Torsten,

Apologise if I misunderstood the request. There’s an preference in Extract DDL to Include Drop clause but it doesn’t include Force keyword. If it works in a previous version, please provide the detailed steps. Thanks.

Gwen


#5

Sorry for my last update this was related to the wrong thread.
Another problem with the drop preference is that I need this only for types with depandent objects. I this case replace does not work.
In most other programs like packages or procedures the replace keyword does the job.
For views the force option is included as part of the create or replace.
So what I need is separate hierrachical type specific preferences
"include drop for type
“include force option”


#6

I will include the above information in the CR.

Gwen


#7

Not in 6.3.0.1824.


#8

Not in 6.4.0.1901.


#9

Preference is in 6.5.0.2032 and extract works correct.

But the prefernece is located under and dependend from include drop.

In fact we don’t want create drop clause for any of the other object types, as there are replace options or similar constructs.
If we drop e.g. packages then we loose grants, which are defined before.

So maybe you can move the preference to type specific subtree and duplicate include drop there too for only types?


#10

Hi Torste,

We will move the Force Drop Type out and it will be independent of the Root Drop node as per requested. We will get it in the next beta drop.

Thanks and regards,
Bruce


#11

Is fixed in 6.5.0.2071.