Skip to Main Content

Oracle Database Express Edition (XE)

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!

Drop Types fails

6944Mar 24 2006 — edited Mar 29 2006
In experimenting with some OR tables I seem to have been left with types that cannot be deleted. Attempting to delete them produces the error from the web interface:
The drop operation was not successful for the following reason:

ORA-01740: missing double quote in identifier

Any ideas?- it dosn't seem to be a dependancy problem as you don't get:

ORA-02303: cannot drop or replace a type with type or table dependents
(I have deleted all tables which made use of these types)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2006
Added on Mar 24 2006
8 comments
502 views