RE: Drop user fails with ORA-01418
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Nov 2004 23:58:00 +0100
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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
