New to Oracle

[johnlinh]

Hi:
I am from DB2 camp. I have just started to learn Oracle by download and
install Oracle 8.1.7 client, connect to an existing Oracle DB. I also
downloaded Oracle manual and walking thru it. I have tested what I have
learned PS/SQL SQL/PLUS. Is there any site/book that I can compare Oracle
functions with DB2? I would like to start from application development,
building tables, tuning indexes (by looking into system tables),.... Your
suggestion would be appreciated.

[Daniel Morgan]

johnlinh wrote:
Hi:I am from DB2 camp. I have just started to learn Oracle by download andinstall Oracle 8.1.7 client, connect to an existing Oracle DB. I alsodownloaded Oracle manual and walking thru it. I have tested what I havelearned PS/SQL SQL/PLUS. Is there any site/book that I can compare Oraclefunctions with DB2? I would like to start from application development,building tables, tuning indexes (by looking into system tables),.... Yoursuggestion would be appreciated.
Can't think of anything specific to DB2 to Oracle though it may well
exist. But I would strongly urge
you to go to http://tahiti.oracle.com and look at the CONCEPTS books. Be
sure you understand
the very significant differences between the underlying architectures of
Oracle vs DB2: They are
completely different.

On the other hand converting PREVVAL to CURRVAL will be just about
everything you will
need to learn about sequences.

Welcome.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[johnlinh]

Thanks very much, I actually would like to know:

"the very significant differences between the underlying architectures of
Oracle vs DB2".

beside how indexes are organize, authority to create database, table, table
indexes. I also looking into SYS tables (the same as looking into SYSIBM
tables for DB2).
I understand that data types is somwhat different between the two.

The link that you point to me is more structure and easier to navigate than
search thru the whole manual (more relational to me!).

Thanks again
Oracle vs DB2:
"Daniel Morgan" <damorgan@x.washington.edu> wrote in message
news:1067002024.263103@yasure... johnlinh wrote:Hi:I am from DB2 camp. I have just started to learn Oracle by download andinstall Oracle 8.1.7 client, connect to an existing Oracle DB. I alsodownloaded Oracle manual and walking thru it. I have tested what I havelearned PS/SQL SQL/PLUS. Is there any site/book that I can compare Oraclefunctions with DB2? I would like to start from application development,building tables, tuning indexes (by looking into system tables),.... Yoursuggestion would be appreciated. Can't think of anything specific to DB2 to Oracle though it may well exist. But I would strongly urge you to go to http://tahiti.oracle.com and look at the CONCEPTS books. Be sure you understand the very significant differences between the underlying architectures of Oracle vs DB2: They are completely different. On the other hand converting PREVVAL to CURRVAL will be just about everything you will need to learn about sequences. Welcome. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)

[Daniel Morgan]

johnlinh wrote:
Thanks very much, I actually would like to know:"the very significant differences between the underlying architectures ofOracle vs DB2".beside how indexes are organize, authority to create database, table, tableindexes. I also looking into SYS tables (the same as looking into SYSIBMtables for DB2).I understand that data types is somwhat different between the two.The link that you point to me is more structure and easier to navigate thansearch thru the whole manual (more relational to me!).Thanks againOracle vs DB2:"Daniel Morgan" <damorgan@x.washington.edu> wrote in messagenews:1067002024.263103@yasure...johnlinh wrote:Hi:I am from DB2 camp. I have just started to learn Oracle by download andinstall Oracle 8.1.7 client, connect to an existing Oracle DB. I alsodownloaded Oracle manual and walking thru it. I have tested what I havelearned PS/SQL SQL/PLUS. Is there any site/book that I can compare Oraclefunctions with DB2? I would like to start from application development,building tables, tuning indexes (by looking into system tables),.... Yoursuggestion would be appreciated.Can't think of anything specific to DB2 to Oracle though it may wellexist. But I would strongly urgeyou to go to http://tahiti.oracle.com and look at the CONCEPTS books. Besure you understandthe very significant differences between the underlying architectures ofOracle vs DB2: They arecompletely different.On the other hand converting PREVVAL to CURRVAL will be just abouteverything you willneed to learn about sequences.Welcome.--Daniel Morganhttp://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asphttp://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.aspdamorgan@x.washington.edu(replace 'x' with a 'u' to reply)
The most important differences in architecture that you must learn
related to the fat that
Oracle uses a multiversion concurrency model such that READS never block
WRITES
and WRITES never BLOCK reads. Add to that the fact that locks are an
infinite
resource and that there is no such thing as lock escalation and you
start to get an idea of
how the differences can become critical.

The other area of very large differences is the security model. Look up
the following at
tahiti. (1) ROLE, (2) PROFILE, (3) DBMS_RLS, (4) EXCLUDED NODES,
(5) SYSTEM PRIVILEGES, (6) TABLE PRIVILEGES. That will get you started.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Sybrand Bakker]

On Sat, 25 Oct 2003 12:18:48 GMT, "johnlinh" <johnlinh@hotmail.com>
wrote:
"the very significant differences between the underlying architectures ofOracle vs DB2".


Usually the best way to learn Oracle is to forget everything you
learned about any other product. You will end up 'porting' your DB2 or
SQLserver habits to Oracle, which is in 99.9 percent of all cases a
recipe for disaster.


--
Sybrand Bakker, Senior Oracle DBA