Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
Yeah thanks Nathan
Jinsoo
MCSE, MCDBA, MCSD, CCNA
Received on Sun Jan 27 2002 - 23:59:34 CST