Very Computer

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.

Hello,

          I am a MS SQL DBA of 5 years trying to learn Oracle. How hard is it
to learn Oracle? Is it very different from MS SQL? If anyone can provide an
insight into learning Oracle from a MS SQL DBA perspective, that would be
great.

          Also, how hard is it to obtain the OCP DBA certification?

Thanks
Jinsoo
MCSE+I, MCDBA, MCSD, CCNA

an whatz ur question?

Quote:> 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.

The very first thing you should do is buy Tom Kyte's book "Expert One-On-One
Oracle" and read every reference to multiversioning, locking, the transaction
models, temp tables, and architecture. You have a lot to unlearn.

Daniel Morgan

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

Quote:> 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.

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

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

Quote:

>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

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

========= WAS CANCELLED BY =======:



Date: Mon, 28 Jan 2002 02:32:55 GMT

X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.*s,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1        
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.media.kyoto-u.ac.jp!hub1.nntpserver.com!xmission!logbridge.uoregon.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40720823

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.

The very first thing you should do is buy Tom Kyte's book "Expert One-On-One
Oracle" and read every reference to multiversioning, locking, the transaction
models, temp tables, and architecture. You have a lot to unlearn.

Daniel Morgan

========= WAS CANCELLED BY =======:



Date: Mon, 28 Jan 2002 00:25:09 GMT

X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.*s,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1        
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!news.tele.dk!small.news.tele.dk!204.71.34.15!news-out.cwix.com!newsfeed.cwix.com!cpk-news-hub1.bbnplanet.com!news.gtei.net!news.voicenet.com!feedeast.news.agis.net!aleron.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40721037

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.

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

========= WAS CANCELLED BY =======:



Date: Mon, 28 Jan 2002 01:16:11 GMT

X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.*s,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1        
Path: news.uni-stuttgart.de!cert.uni-stuttgart.de!news.belwue.de!fu-berlin.de!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40720486

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.

an whatz ur question?

Quote:> 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.

========= WAS CANCELLED BY =======:



Date: Mon, 28 Jan 2002 02:20:11 GMT

X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.*s,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1        
Path: news.uni-stuttgart.de!news.ruhr-uni-bochum.de!news.tmr.net!news.vew-telnet.net!newsfeeder.ewetel.de!news1.carrier1.net!newsfeed.online.be!193.109.243.20.MISMATCH!newsfeed.stueberl.de!news-out.cwix.com!newsfeed.cwix.com!solaris.cc.vt.edu!news.vt.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40721322

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.

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

Quote:> 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.

========= WAS CANCELLED BY =======:



Date: Mon, 28 Jan 2002 02:39:13 GMT

X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.*s,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1        
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.hanau.net!fr.clara.net!heighliner.fr.clara.net!nerim.net!feed.ac-versailles.fr!out.nntp.be!propagator-SanJose!in.nntp.be!xmission!logbridge.uoregon.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40720836

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.