info_at_barlocher.co.uk wrote in message <35C864C5.C8EF7FA2_at_barlocher.co.uk>...
>I have been using Access for the last 18mths or so and would like to try
>another database - namely Oracle. I would say i was at an intermediate
>level with Access - but im not from an IT background and do not have an
>IT degree. How easy would it be to learn Oracle? I would appreicate any
>advise.
>
Let's break this down into two parts:
- Database design: Relatively simple in MS Access. You don't have too many
choices on how to translate a logical design (tables and primary / foreign
keys) into a physical design (indices, where tables go on disk, etc.). In
Oracle, learning physical design is crucial to performance (particularly as
your database gets bigger). You *can* treat your database as though it were
an MS Access database, but, your performance will suffer! Also, Since the
database is no longer in a single file and is more robust, you will need to
understand all the files involved and how to back them up.
- Programming: As mentioned earlier, you will either need to purchase front
end tools (e.g., Oracle Developer/2000) or write SQL code and execute it via
scripts. Most PC people will opt for the former. We batch oriented
old-timers may choose the latter.
- Hope this helps,
- Barry L. Wallis
- Senior Systems Engineer
- SAIC - An Employee Owned Company!
Received on Fri Aug 07 1998 - 09:50:08 CDT