Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Novell to Win2k
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...Received on Tue May 11 2004 - 06:37:50 CDT
> 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.
>
![]() |
![]() |