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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Drop user fails with ORA-01418

RE: Drop user fails with ORA-01418

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Tue, 16 Nov 2004 23:58:00 +0100
Message-Id: <1100645880.7149.8.camel@dbalert199.dbalert.nl>


The flashback thing won't help, recyclebin <> flashback area. Can you undrop the objects, and redrop them after switching of the recycle bin?

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===
On Tue, 2004-11-16 at 22:07, Chadi Kassan wrote:

> Do you think my problem will be resolved by doing this:
> (as sysdba)
> startup mount
> alter database flashback off;
> alter database open;
> shutdown immediate
> startup mount
> alter database flashback on;
> alter database open;
>
> I don't think it has something to do with the flashback things, but i could
> be wrong... it sounds as a recyclebin bugging in 10g or data dictionnary
> corrutpion to me, what do you think ??
>
> Thanks
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 16 2004 - 16:24:23 CST

Original text of this message

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