Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |