"Rath.Yelandur" <Rath.Yelandur (AT) Spam (DOT) Nope> wrote

Not exactly. You can use UDF to create an MV. But problems will come
when you try to "fast refresh" it, as it is considered "complex" and
can only be complete refreshed. Problems may also come when you try to
use "query rewrite" - unless the UDF is declared "deterministic".


- Jusung Yang

Why is it so hard to find out how to get a simple list of what fricken files
there are? Okay, so I'm an Oracle moron but I've got plenty of programming
experience. Is there anyplace that has a straight forward "cheat sheet"
kind of listing of simple, "get you started" kind of commands? Maybe a
super condensed "For the neanderthal" Dummy's guide online? I've figured
out how to install 8i on Solaris but now I'm scratching my head going NOW
what?

And PLEASE don't say RTFM. I've RTFM and am STILL confused of where to go
next.

Oracles features is enough to intimidate most users. If you have some
programming experience, it should not be hard to pick up the basics of
Oracle Sql Programmning. DBA is tougher.

i would suggest thomas kytes book "Expert one on one Oracle" and
Jonathan Lewis "Practical Oracle 8i". Forgive me if i get the last title
wrong. Also check out Quest softwares knowledge expert for DBA and
PLSQL. really helpful to get a quick start.

Being a DBA is tough or easy depending on what you are managing. If you
are a newbie and you need to manage an Oracle database with transactions
going on all the time, its madness. You better find another job.

If you are an Oracle DBA and given the task of managing a Read only
database in a student lab (like me), its easy. Plus you get the
oppurtunity to hack the thing and learn a bit!

Good luck!
Karthik

Bob Woodward wrote:

"Hans Forbrich" <forbrich (AT) telusplanet (DOT) net> wrote

TOC, quick browse of "Getting Started" and tons of Google searches. My
first sentence is what I'm trying to do to start with. Figure out what
files there are. I understand the SELECT, DESC, and a few other of the
commands, but I'm feeling inadequate by not being able to visualize "the
system." I can follow the tutorial commands that say "type this and you'll
get that" but I need to be able to explore beyond the canned commands.

As to what I'm trying to accomplish, I'm just trying to figure out what
Oracle is all about. I've programmed many years in a relational database
environment and always looked at Oracle with a bit of puzzlement. Figured
it was time to step to the other side of the fence and expand my knowledge.

As far as books, I've got "Oracle - A beginners guide" from Oracle Press, a
generic Learn SQL book and a number of web sites I've found.

"Bob Woodward" <bobw56.at.rkwco.com> wrote


In terms of docs I'd suggest you take a look at the Oracle Concepts guide to
start with.

If you come from a developers background and/or know a bit about
MSSQL/Sybase then I'd heartily recommend Tom Kytes 'Expert One-on-One
Oracle'. The only caveat being that the publisher has gone bust so you'd be
relying on the store to have some in stock.


--
Niall Litchfield
Oracle DBA
Audit Commission UK

Originally posted by Bob Woodward

http://technet.oracle.com/docs/produ...ry/release2/s-
erver.920/a96524/toc.htm

First chapter is called "What Is Oracle?"!

--
Posted via http://dbforums.com

"Bob Woodward" <bobw56.at.rkwco.com> wrote

Bob, check out the following two articles which describe the Oracle
rdbms dictionary. It contains information about all objects and users
defined to the Oracle system:

How do I find information about a database object: table, index,
constraint, view, etc… in Oracle ?
http://www.jlcomp.demon.co.uk/faq/object_info.html

How do I find out which users have the rights, or privileges, to
access a given object ?
http://www.jlcomp.demon.co.uk/faq/privileges.html

There are many other interesting, useful articles hosted on Jonathan's
site under what he has called the cooperative FAQ.

HTH -- Mark D Powell --

Bob Woodward wrote:

What files? Data files? Control files? Log files? Files on the hard disk to
load?

And why would you care one way or the other about files from inside of Oracle?
File names, except if you are loading them, are irrelevant.

If you can provide explanation ... answers will follow.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Bob Woodward wrote:


Sounds like you are interested.

The first place to start is on the Oracle site at http://otn.oracle.com - get an
id (as far as I can tell trhese id's are spam-free) and start looking around.

In the documentation area, find the Concepts manual for the version you are
interested in learning and walk through that. If that seems too much top start
with, I strongly recommend O'Reilly's "Oracle Essentials - 2nd Ed" (see
http://oracle.oreilly.com) as a higher level intro.

There are several ways of getting involved with an Oracle database - as an
administrator, as a database developer, as an applications programmer and as a
data user.

It sounds like you are trying to move from app programmer toward database
developer. My interpretation is roughly "an app programmer deals with data
manipulation and data query/reporting" whereas "a database developer deals with
managing the types of data the app programmer deals with". In this case,
definintely go through the concepts manual!


Others will advise specific books - my recomendation right now is Wrox Press
books wriiten or co-authored by Tom Kyte. Unfortunately Wrox Press is out of
business, but you can find references by looking for books on Amazon using the
keywords "Kyte" and "Oracle" - if you can find these tywo, grab 'em!

3. Beginning Oracle Programming
by Sean Dillon, et al (Paperback - March 2002)
Avg. Customer Rating:

4. Expert One on One Oracle
by Thomas Kyte (Paperback - June 2001)
Avg. Customer Rating:

I think this is one of the key concepts I've been unknowingly struggling
against. In my current experience, database developer and application
programmer are pretty much the same hat. To get the knowledge I want I
guess I'll have to let go of the app. pgmr. thoughts until I have a handle
on the db.dev. concepts. Thanks for pointing this out.

Yep. That's the ticket. Have they invented that "ESP Module" thing yet?
The one that you plug into your head and suck the knowledge out of things
directly into your brain? I think I need one of those things.

Thanks, everyone, for all your suggestions and recommendations.