Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 4 down vote favorite

I need to connect to a legacy Oracle 8 database.

Oracle SQL Developer would be my tool of choice, but the current version doesn't support Oracle 8 anymore.

I tried Squirrel too, but the connection is awfully slow (and I can verify via JDBC that identical queries can actually run very fast)

My platform is Ubuntu on x86, I would consider

  • native solutions
  • Java-based solutions
  • Eclipse-based solutions (I previously used jOra, but it seems to be gone)
share|improve this question
1  
doesn't support Oracle 8 anymore... Have you tried it and failed? I would think it would still be able to work via jdbc. I would be interested to see the problems you had. – REW Jan 21 '11 at 18:01

migrated from superuser.com Jan 21 '11 at 11:53

2 Answers

up vote 3 down vote accepted

For JDBC based tools such as Squirrel you should try to use (even with Oracle8i) a 9.x or even a 10.x driver (not sure about the 10.x though). Maybe they give better performance. Somewhere on the JDBC download page of Oracle there is a compatibility Matrix that shows which driver version is compatible with which database version.

Another cross-platform (Java) solution to try out might be: http://www.sql-workbench.net

share|improve this answer
Thanks. Giving you the checkmark although the question is no longer relevant to me (I asked the admin to migrate the DB to a newer version :-)). But your answer is the most relevant to what I was looking for at the time. – Sean Patrick Floyd May 17 '11 at 8:42
+1 don't be a stranger :) – Jack Douglas♦ May 17 '11 at 11:51
up vote 5 down vote

I don't know about good.. but sqlplus run in rlwrap which makes it use readline is somewhat decent for a commandline app.

share|improve this answer
Commandline? I'm sorry, but I'll pass on that... – Sean Patrick Floyd Jan 21 '11 at 15:22
1  
@sean you didn't specify gui, and I don't use anything but, plus most linux people (I know) are cli nuts. Honestly I looked for a good free oracle 11 client that was gui, never found one. Doesn't mean it didn't exist, but I never found one that I could get working. – xenoterracide Jan 21 '11 at 15:34
I use sqltools. It's awesome. sqltools.net – Munchi Feb 20 at 19:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.