In article <fYv5WCAxyh+2IArs_at_nisoft.demon.co.uk>,
Tim Shute <Tshute_at_nospamnisoft.co.uk> wrote:
> Hello group,
>
> Does anyone have an opinion on the likely success of exporting data from
> and Oracle 5 system, running on a DOS-based PC and importing it into
> 7.3.4 or 8.0.4? Usual story - customer has an old system running quietly
> on a PC in the corner which they suddenly realise is not Y2K compatible.
>
> Any relevant thoughts welcome.
> --
> Tim Shute
> Software Engineering Manager
>
> NiSoft (UK) Limited
> Internet: www.nisoft.co.uk
>
Oracle 5.1.22 with SQLPME on MS-DOS? That brings back some nice memories when
the world was much, much younger then today. Anyway, I tried it on VAX-VMS
and it worked. Oracle 5 was running on VAX-VMS 4.7 (does anyone still
remember the NULL proces? Non-modular executive and good, old mVAX 3600?)
and Oracle 7.3.4 was running on an Aplha machine with OpenVMS 6.x. Import
was done without any problems. Version 5, of course, didn't have tablespaces
(although it did have so-called partitions which were pratically useless),
so you must run it with indexfile=xxx.sql option first, then edit the SQL
and put in place proper storage options, pre-create it and then import
with ignore=yes. I thought that nobody was using version 5 since the
dinosaurs were ruling the Earth? I don't know about DOS and NT either. You
might run into character set problems (on the good, old VMS, it was all 7
bit ASCII).
May the force be with you,
Mladen Gogala
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 25 1999 - 20:21:03 CST
