Re: Novell to Win2k

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