Re: Advice needed. learning how to make an oracle DB

You will find that Oracle and Access are very diffrent. Oracle Administration is more thinking about transactions, logs, sizing stuff. Access is more of a drag drop point click kinna environment. You really need to understand what transactions are doing like DML and DDL statements. Once you get a grip on that a lot on that the way oracle is set up begins to make sense. Access is like a big dumb file with some data in it.

1. If you want to change any interesting parameters, the best solution is to install Oracle for Windows 2000 on a powerful desktop. Then you can change all the parameters you want. If there is a spare Unix machine even better. The best thing you could do in both cases is to install all the software yourself.
2. Setting up an environment for you to create tables and add records is easy. Anything else is not. Sometimes even that is not a good idea. Here is an example, there may be a database that has both an Application and the Oracle DB. The server may have been purchased as a Turn-Key system and the DBA may not be involved in the original configuration. So the DBA basically checks the backups, capacity and a few other minor things. It would be stupid to start creating accounts on this system so some can experiment. Experimentation may cause a performance problem. Who knows? Best to stick to #1.

Marek Zyskowski
mzyskowski_at_aptilon.com

<ziggs> wrote in message news:75bb8uggoli5au8ui241269k1pqus3gev9_at_4ax.com...
> I know a little about databases, i.e. MS access. At work, we use
> Oracle 8i on a Unix Server. I want to learn Oracle. However, before
> I ask our IT dept for access, I wanted to get a few questions
> answered.
>
> 1. Assuming I get a book on how to create a database in Oracle, is
> possible for a DBA to set aside an area on the Unix Server that I can
> access and create a database while at the same time not being able to
> access areas that I might mess up by playing around. i.e. I
> accidently change some parameters in a production system that's on the
> same Server.
>
> 2. Assuming that an area could be set aside, what valid concerns would
> a DBA have for not wanting a newbie to have an area to just learn?
>
> TIA
Received on Thu Mar 07 2002 - 09:38:14 CST