Re: loading data

I'm just not sure that you can use emp/imp from an oracle7.1 on OpenVMS6.2 to an Oracle805 on NT4. Do I have to upgrade Oracle to maybe 7.3 and is it easy to do across different platforms? I don't want to upgrade Oracle7.1 to anything really.

In article <39095148.27F8D2A3_at_cska.net>,   Alexander Penev <alex_at_cska.net> wrote:
> What about exp/imp utilities??
>
> farrellyr5408_at_my-deja.com wrote:
>
> > Well the situation we have is an Oracle7.1 database on OpenVMS6.2
 and
> > we would like to move the data over to Oracle805 NT4 as easily as
> > possible. I was just thinking of selecting all from the necessary
> > tables (all these tables will be new to the Oracle8 databaase) and
 that
> > would be the output file. Maybe there is a better solution.
> > In article <8e9lip$39r$1_at_nnrp1.deja.com>,
> > marcpark_at_my-deja.com wrote:
> > > The first question is what does the flat file look like.
> > > sqlloader is a choice, you could also write a pro*c progam to
 open the
> > > file and load it, you could use PL/SQL with utl_file to open the
 file,
> > > parse it and load it. Most likley the simplist solution is to
 use the
> > > sqlloader to load the data.
> > >
> > > Marc Parkinson
> > >
> > > In article <8e9jil$10m$1_at_nnrp1.deja.com>,
> > > farrellyr5408_at_my-deja.com wrote:
> > > > I'm looking for a good tool to load data from one flat file to
 an
> > > > oracle805 database. I'm not sure if sql loader is the tool or
 if
> > > > somebody knows of something better or maybe easier to use.
> > > >
> > > > Thanks.
> > > >
> > > > Sent via Deja.com http://www.deja.com/
> > > > Before you buy.
> > > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 28 2000 - 00:00:00 CDT