Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MS SQL DBA learning Oracle

Re: MS SQL DBA learning Oracle

From: JinJJa <jinjja_at_aol.com>
Date: 28 Jan 2002 05:59:34 GMT
Message-ID: <20020128005934.09559.00001423@mb-cg.aol.com>


>
>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

Yeah thanks Nathan

Jinsoo
MCSE, MCDBA, MCSD, CCNA Received on Sun Jan 27 2002 - 23:59:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US