Oracle7 Server Utilities
Network Considerations
This section describes factors to take into account when using Export and Import across a network.
Transporting Export Files Across a Network
Since the export file is in binary format, when transferring it across a network, be sure to use a protocol that supports binary transfers to prevent corruption of the file. For example, using FTP or a similar file transfer protocol, transmit the file in binary mode. Transmitting export files in character mode causes errors when the file is imported.
Exporting/Importing with SQL*Net
By eliminating the boundaries between different machines and operating systems on a network, SQL*Net provides a distributed processing environment for Oracle7 Server products. SQL*Net lets you export and import over a network. For example, running Export locally, you can write data from a remote Oracle database into a local export file. Running Import locally, you can read data into a remote Oracle database.
To use Export or Import with SQL*Net, include the @connect_string when entering the EXP or IMP command. For the exact syntax of this clause, see the user's guide for your SQL*Net protocol. For more information on SQL*Net, see Understanding SQL*Net. If you use Oracle Names, see also the Oracle Names Administrator's Guide.