RE: Re[2]: dba age
exactly... now, i have to say, there is the option to round up/down when necessary depending on how many gray hairs are showing through the hair color application and available room lighting... -Original Message- Sent: Wednesday, 23 July, 2003 12:15 To: Multiple recipients of list ORACLE-L So, your answer is 51.667? Sounds about right. -rje P> chronologically i'm 50 P> mentally i'm 15 P> physically i'm 90 P> -Original Message- P> Sent: Wednesday, 23 July, 2003 10:55 P> To: Multiple recipients of list ORACLE-L P> Now this one is difficult folks .. P> what is average age of an experienced oracle dba ? P> -ak -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Purcell, Sandra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dba age
chronologically i'm 50 mentally i'm 15 physically i'm 90 -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Wednesday, 23 July, 2003 10:55 To: Multiple recipients of list ORACLE-LSubject: dba age Now this one is difficult folks .. what is average age of an experienced oracle dba ? -ak
committed row insert doesn't show first time...
two oracle 8174 databases on one aix 4.3.3 server database1 = CMS database2 = HAT In database2 (HAT) insert a row into table card_status_log on hat --The insert is happening directly in database2 from a --direct sqlplus connect to the hat database. --no link involved with insert commit; successful no errors --- from database1 (CMS) --Distributed query run via sqlplus session on CMS: SELECT card_id, card_status_id, cardtype_cd, cardstatus_cd, card_status_reason_cd, status_date, user_id FROM hat_card_status_log (synonym over a link to card_status_log table in database2) where card_id = 302 UNION SELECT card_id, card_status_id, cardtype_cd, cardstatus_cd, card_status_reason_cd, status_date, user_id FROM card_outline_status_log (table in database1) where card_id = 302; open a sqlplus session from database1 (CMS), query for newly inserted row from initial insert above new row does not show rerun query for new row from same sqlplus session in database1 newly inserted row shows --Remote query running first part of the query (select to database2 without union) shows newly created row on first attempt *** work around... add hint, qualify object names: SELECT /*+ DRIVING_SITE(hcsl) */ hcsl.card_id, hcsl.card_status_id, hcsl.cardtype_cd, hcsl.cardstatus_cd, hcsl.card_status_reason_cd, hcsl.status_date, hcsl.user_id FROM hat_card_status_log hcsl where hcsl.card_id = 302 UNION SELECT csl.card_id, csl.card_status_id, csl.cardtype_cd, csl.cardstatus_cd, csl.card_status_reason_cd, csl.status_date, csl.user_id FROM card_outline_status_log csl where csl.card_id = 302; open sqlplus session query for newly inserted row from database1 (CMS), shows with initial query why doesn't the first distributed query work on initial execution? thanks sandy, long time lurker <>
RE: Oracle Internals course
not a problem -Original Message- Sent: Monday, 28 October, 2002 16:13 To: Multiple recipients of list ORACLE-L Surf to: http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?redir_ type=10 (MS will wrap the link) ...then search for "Internals". Four 8i Internals courses should come up. HTH! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, October 28, 2002 3:04 PM To: Multiple recipients of list ORACLE-L This course isn't visible on education.oracle.com ... anyone have a link? Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Purcell, Sandra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).