Re: exp and archive available.... recover table

DA Morgan <damorgan_at_psoug.org> wrote:

> Alexander Skwar wrote:

>> DA Morgan <damorgan_at_psoug.org> wrote:
>> 
>>> Let me prove it to you. You come to my lab and I'll set you up on a
>>> server. You use export or datapump to do whatever it is you think it
>>> is doing. I'll send you out of the room for five minutes and use vi
>>> to do a bit of damage. What are you willing to bet that you will be
>>> able to "restore and recover" with your export?
>> 
>> I don't understand. In the case of a "disaster", I'd create a new
>> database and IMPort all the data that is in the EXP dump file.
>> 
>> Alexander Skwar

It's tiny. Right now, a mere 17GB.

> The reason I ask is that most
> Oracle production databases these days are in the TB range. Have you
> ever exported even 1TB?

No.

> How long did it take to import it? And you propose to do this one a
> day for years? It can not be done.

With 17 GB and a 629M EXP - why not?

> And which part of this text did you miss?
>
> Restrictions
>
> * The following system schemas are not exported as part of a Full
> export because the metadata they contain is exported as part of other
> objects in the dump file set: SYS, ORDSYS, EXFSYS, MDSYS, DMSYS, CTXSYS,
> ORDPLUGINS, LBACSYS, XDB, SI_INFORMTN_SCHEMA, DIP, DBSNMP, and WMSYS.
> * Grants on objects owned by the SYS schema are never exported.

Doesn't matter for me.

Alexander Skwar Received on Wed Jul 11 2007 - 08:59:42 CDT