Re: IMP-00058: ORACLE error 1017 encountered (invalid username/password)

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 29 Jan 2008 19:51:32 +0100
Message-ID: <9f5e6$479f75b4$524b5c40$25215@cache6.tilbu1.nb.home.nl>


davide.cosentino_at_gmail.com wrote:
> hi,
> I am using Oracle for the 1st time.

Wouldn't you rather get a professional?

[snip]

>

>> export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/Db_4
>> export ORACLE_SID=PRODUCT

>

>> sqlplus /NOLOG
> SQL>connect sys as sysdba

That is a LOCAL session!

>
>

>> imp PRODUCT_OWN/PRODUCT_OWN_at_PRODUCT file=/export/home/oracle/snc01.DMP fromuser=PRODUCT_OWN touser=PRODUCT_OWN log=/export/home/oracle/snc01.log

And THAT is a remote session, to something you like to refer to as PRODUCT.
Why not:

imp PRODUCT_OWN/PRODUCT_OWN file=/export/home/oracle/snc01.DMP fromuser=PRODUCT_OWN touser=PRODUCT_OWN log=/export/home/oracle/snc01.log

after you fixed what Sybrand and Joel told you to fix?

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Tue Jan 29 2008 - 12:51:32 CST

Original text of this message