Re: ORACLE7 list of features

From: craig sivils <casivils_at_lescsse.jsc.nasa.gov>
Date: 25 Feb 93 19:38:00 GMT
Message-ID: <casivils.730669080_at_node_508ba>


In <1993Feb24.205651.26134_at_netcom.com> jbennett_at_netcom.com (Joseph Bennett) writes:

>The only problems is that......
 

>Stored procedures and functions require the purchase of the Procedural Option

So don't store them in the database, it is still an improvment

>Any remote database features (at least the ones that are being touted) require
>the purchase of the Distributed Option (which, to my understanding, NO ONE
>GETS FOR FREE).
the ones being touted, thats very precise.

>Use of the same database on multiple machines require the Parallel Option.

Funny we do that now with a vax cluster just fine

>Use of the Multi-Threaded Server requires SQL*Net v2 which is still in beta.

SQL*Net is in beta on what machines?
Not true on all machines, for example MVS has had multi-threaded servers since v5 (to be fair, I only found this out yesterday).

>Lastly, as of now, at least on the VMS platform, only the base development
>tools are available (SQL*Forms, Menu, Report*Writer). NO end-user tools are
>available (at least from Oracle - such as Data Query or SQL*QMX or EASY*SQL).
>Also, the CASE tools are, as of yet, unsupported, and I was told that they
>would be available in 'maybe March' (which means 'maybe August'). Also,
>none of the financials or other 'applications' from Oracle are supported
>yet on Oracle7.

This is blatently false, I use case, Oracle makes SQL*QMX and EASU*SQL they have been around for ages, and if this is your idea of an end user tool then you must have some real clever end users.

>There are MANY problems with the migration - I was told that the average time
>to migrate was 1.5 hours per 500mb of data. Our time to finish (and we
>ended up giving up and will rebuild our database later) was 20 hours for a
>2.5gb database.

I would question the wisdom of anyone who would give you the first quote and would even go as far as to say that if you did it in 20 hours then it went pretty smooth (considering the size of the database).

                                Craig
Received on Thu Feb 25 1993 - 20:38:00 CET

Original text of this message