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

OK, I got the SSH working to my University. Its crude but it works. With zero file space!
I agree that its good to put oracle on to use and learn. I have this intention which is why I have the disks. But I have no time to do anything more than simple PL/SQL right now so for the time being I'll save space on my pc.
Thanks.
Laurie

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E5EAD20.37F1DF12_at_exesolutions.com... 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.

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 - 02:33:06 CET