Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: loading data

Re: loading data

From: Michael Woo <mwoo_at_bigfoot.com>
Date: 2000/05/02
Message-ID: <p6BP4.71846$004.171183@news02>#1/1

exp/imp utility should be backward compatible.

That is if you take an export from 7.1, it should be importable to 8.0.5. I have done this in the pass, but not with these specific versions. The problem would be if you tried to take an 8.0.5 export and used it for a 7.1 import.

farrellyr5408_at_my-deja.com wrote in message <8ec7ck$tog$1_at_nnrp1.deja.com>...
>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 Tue May 02 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US