Re: Oracle compared to Access

I somewhat disagree with your assessment of these two tools.

I have several Oracle instances/sites and I still routinely use ACCESS. Each are
tools which best serve differing problems.

I have used ACCESS for some very large (for ACCESS) datasets (7 million rows).
When I need to do some crosstabs, I download into ACCESS; compare this with the
time it takes to determine the headings using DECODE in Oracle and produce the SQL etc.

We profile some 15 million consumer registrations (15MM x 15MM for Cross-registration alone)
No one in their right mind could/should consider doing this in ACCESS; (Oracle is sweet!)

Each is a tool best suited for specific problems.

Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message news:941045758.21711.0.pluto.d4ee154e_at_news.demon.nl...
> You try to compare two products which are incomparable.
> Oracle is a client/server based product, Access isn't
> In Oracle you can distribute your database on several disks, in Access a
> database consist always of one single file
> In Oracle you have after image journalling aka redo log, in Access there
is
> no such thing.
> I could go on for a while. Honestly compared to Oracle Access is a toy. I
> must admit I like the frontend part of it, but my experience (I have been
> working with it for 4 years) tells me any Access database of more than 64
M
> will crash a few times per year. If an Oracle database crashes (usually
> caused by power dip and hardware malfunction) you can recover from it.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> <kaminari85_at_my-deja.com> wrote in message
> news:7v7a9h$66r$1_at_nnrp1.deja.com...
> > I am familiar with access. I was wanting to know the advantages Oracle
> > has over Access. Thanks for any quick thoughts.
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Oct 27 1999 - 18:50:47 CDT