Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: moving a database from 8.0.5 to 8.1.7

Re: moving a database from 8.0.5 to 8.1.7

From: Christoph Kukulies <kuku_at_gil.physik.rwth-aachen.de>
Date: 3 Sep 2001 14:38:13 GMT
Message-ID: <9n04kl$5qs$1@nets3.rz.RWTH-Aachen.DE>


Bruno Jargot <see_at_reply.to.invalid> wrote: : 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

I found that I got to do

exp80 sys/<passwd>@database file=x log=y full=y

to address the database/instance I want to export.

What would be taken if I omit @database?

:>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 ...

-- 
Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de
Received on Mon Sep 03 2001 - 09:38:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US