Re: Convert db Oracle 7.0 to 10g
Date: Mon, 01 Sep 2008 12:31:27 GMT
Message-ID: <zgRuk.166$Af3.16@trnddc06>
"borntoride" <joleveille_at_gmail.com> wrote in message
news:b392c720-ab60-45d3-80d3-dc5fba9bd5b1_at_8g2000hse.googlegroups.com...
On 31 août, 12:20, "gym dot scuba dot kennedy at gmail"
<kenned..._at_verizon.net> wrote:
> "Robert Klemme" <shortcut..._at_googlemail.com> wrote in message
>
> news:6hvfknFo28q2U2_at_mid.individual.net...> On 31.08.2008 08:08, borntoride
> wrote:
>
> >> Hi ! Thanks a lot for your time. I need to transfer data from a
> >> database in Oracle 7.0 to a new accounting software. From this new
> >> accounting software, we can import data from many type of DB, but not
> >> from Oracle....
>
> > A fairly easy solution might be to use MS SQL Server 2k's DTS. With that
> > you can pretty easy copy a whole schema or even DB IIRC to another
> > database. All you need is an ODBC driver.
>
> > Kind regards
>
> > robert
>
> Reading between the lines of what the OP needs it seems that he is trying
> to
> put data from an old system into a new system. It is likely that the table
> names and definitions are different.
> Jim
But my main problem is to find the ODBC for the Oracle 7.0 version... I found somes for 7.3, 8, 9, 10, etc but anything for 7.0 ... Why bother doing that, just use sqlplus and spool the output to csv files. Jim Received on Mon Sep 01 2008 - 07:31:27 CDT