Re: moving a database from 8.0.5 to 8.1.7

On 30 Aug 2001 16:43:53 GMT, Christoph Kukulies wrote:

>Galen Boyer <galenboyer_at_hotpop.com> wrote:
>: On Thu, 30 Aug 2001, postbus_at_sybrandb.demon.nl wrote:
>
>: Chris,
>
>: I think I would use exp/imp for this, but you might have really
>
>
>When using at the command line:
>
>exp80 system/manager file=x log=x full=y
>
>it seems to me that the dump is finished surprisingly quick.
>
>I have serveral SIDs running. I cannot image that that could have been all.
>
>It's just 8 MB and that's it.
>Looking into \orant\databases I see
>SYS1ORC0.ORA 80 MB
>SYS1ORC1.ORA 80 MB
>SYS1ORC2.ORA 114 MB
>
>TMP1...
>
>USR1..
>
>lots lots more

The dump file contains only the user data. It doesn't contain the rollback segment, the dictionnary, the indexes, the temp (only the sql commands for create them)

The size of the datafiles doesn't necessairly reflect the real size of the data. The datafiles can be empty, the allocated space for segments can be empty too. I've seen (every days in fact ...) a database which have 4 GB of datafiles but only 300MB of real data.

If you don"t have any error in the log file of the export then your database is full of void ... Received on Thu Aug 30 2001 - 14:22:22 CDT