Re: MS SQL DBA learning Oracle

Main differences from a (extremely) novice MS SQL server bod.

More typing required - command line often far quicker than loading GUI's. Oracle does not automate as much as SQL server - setting up a backup takes more then 10 mouse clicks.... Although things are getting more GUI'd in 9i.

SQL uses the idea of multiple database with a master and couple of others. Oracle user schemas and users - SYS is the Master equivalent. Roles appear in both DB's but a user is can not be tied to a schema without the use of roles in Oracle.

Oracle makes use of ROWID's that uniquely identify each and every row. Once a row is created its ROWID never changes.

Oracle DBA's in general do not go for Auto allocation of additional space. Oracle uses logical entities (tablespaces) into which data is stored. Like SQL these are made up of multiple files but are often segregated for specialist usage - SYSTEM for sys objects only, TEMP for temporary data (joins, sorts, etc), RBS for rollback segments, USER for tables and INDX for indexes - some advocate every schema owner (schema own objects) having their own tablespace for data and indexes; others expect 3 tablespace to be created for tables and indexes (1 for each with small, medium and large storage settings). Redo logs are used for the same purpose as transaction logs and are archived into archived redo logs.

From what I have seen Oracle databases are more tuneable (in terms of initialisation parameters) than SQL.

Is this the sort of thing you are after?

Nathan

"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:3C52848B.7495CC24_at_exesolutions.com...
> I agree. The problem with them, though, is that they say what Oracle is
> ... but do not do comparisons with other architectures. A critical factor
> when trying to migrate one's skill set. It is not just what you need to
> learn ... it is what you need to unlearn.
>
> Daniel Morgan
>
>
>
> Pamela Samuels wrote:
>
> > In addition to books by Kyte and Jonathan Lewis, the Oracle Concepts
> > manual is a good place to start. I find Oracle documentation to be
> > first rate.
> >
> > You can download and print it from technet.oracle.com
> >
> > "ILLINI012" <illini012_at_aol.com> wrote in message
> > news:20020125190941.14226.00000832_at_mb-md.aol.com...
> > > Hello everyone,
> > >
> > > I am a MS SQL Database Analyst of 5 years. I know MS SQL very
> > well. I
> > > already have a MCDBA (MS DBA certification) and thinking of learning
> > Oracle and
> > > going for the OCP.
> > >
> > >
> > >
>
Received on Sun Jan 27 2002 - 08:41:16 CST