Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Daniel Morgan <damorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Export Problem
Date: Wed, 05 Jun 2002 22:06:40 -0700
Organization: EXE
Message-ID: <3CFEEDE0.E079248@exesolutions.com>
X-Mailer: Mozilla 4.7 [en] (X11; I; SunOS 5.8 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
References: <96eccafc.0206051019.232a3417@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@splish28.drizzle.com
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: newsabuse@supernews.com
Lines: 46
Xref: easynews comp.databases.oracle.server:149694
X-Received-Date: Wed, 05 Jun 2002 22:02:56 MST (news.easynews.com)

Pinaki wrote:

> Hi,
>     Connecting to export is creating a problem.I am using the Oracle
> Export tool.But after I enter the username/password@hoststring
> (SCOTT/TIGER@HOSTSTRING for example) it says "NO
> LISTENER,ORA-12154"...But I am able to connect to the database from
> SQL PLUS using the same set of username/password@hoststring...
> It would be really helpful if anybody could clarify where the problem
> could be...
>
> Thanks,
> Pinaki

Check the syntax of EMP. I have used it many times but have never once
logged on as you are attempting to do.

From my experience the usage is:

EXP                   USERID=system/manager
                         BUFFER=
                         FILE=dba.dmp
                         GRANTS=Y    -- default
                         INDEXES=Y    -- default
                         ROWS=        -- default
                         CONSTRAINTS=Y    -- default
                         COMPRESS=Y    -- default
                         FULL=N        -- default
                         OWNER=(x,y,z)    -- comma delimited list
                         TABLES=(a,b,c)    -- comma delimited list
                         RECORDLENGTH    -- only used when moving
between operating systems
                         INCTYPE=    -- valid values are COMPLETE,
CUMULATIVE, & INCREMENTAL
                                 -- default is none
                         HELP        -- displays help info
                         PARFILE=    -- parameter file containing these
items
                         LOG=log.log    -- default is NONE
                         CONSISTENT=N    -- default
                         STATISTICS=    -- valid values are ESTIMATE,
COMPUTE, & NONE
                                 -- default is NONE

Daniel Morgan