Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: exp remote DB : 1. rcp/ftp for file copy 2. sliding-window/start-stop protocol for Data transfer

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 18 Aug 2004 19:37:21 +0200
Message-ID: <6q47i0desk30pl2lt91tl2j6e6e6k6bugl@4ax.com>


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 DBA
Received on Wed Aug 18 2004 - 12:37:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US