How to extract Oracle 3.x data from really old server

40 views Asked by At

tl;dr - How can I extract database information from an Oracle 3.x database server when the tools today don't support it?

I have a customer who neglected upgrades across the board (Win Server 2003, Oracle 3x, etc..yes, I know this is wrong across the board but It's my job to clean it up) and I need to extract the database information from the databases on this server for importing into something more modern.

I've checked the Oracle and non oracle db GUI applications and they oldest they go back is version 7. I've looked on Google and here and I have yet to find some sort of solution for data extraction. Do I need to ping Oracle for a version of their Gui application that will work with Version 3? Is there a code solution? I'm stumped.

1

There are 1 answers

0
lacroix_soda_of_oryx On

That did the trick @littlefoot I also looked at the following:

SQuirrel

http://squirrel-sql.sourceforge.net/index.php?page=faq

SQLTools

http://www.sqltools.net/