The command must be:
exp userid=\'system/password_at_remotelink as
sysdba\'......
The sysdba priv has to be after the connection link.
Regards.
- "Tatireddy, Shrinivas (MED, Keane)"
<Shrinivas.Tatireddy_at_med.ge.com> wrote:
> Hi lists,
>
> O/s: Solaris
> Oracle : 8.1.6
>
> can anybody post the solution for this:
>
> I need to perform an export on a remote server for
> transportable
> tablespace option:
>
> I used this:
>
> exp userid=\'system/password as
> sysdba_at_remotedblink\' file=/tmp/abc.dmp
> log=/tmp/kvn.log transport_tablespace=y
> tablespaces=abcdef
>
> the following error occured :
>
> LRM-00112: multiple values not allowed for parameter
> 'userid'
>
> I tried :
>
> exp userid=\'system/password as
> sysdba\'@remotedblink file=/tmp/abc.dmp
> log=/tmp/kvn.log transport_tablespace=y
> tablespaces=abcdef
>
> now giving error wrong username and password.
>
> I must use the sysdba option becoz , need to do exp
> of transportable
> tablespace option, and I must use @dblink to perform
> the export on a
> remote server.
>
> can anybody tell me the solution for the above?
>
> or anyother alternatives.
>
>
> srinivas.
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
> INET: Shrinivas.Tatireddy_at_med.ge.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christian Trassens
INET: ctrassens_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Oct 04 2001 - 07:30:15 CDT