Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting large (>8 gig) database in UNIX?
Tim Nimmo wrote:
>
[Comments on why you would want to use export on 'serious' databasen deleted]
>
> So tell me, John. How will you restore that 5 million row table that I
> "accidently" dropped a few minutes ago becuase the developer gave me bad
> instructions? Archivelog doesn't help much unless everything in the
> database can be rolled back to now-10 minutes. Not many active production
> databases allow that. <g>
>
> Tim Nimmo...
Well then - if you drop a production data table by mistake (a several
milion
records table is not likely to be a non-production data table IMHO),
then
how does an export from the night before (up to 24 hours old) help the
situation ? Wouldn't it be likely that constraints etc. would be all
messed
up, or that data would be inconsistent if constraints are not used.
/Jacob
Jacob Steen Due email: jcd_at_ramboll.dk Oracle DBA and application developer web:www.ramboll.dk