Re: Export size of whole database

Hello Slava,
An Oracle db has lots of free (spare) space in it - check your PCTFREE setting on tables which can be up to 40%. So the sum(bytes) from user_segments includes this free space + lots of space which isn't allocated yet : If your next extent size is 50Mb then the moment a table allocates an extent it grabs the 50Mb but puts only 1 row into it !

Your full export .dmp file of 13Mb will be quite correct.

If u copy it with ftp do it BINARY - an ASCII will ruin it ! Cheers,

     Roelof Schierbeek

R.Schierbeek, DBA
sql : www.bytelife.com/sql4dba.htm

• Original Message ----- From: Slava Pechenin <s_at_p.na> Newsgroups: comp.databases.oracle.server Sent: Wednesday, January 15, 2003 11:02 AM Subject: Export size of whole database

> 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 - 13:11:14 CST