Re: SQL client at home to connect to University Oracle??

Laurie wrote:

> Is there a SQL client software that can be installed on my home machine that
> allows me to connect to my University Oracle database over the internet? I
> dont want to install Oracle (its over 2Gb) when all I will be doing is using
> it to connect to my University DB. I've heared about sql*net which may do
> what I want but I cannot seem to find it for download anywhere, not even
> oracle site.
> Thanks
>
> Laurie

Depends on the version of Oracle at your university.

With any version you should be able to telnet in ... my suggestion would be to download a copy of 'putty' as it gives a substantially better telnet interface than the version included with Windows.

[Quoted] [Quoted] Alternatively, if the university has 9.2 you could install iSQL*Plus which is an internet front-end but this will require the university give you appropriate access through the firewall and you will need a copy of Oracle (not the entire database just the client) to install iSQL*Plus.

My recommendation, as has been that of others, is to go ahead an install a complete copy of Oracle. That way you can learn things they won't teach you at the university involving DBA skills with SYS. At the University of Washington we intentionally do not provide Oracle on-campus but rather insist that students have their own copy. It allows me to teach students how to create and drop tablespaces, control files, log files, and lots of other things that would never be allowed the other way.

Daniel Morgan Received on Fri Feb 28 2003 - 01:28:16 CET