Re: OT: Web hosting

2003-12-11 Thread Robert Pegram
__ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com Sa

Re: Solaris/8.1.7/LOBSEGMENT

2003-03-31 Thread Robert Pegram
; (like subscribing). > __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ro

Re: Parallel Rollbacks

2003-02-14 Thread Robert Pegram
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: Oracle FM interpretation of locking behavior

2002-12-10 Thread Robert Pegram
ate t2 set x=4 where x=1; 1 row updated. SQL> Notice No commit; >>>>>>> Session B SQL> update t2 set x=4 where x=2; 1 row updated. SQL> update t2 set x=4 where x=1; >>> this waits for the commit/rollback in session A Robert Pegram Oracle Certified DBA (

Re: order by in subquery workaround

2002-07-12 Thread Robert Pegram
d recipient of this > communication please return > the communication to the sender and delete and > destroy all copies. > > In carrying out its engagements, Ernst & Young > applies general terms and > conditions, which contain a clause that limits its > liability. A copy o

Re: Reverse Engineering Triggers

2002-06-18 Thread Robert Pegram
___ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat Ci

Re: Unsetting OPTIMAL in rollback segments

2002-05-15 Thread Robert Pegram
lifornia-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the m

RE: Locally managed tablespaces/What a DBA can do ?

2002-04-17 Thread Robert Pegram
he research I did on LMT's before I decided to use > them, it looked like > there were several bugs associated with temporary > tablespaces being LMT's so > I left my temporary ts dictionary. > > LK > > > > -Original Message- > > From: Robe

Re: Insert append generating redo

2002-04-09 Thread Robert Pegram
de 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). __ Do You Yahoo!? Yahoo! Tax Center - online fili

Re: Moving Oracle Binaries from HP to SUN

2002-02-12 Thread Robert Pegram
Thanks for the responses. I thought exp/imp was the only way to go, but I feel much more confident now. That was also Oracle's response. BTW, I think they have changed their thinking on this issue anyway. Thanks, Robert Pegram - EDS Oracle DBA --- bill thater <[EMAIL PROTECTED

Moving Oracle Binaries from HP to SUN

2002-02-12 Thread Robert Pegram
your input. TIA, Robert Pegram - EDS Oracle DBA __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET

Re: Instream SQL

2002-02-07 Thread Robert Pegram
#/bin/ksh sqlplus -s / << EOF select 'x' from dual; exit; EOF Robert Pegram Oracle DBA --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > I have a batch script running on Unix and I need to > call a short SQL script > (3 or 4 lines). Can someone show

Re: Sending email from Unix

2002-02-01 Thread Robert Pegram
On Solaris I have used uuencode - check the man page for more details. uuencode $FILE $FILE | mailx -s "subject" [EMAIL PROTECTED] Robert Pegram Oracle DBA --- Sona <[EMAIL PROTECTED]> wrote: > Oracle standby strange behaviorHi > I want to send an email from Unix with

Re: STORAGE PARAMETER?

2002-01-31 Thread Robert Pegram
will correct me if I am wrong. For indexes, you can use: alter index XXX rebuild tablespace YYY storage (...) online; If I remember correctly, using the rebuild online option, dml is allowed against the table during the rebuild - Check the documentation. Robert Pegram Oracle DBA --- Seema

Re: Oracle shadow process

2002-01-30 Thread Robert Pegram
emory. One such tool is "/usr/proc/bin/pmap". CUT <<<<<< Robert Pegram Oracle DBA --- sonia pajerowski <[EMAIL PROTECTED]> wrote: > Hello All, > How does oracle allocate memory to oracle shadow > process (client). eg. oracleORCL > (DESCRIPTION=(LOC

Re: Recovery scenario query

2002-01-10 Thread Robert Pegram
T 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: Export via pipe ksh script

2002-01-03 Thread Robert Pegram
IL PROTECTED] > DBA Quickplace: http://gkmqp.tce.com/tis_dba > > > > __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: range checking ??? URGENT

2001-11-14 Thread Robert Pegram
_______ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (

RE: Unable to rebuild database from hot backup

2001-10-26 Thread Robert Pegram
-- > 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 th

RE: Unable to rebuild database from hot backup

2001-10-26 Thread Robert Pegram
ubscribing). > > > __ > Do You Yahoo!? > Make a great connection at Yahoo! Personals. > http://personals.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Rachel Carmichael >