Re: Novell to Win2k

From: Mark Bole <makbo_at_pacbell.net>
Date: Tue, 11 May 2004 03:26:40 GMT
Message-ID: <QJXnc.65899$rQ1.60120@newssvr25.news.prodigy.com>

Jim Kennedy wrote:

> "Bill Van Dyk" <trash_at_christian-horizons.org> wrote in message
> news:409FCF1A.2040205_at_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?
>>

[...]

There is only one way to get Oracle data reliably from one platform and version to another, and that is export and import.

>>>>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.

Major details are missing. What command are you running, and what error do you get?

I was never a Novell administrator, so forgive if this is a dumb question, but is the Oracle server itself (the instance) running under Novell, or is Novell simply hosting the filesystem where the datafiles are via the network? (I don't know if there was an Oracle v7 for Novell...) Can you set your ORACLE_SID and do a version 7 command such as "svrmgrl ... connect internal" ?

>>>>
>>>>I am a database manager with some training and more than a few gaps
>>>>in my knowledge. Any help would be appreciated.
>>>>
>>>

--Mark Bole Received on Mon May 10 2004 - 22:26:40 CDT