I agree ! always do a backup before trying to fix something on your db :)
Whatever you do, you know you're safe.

Greg

Le 17/11/2010 16:18, Norman Dunbar a écrit :

>
> Hi Greg,
>
> > Yes, i know, and i always do such things on a copy (sorry i didn't warn
> > on this point).
> > Now, if your db is broken.... it's broken and loosing few
> information is
> > harmless than loosing everything.
>
> Well, I'm an Oracle DBA by trade and the first rule of hopefully
> recovering from a disaster is "always backup what you have". Based on
> the principle that if you make a mistake when recovering, at least you
> can get back to a "reasonable" starting position and try again.
>
> Without the backup, you could find yourself with no data instead of
> some! Just a thought.
>
> Cheers,
> Norman.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> Thorpe House
> 61 Richardshaw Lane
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7EL
>
> Company Number: 05132767
>
>

[Non-text portions of this message have been removed]