Re: Export size of whole database

From: Alistair Thomson <thomson_alistair_at_no.spam.yahoo.co.uk>
Date: Wed, 15 Jan 2003 11:23:53 -0000
Message-ID: <b03gc4$106$1$8300dec7@news.demon.co.uk>

It should be okay, as I understand it the .dmp file is compressed as its a binary file.

Alistair

"Slava Pechenin" <s_at_p.na> wrote in message news:1042624961.956356_at_iq...
> There is a question on the way of upgrading from 8.0.4 to 8.1.7 (NT
> platform).
>
> I choose export/import method of migrating existing data. At first I tried
> the simplest method - Migrate Assistent when installing. The result is not
> satisfying: 2 Oracles in 2 homes, some files from here, some from there,
NT
> services from both... It is very confusing!
>
> The question is about export dump size. The document "Oracle8i - Utilities
> Release 8.0 - December 1997- Part No. A58244-01" says the size can be
> predetermined by
>
> select sum(bytes) from user_segments where segment_type='TABLE'
>
> This outputs as "93Mb".
>
> When I ran:
>
> exp80.exe system/manager full=Y file=dba.dmp grants=Y rows=Y
>
> I got the .dmp file of 13Mb.
>
> Is it OK?
>
>
Received on Wed Jan 15 2003 - 05:23:53 CST