Re: Advice: Oracle 6 -> Oracle 7 conversion
Date: 1996/09/06
Message-ID: <50ptt5$lqr_at_juliana.sprynet.com>#1/1
Chris,
Best and cleanest way would be to do a full export of the v6 database and import it into the new v7 database, that way you avoid messing with tapes, machines, setup of windows etc. The import into v7 will take care of the upgrade from v6 to v7. You may need to review the way your application uses the char datatypes as these change to varchar2 in v7.
regards
Abdul
csch_at_MBnet.MB.CA (Chris Schneider) wrote:
>I have an old Oracle v6.0.31.2.2 DB running on a standalone 486 using
>Oracle's protected mode executive. The machine has MS windows
>3.1 installed. I want to extract the data from the v6 DB and put it
>into an Oracle v7 DB. What's the best way? One more complication:
>the PC is 2000mi away, so I was hoping to have a backup tape sent to
>me, and extact it from there. Will this work? Is there a better way?
>Any suggestions are greatly appreciated! Please send email to:
> csch_at_niche.mb.ca
>Thanks in advance!
>Chris Schneider
>--
>Chris Schneider work phone: (204) 786-2400
>Niche Technology Inc. home phone: (204) 775-1469
>54 Balmoral St. e-mail: csch_at_niche.mb.ca
>Winnipeg, MB R3C 1X4
Received on Fri Sep 06 1996 - 00:00:00 CEST