Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Personal Oracle question
Well, I think that #5 is incorrect. I have created a personal Oracle
database on my home computer, and was able to create a listener for it.
Then at work I was able to connect to my home database without a problem.
John
Jonathan Gennick wrote:
> On Fri, 05 Feb 1999 20:39:03 -0500, Richard Marin
> <richmarin_at_earthlink.net> wrote:
>
> >Our company wants to adopt Oracle for Windows NT.
> >
> >I wanted to learn ASAP. Is Personal Oracle similar to Oracle Server?
>
> Very similiar. Almost identical. As far as SQL, PL/SQL, and
> the various utilities (export, import, SQL*Loader) go, there
> are no differences at all. Most of the database
> administration side is identical as well.
>
> Here are some differences that I've personally run into:
>
> 1. I've never been able to successfully issue the RECOVER
> command against a Personal Oracle database, even though I
> can run it in archive log mode. Don't know why that is.
>
> 2. None of the Enterprise options are available for Personal
> Oracle. You don't get object types, for example.
>
> 3. SQL*Plus for Personal Oracle can be used against non
> Personal Oracle Oracle databases, but the reverse is not
> true.
>
> 4. I've never tried it, but I assume that Parrellel server
> is not an option with Personal Oracle.
>
> 5. Personal Oracle has no listener.
>
> >Can
> >I learn enough from Personal Oracle to transfer those skills to Oracle
> >Server?
>
> Yes. However, if you have an NT machine at home, you might
> consider ordering an eval copy of Oracle for NT.
>
> regards,
>
> Jonathan
> ----------------------------------------------
> Jonathan Gennick -- Oracle DBA, Author, Editor
> jonathan_at_gennick.com
> http://gennick.com
> Brighten the corner where you are.
Received on Tue Feb 09 1999 - 19:30:08 CST