Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Object refuses to drop
"Tanel Poder" <change_to_my_first_name_at_integrid.info> wrote in message
news:3f3aaa77$1_1_at_news.estpak.ee...
> > > How the heck can I get rid of this object... go into sys.obj$ and
delete
> it
> > > manually?
>
> What is your current_schema? (talking about alter session set
current_schema
> = xxx)
> Try drop type project.attribute_typ; instead.
Current schema is project, user is project. I've tried qualifiying the identifier every which way... same result.
> > Anyone that would even suggest going into sys.<anything> and making a
> change
> > should
> > have their keyboard taken away. I am staggered by the implications.
>
> This is way too hard punishment to a computer geek (well, not for Windows
> dumbuser, they'll be doing everything with mouse anyway... ;)
I've got an unopened copy of Dragon Dictate somewhere... looks like I may be forced to install it... lol. Received on Wed Aug 13 2003 - 16:43:53 CDT