"Mark Bole" <makbo_at_pacbell.net> wrote in message
news:QJXnc.65899$rQ1.60120_at_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
>
Oracle 7 does have a release that runs under Novell. The tricky point to do
the export on the server is how to name the export file. Most people don't
know the syntax for the volume names. However, it is simple enough to do
the export from the w2k machine of the data on the Oracle instance on the
Novell machine.
Jim
Received on Mon May 10 2004 - 23:36:06 CDT
