No SQL Reference ? ;-)

Tom:

U seem to write some *amazing* sql queries. Any good Oracle manual for getting better at SQL?
Thanks a lot, Tom

Hi Tom,

Backup and Recovery really is important. But how come you just listed RMAN once. Shouldn't it be side by side with backup and recovery. After all it's a whole new world with rman.

I agree:

Read original up-to-date information from new Oracle versions

additionally,
found helpfull with lots of case studies + expierence:

For Backup& Recovery 8i:

Oracle8i Backup & Recovery
by Rama Velpuri, Anand Adkoli, George Williams


</code> http://www.amazon.com/exec/obidos/tg/detail/-/0072127171/qid=1048149979/sr=1-2/ref=sr_1_2/102-3360042-3271302?v=glance&s=books

* RMAN (9i):

Oracle9i RMAN Backup & Recovery
by Robert G. Freeman, Matthew Hart 
 

http://www.amazon.com/exec/obidos/tg/detail/-/0072226625/qid=1048150738/sr=1-1/ref=sr_1_1/102-3360042-3271302?v=glance&s=books <code>

and most important: and practice for yourself...

Tom,

I am a DBA and now will be working on projects related to Oracle 11i Applications, can you or someone provide a similar list of documention for 11i Applications.

Thanks..

I have also noticed you frequently refer to the Concepts Guide. I took a look at the PDF version for 8i the other day and was dismayed to find it weighing in at 900 pages (no sense in printing it out heh!). Anyway, I am going to start chipping away at it, but then it occurred to me...We're going to be looking at migrating to 9 soon (possibly even during summer break I suspect). If I were to read through the guide for 9i instead, would I frequently be finding things in our current system that did not fit? Would it be easier to read the one for 8i and then just skim over the one for 9i, looking for differences? I don't mind the reading, it's just that I want to save some time for other things, too, like your book...

Thanks!

hey tom,the first thing i was asked to do was read Concepts guide by you in your book.i am a novice of oracle but beleive me it has increased my confidence to sky.its gonna help every one who wants to know the internels .
thanx a lot.

Hi Tom,

Started reading the 9i concepts guide - finally!

Already stumbled and have a query...

Regd. READ-ONLY databases, It states "...However, you cannot take permanent tablespaces offline while a database is open in read-only mode. Also, job queues are not available in read-only mode.
"
and then again later it states:

"Read-only mode does not restrict database recovery or operations that change the database's state without generating redo data. For example, in read-only mode:

Datafiles can be taken offline and online
" ...

hmmm, I do understand that taking a datafile offline is
not the same as taking the full tablespace offline. But if the datafile belongs to a permanent tablespace, can it still be taken offline (yes.. I'll try this as I speak!).

So, my query is - if a datafile of a permament TS can be taken offline why not the full TS (i.e in a READ-ONLY database)?

Thanks,
Sandy

Hi Tom,

Was searching for the string "online partition" on the website and got this error..

"
Error ERR-1008 Error performing branch to page 1. >> p_request=, p_instance=1024609713156035411, p_flow_step_id=1
OK

ORA-00001: unique constraint (FLOWS_010403.WWV_FLOW_DATA_IDX1) violated
"

maybe a freak error.. hope this helps anyway.

Regards,
Sandeep

Hi,

What about differences between database concept guides for 10.2 and 11.2? Whether 11.2 guide is fully applicable for 10.2 database?

Thank you!