Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp and archive available.... recover table
On 11 Jul, 14:59, Alexander Skwar <alexan..._at_skwar.name> wrote:
> > How many MB is your largest database?
>
> 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- Hide quoted text -
>
> - Show quoted text -
I'd be more concerned about restricting your future employment prospects than anything else. How are you going to further your career without learning the new technology?
Also, it's not simply the database recovery itself that a business values, it's also the speed of that recovery. A database that is being rebuilt from an export file is unusable during that process. In some cases, a database that is being properly recovered may still be partially used. Received on Wed Jul 11 2007 - 09:56:37 CDT
![]() |
![]() |