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>
>
>> sqlplus /NOLOG
> SQL>connect sys as sysdba
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 upReceived on Tue Jan 29 2008 - 12:51:32 CST