Re: Oracle Export Error !

From: dias <ydias_at_hotmail.com>
Date: 21 Nov 2001 07:23:57 -0800
Message-ID: <55a68b47.0111210723.5c40af68@posting.google.com>

"henry Lau" <henryl_at_oms.com.hk> wrote in message news:<9tf6rp$99k$1_at_hfc.pacific.net.hk>...
> Hi,
>
> When i type the export command to export the database to a dump file, it
> shows the following error ! Please help !!
>
> Henry Lau
>
>
>
> "Z:\>exp
>
> Export: Release 8.1.7.0.0 - Production on Wed Nov 21 11:06:38 2001
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
> Username: system
> Password:
>
> EXP-00056: ORACLE error 12560 encountered
> ORA-12560: TNS:protocol adapter error
> EXP-00000: Export terminated unsuccessfully"

Hi,
try
z:\set ORACLE_SID=YOUR_SID
before the exp command.

The error could mean that you cannot connect to the database. You have to verify that:
-the database is open
-you can connect via sqlplus

Dias Received on Wed Nov 21 2001 - 09:23:57 CST