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: Undo after drop table...

Re: Undo after drop table...

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 25 Nov 2005 06:09:03 -0800
Message-ID: <J7KdnQzr5ZQHhxreRVn-hw@comcast.com>

"cartoedm" <cartographie_at_electricitedemayotte.com> wrote in message news:1132923121.694947.203490_at_g49g2000cwa.googlegroups.com...
> I don't have any backup.... that's my BIG problem !
>

Don't do anything more to the db. You can call Oracle and request that they send someone out who will unload the db and load it again. The data is there (as long as you don't do any more database operations) The Oracle unload/ load option will run you about $10,000 plus travel etc. They will send someone out.

You have to ask yourself why you don't have a backup. If the data is important then it should be backed up periodically.(and the db should be in archive log mode)
Jim Received on Fri Nov 25 2005 - 08:09:03 CST

Original text of this message

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