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@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@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).