Re: moving a database from 8.0.5 to 8.1.7

"Christoph Kukulies" <kuku_at_gil.physik.rwth-aachen.de> wrote in message news:9n04kl$5qs$1_at_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?
>

The same thing that gets 'taken' every time you do a 'connect system/manager' in SQL Plus without the tns alias (which is what the '@database' bit is known as)... whatever the ORACLE_SID environment variable is set to (assuming that the tnsnames.ora file correctly identifies such a database, and correctly explains how the hell to connect to it).

Regards
HJR
>
> :>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 - 15:46:42 CDT