Xref: alice comp.databases.oracle.server:78496 Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!paloalto-snf1.gtei.net!news.gtei.net!inet16.us.oracle.com!not-for-mail From: Thomas Kyte Newsgroups: comp.databases.oracle.server Subject: Re: Exporting Database ??? Date: Mon, 20 Dec 1999 09:17:45 -0500 Organization: Oracle Service Industries Lines: 48 Message-ID: References: <83lcep$6n4$1@newsreader.gigabell.net> Reply-To: tkyte@us.oracle.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: inet16.us.oracle.com 945699654 4720 138.1.115.225 (20 Dec 1999 14:20:54 GMT) X-Complaints-To: usenet@inet16.us.oracle.com NNTP-Posting-Date: 20 Dec 1999 14:20:54 GMT X-Newsreader: Forte Agent 1.7/32.534 A copy of this was sent to "Axel Stahl" (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@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@us.oracle.com Oracle Service Industries Reston, VA USA Opinions are mine and do not necessarily reflect those of Oracle Corporation