Re: access or oracle?
Date: Sat, 02 Jun 2001 21:07:11 GMT
Message-ID: <3AcS6.14795$mG4.8085997_at_news1.mntp1.il.home.com>
There really is no comparison between Oracle and Access. A more appropriate comparison might be MS SQL Server and Oracle.
Access is generally used for small databases (those with little amounts of data and few users). Oracle is for larger databases and many users. Access requires very little administration, while Oracle requires at least one DBA familiar with all of the inner-workings of the database. You can rollback uncommitted changes, perform backup and recovery operations, maintain multi-level security access, etc. There is very limited capabilities with Access when it comes to larger databases. Access 97 has a 1GB limit. Oracle is only limited to the amount of disk space you have.
"Kevin Gaisford" <kevin.gaisford_at_tinyworld.co.uk> wrote in message
news:3b18e8e3_1_at_news2.vip.uk.com...
> after some advice,
>
> someone recently mentioned to me Oracle as a database. what advantages
does
> oracle have of Access?
>
> --
> Kevin Gaisford
> Kevin.Gaisford_at_tinyworl.co.uk
>
>
Received on Sat Jun 02 2001 - 23:07:11 CEST