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_at_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
[Quoted] [Quoted] 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.
[Quoted] [Quoted] And also : STOP your habitual crossposting.

--
[Quoted] Sybrand Bakker, Senior Oracle DBA
Received on Wed Aug 18 2004 - 19:37:21 CEST

Original text of this message