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: Bill Van Dyk <trash_at_christian-horizons.org>
Date: Mon, 10 May 2004 14:51:07 -0400
Message-ID: <409FCF1A.2040205@christian-horizons.org>


We want to move the data from the Oracle 7.3 system on Novell to Oracle 8.1.7 on Windows 2000 server.

There are about 30+ tables involved. Is there a better way?

Frank van Bortel wrote:

> Bill Van Dyk wrote:
>
>> 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.
>>
>
> exp reads data, not the datafiles. It will create a file,
> usually called a dump or export file, that contains
> statements like: create this table, insert these values
> into it. The imp process will execute these commands.
>
> No datafiles to be set, and no datafiles involved, either.
> Not directly, at least.
>
> What are you trying to do?
Received on Mon May 10 2004 - 13:51:07 CDT

Original text of this message

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