Re: moving a database from 8.0.5 to 8.1.7

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 13 Sep 2001 06:33:16 +1000
Message-ID: <3b9fc5b1@news.iprimus.com.au>

"Christoph Kukulies" <kuku_at_gil.physik.rwth-aachen.de> wrote in message news:9nklir$m7h$1_at_nets3.rz.RWTH-Aachen.DE...
> Howard J. Rogers <howardjr_at_www.com> wrote:
> : "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).

>

> Thanks to all who helped so great.

>

> While being at this 'tns alias': How would the syntax be
> when there is no alias defined? E.g. I know the host and the ORACLE_SID
> the database is running on. Often there is not yet an entry in
tnsnames.ora
> or the file was edited by hand and there is an error in tnsnames.ora.

>

> Then it could be useful to know how to get to the database without all the
> Oracle naming and aliasing stuff inbetween.

>

> something like user/password_at_TNS:<someting> I seem to recall.
>
>

I think you are thinking of the host:port:sid connector.

Dodgy.

Do the deed properly.

Regards
HJR
> : Regards
> : HJR

>

> --
> Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de
Received on Wed Sep 12 2001 - 15:33:16 CDT