Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data extraction using SQL....
select owner, table_name from all_tables will give you all the tables you
have access to.
You might want to try creating an export file. If you have Oracle 7 around,
you should be able to import into that. I don't know if 8.x will read 6
export files.
-- Terry Dykstra Canadian Forest Oil Ltd. "Colin Carpenter" <ccarpenter_at_colware.co.uk> wrote in message news:eMzB7.90119$sF.7136628_at_news2-win.server.ntlworld.com...Received on Wed Oct 24 2001 - 09:40:46 CDT
> 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.
>
>
>
>