Re: Exporting Database ???

A copy of this was sent to "Axel Stahl" <pdg.stahl_at_t-online.de> (if that email address didn't require changing) On Mon, 20 Dec 1999 14:56:23 +0100, you wrote:

>Hello Oracle-Experts,
>
>I have a problem which is very serious:
>We have a Netware 3.12 Server running Oracle 7.3.4.0.0 .
>Because of a server change we have to export the database
>to another server (WinNT4.0 running equal Oracle version).
>Problem is that we can't mount further volumes anymore and there
>is not enough space on the Netware volumes to export the Database
>locally.
>Is there any possibility to export an Oracle Database (all tables and
>perhaps the users, too) remotely - over the network, I mean
>that some application (e.g. Enterprise Manager ON AN ANOTHER MACHINE)
>can "retrieve" the tables and users etc. from the Novellserver and
>store the retrieved tables and users in it's own (or another)
>Oracle DB installation?
>I don't know how I else could transfer all the tables and users from that
>Novellserver to another server without exporting all the stuff on the
>local Novellserver (remember I can't mount anymore volumes - the DB is
>distributed over all the volumes on which is now not enough space anymore
>to export the DB/users)
>
>Perhaps some of You Oracle experts can help me out there.
>Thank you.
>
>
>Axel
>

install 7.3.4 on the NT box.

setup the tnsnames file on the NT box so that the Novell server can be sqlplus'ed to (eg: sqlplus scott/tiger_at_novellsvr works)

use exp on the 7.3.4 NT install over the network to export.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Dec 20 1999 - 08:17:45 CST