Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exp remote DB : 1. rcp/ftp for file copy 2. sliding-window/start-stop protocol for Data transfer
On 18 Aug 2004 10:32:01 -0700, qazmlp1209_at_rediffmail.com (qazmlp)
wrote:
>'exp' utility is invoked from the local Solaris machine as follows:
>exp userid=scott/tiger_at_orcl parfile=export.bin
>
>'orcl' represents the DB existing in the remote machine(This is
>configured accordingly in the tnsnames.ora that is existing in the
>local machine).
>In that case, how exactly the export.bin is transferred from the
>remote to the local machine? Using rcp or ftp? Also, what exactly is
>the protocol used for Data transfer? Is it sliding-window or
>start-stop protocol ?
First of all : stop crossposting
Secondly: read a manual. The export is not copied at all.
If you connect to a remote database, you simply issue implicit selects
against a remote database instead of a local database. The export is
always created locally, rcp or ftp is not involved at all.
Please read the Oracle Concepts Manual *urgently* to get a better
picture of how Oracle works.
And also : STOP your habitual crossposting.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Aug 18 2004 - 12:37:21 CDT