| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Transportable tablesapce export on remote server
Hi lists
can anybody shed light on this:
I have a situation, doing mirroring the schemas from one server to another server.
both databases on the servers are same version 8.1.7
I need to perform export (of server2) from server1 using transportable tablespace
I am issuing the flwng command:
exp userid=\'sys/password_at_remotedb as sysdba\' file=/tmp/abc log=/tmp/abc transport_tablespace=y tablespaces=users
Prior to this I put the users tablespace in read only mode. Both databases have set remote_login_passwordfile=exclusive
But when I do export usiing the above command, is is asking username and password.
when I type correect password also, it is not getting exported.
But I am able to connect as
connect internal_at_remotedb
password:*****
Now I am able to connect to remote server as sysdba.
But cannot perform the export of transportable tablespace.
Os: Solaris
DB: 8.1.7
Can anybody post me the solution.
regards,
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). Received on Mon Oct 22 2001 - 05:20:38 CDT
 |
 |