Re: Novell to Win2k

From: daniel <test_at_test.com>
Date: Tue, 11 May 2004 12:37:50 +0100
Message-ID: <40a0bb0e$0$25326$ed9e5944@reading.news.pipex.net>

Hi,

If it's just tables you want to move, create a dblink from your w2k server to the database and schema on your novell server and;

create table t_name as select * from schema.t_name_at_dblink;

Then you won't need to worry about any version problems with exp/imp utilities.

--

Regards,

Daniel...


"Bill Van Dyk" <trash_at_christian-horizons.org> wrote in message
news:409FC942.6020207_at_christian-horizons.org...


> I have a problem exporting files.  I've been around and around the web

> trying to find the solution, but it appears that this problem has too

> many idosyncracies for that kind of solution.

>

> Here's the details.  We are running a database on Oracle 7.3.4.0.1 on

> Novell 4.11 server.  The Oracle application is on Vol5 but the data base

> files have been moved to vol8 (full path: vol8:oranw734\database).

>

> The schema is called "contact".

>

> Is there some weird trick to getting the Exp command to point to the

> data base files on different volume?  Running Server Manager from Vol5

> from the server console does not permit me to see the tables in the

> contact schema.

>

> I am a database manager with some training and more than a few gaps in

> my knowledge.  Any help would be appreciated.

>

Received on Tue May 11 2004 - 06:37:50 CDT