Re: Getting old data out...

Hi

Basically you can rely on the documentation of the actual Oracle Versions (e. g. 8i) on http://doc.oracle.com. As long as you don't use too fancy features (e. g. procedures, triggers etc.) which haven't exist in Oracle 6 most of the things should work similar.

Basically you will need to work with SQL*Plus wich allows you to select the data and spool it into a file, you will find information about SQL*Plus in the respective manual. Provided you are logged in as a DBA (SYS or SYSTEM) you can query the DBA_TABLES dicationary view in order to determince which tables exists. If you are a different user you can use USER_TABLES to show the tables which belong to this user.

I hope this helps.

Thomas

Colin Carpenter wrote:

> 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.
>
>
>

-- 
--------------------------------

more than internet

worldwide consulting for Oracle, Linux, Internet ...

w.e.b.s.p.o.t
http://www.webspot.ch

mailto:info_at_webspot.ch