Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Novell to Win2k
"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?
>
> 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?
>
>
You will need to export the data out of Oracle on the Novell server and
import it into the Oracle running on W2K. I am assuming you already have
the tablespaces created in the w2k instance. You can even do the export
from the w2k server.
Jim
Received on Mon May 10 2004 - 19:59:26 CDT
![]() |
![]() |