Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

force drop of object-type in a create statement

657907Oct 23 2008 — edited Oct 23 2008
Hello Everyone



We are about to upgrade our clients database with some ddl-scripts and in order not to worry about what object-types (nested tables) are new and which ones are old (where a drop is needed) I am looking for a way to do it all in one



CREATE OR REPLACE FORCE <type> AS OBJECT ( ... );



Anyhow, when a collection-type for this objects exists I am getting <em>ORA-02303: cannot drop or replace a type with type or table dependents</em>


I thought the FORCE option will just drop type and recreate it? I dont want to drop anything manually. The collection-type will be updated later with another script.



Thanks in advance
This post has been answered by Satyaki_De on Oct 23 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 20 2008
Added on Oct 23 2008
#sql
3 comments
708 views