Re: Getting old data out...

From: Alistair <alistair.thomson_at_sphinxcst.co.uk>
Date: Tue, 30 Oct 2001 16:10:58 -0000
Message-ID: <9rmjcl$3p6$1@thorium.cix.co.uk>

I did this a while back. All I did was export the data from Oracle 6 and import it into Oracle 8.

Alistair

Colin Carpenter <ccarpenter_at_colware.co.uk> wrote in message news:tIzB7.90089$sF.7133306_at_news2-win.server.ntlworld.com...
> Hi All,
>
> I've been given an interesting project to recover as much data from an old
> HP-UX server running Oracle 6. I don't really have a great deal of
> knowledge in this field so any help would be much appreciated. I can get
to
> an SQL prompt and run SQL scripts but again my knowledge is limited. All
> documentation for the database has been lost so I'm not even sure of the
> table names. What I'd ideally like to do is list all the tables that are
in
> the database and then dump each one out to a file so that I can do
something
> with the data elsewhere - can this be done in SQL??
>
> Many thanks in advance,
>
> Colin.
>
>
Received on Tue Oct 30 2001 - 10:10:58 CST