Oracle 8.0 admin course 2

[ddiamond]

I've been working with oracle 8.0 for about 5 years, but I have not had any formal training in it. I was recently promoted to oracle DBA, so I think a formal admin course will be helpful. The only problem is that all of the oracle courses appear to be for version 10g. Will a 10g admin course still be helpful? How much of what I learn will be applicable to version 8.0? And yes, if I could I'd upgrade to oracle 10g, but for reasons outside of my control, I don't think that is going to happen any time soon.

 

[Beilstwh]

as long as you keep your statistics up to date (10g is cost based, not rule based), you should not need hints at all. On my site, I run a scheduled job every morning at 5am to update the statistics. Also, the optimizer understands the old joins just fine, however there are some joins (for example full outer join) that can't be done using the old syntax.

Bill
Oracle DBA/Developer
New York State, USA

 

[SantaMufasa]

Actually, Bill, with "old syntax" you can accomplish a "full outer join" with:

SELECT...
  FROM <x>, <y>
 WHERE <x>.<exp> = <y>.<exp>(+)
UNION
SELECT...
  FROM <x>, <y>
 WHERE <x>.<exp>(+) = <y>.<exp>;

And due to caching and the UNION operator, it is surprisingly fast, as well.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Beilstwh]

Thanks Dave, I knew that but I was making reference to the fact that you can do it in a single select without a union. Sorry everyone for not being clear, my bad.

Bill
Oracle DBA/Developer
New York State, USA