Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Novell to Win2k

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US