Re: exp remote DB : 1. rcp/ftp for file copy 2. sliding-window/start-stop protocol for Data transfer
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 DBAReceived on Wed Aug 18 2004 - 19:37:21 CEST