Take the 2-minute tour ×
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.

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

migration rejected from superuser.com 1 hour ago

This question came from our site for computer enthusiasts and power users. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

put on hold as off-topic by Paul White, Phil, Aaron Bertrand 1 hour ago

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the 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

2 Answers 2

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

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

share
    
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 '13 at 19:50

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