Re: Change oracle_sid in 9i ?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 21 Feb 2003 22:37:30 +0100
Message-ID: <dv6d5v4pf1alm3iic23nenl2idv7v2qpjm@4ax.com>

On 21 Feb 2003 13:03:37 -0800, nguyend4_at_hotmail.com (David Nguyen) wrote:

>Hi all,
>
> I created a second database in Oracle 9i windows 2000 (in the same
>box). Now I try to run EXP/IMP and it keep EXP/IMP the data from my
>second database. How can I switching back to EXP/IMP of my first
>database.
>
>Panic ! please help
>
>David
>
>I'm appreciated if someone send a reply back to my email:
>nguyend4_at_hotmail.com

set oracle_sid=<first sid>
exp <username/password>

or of course
exp <username/password>@<tnsservice name>

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Feb 21 2003 - 15:37:30 CST