Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Purged the recyle bin - now having problems

Re: Purged the recyle bin - now having problems

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 18 Nov 2005 11:29:51 -0800
Message-ID: <1132342188.499903@yasure>


A Rangers Fan wrote:
> Hi guys,
>
> I'd appreciate some feedback on this. I just did a fresh install of
> Oracle 10g. I ran a script multiple times that dropped and recreated
> tables, and then I noticed about 100-200 tables named like
> "BIN$V3zj9aOWRImOT89aKyyVSg\=\=$0".
>
> I did a quick Google search and it seemed to me, that a `purge
> recyclebin;` would remedy the situation. Well, it deleted those tables,
> but now I have problems in the Enterprise Manager App e.g.if I click on
> 'Users' or 'Roles' I get the database error 'ORA-00942: table or view
> does not exist'. This didn't happen before I ran that command.
>
> Can someone tell me what the problem is, and/or how to go about
> remedying it?
>
> Thanks in advance!

Check metalink. It doesn't strike me that the two are related.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Nov 18 2005 - 13:29:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US