Re: OT: Web hosting

2003-12-11 Thread Robert Pegram
/ -- 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 San Diego, California-- Mailing list and web hosting services

Re: Solaris/8.1.7/LOBSEGMENT

2003-03-31 Thread Robert Pegram
FAQ: http://www.orafaq.net -- Author: Robert Pegram 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

Re: Parallel Rollbacks

2003-02-14 Thread Robert Pegram
you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.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 San Diego, California

Re: Oracle FM interpretation of locking behavior

2002-12-10 Thread Robert Pegram
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 (8i,9i) --- Jesse, Rich [EMAIL PROTECTED] wrote: Hey all, After converting three

Re: order by in subquery workaround

2002-07-12 Thread Robert Pegram
- First Month Free http://sbc.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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Unsetting OPTIMAL in rollback segments

2002-05-15 Thread Robert Pegram
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

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

2002-04-17 Thread Robert Pegram
. LK -Original Message- From: Robert Pegram [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Subject:RE: Locally managed tablespaces/What a DBA can do ? What about your locally managed temporary

Re: Insert append generating redo

2002-04-09 Thread Robert Pegram
://taxes.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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

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: 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] wrote

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 me the syntax to execute an inline SQL session so

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 an attachment .does anyone

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 Singh

Re: Oracle shadow process

2002-01-30 Thread Robert Pegram
: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: Recovery scenario query

2002-01-10 Thread Robert Pegram
!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- 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: (858) 538-5051 San Diego, California-- Public

Re: Export via pipe ksh script

2002-01-03 Thread Robert Pegram
__ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.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: range checking ??? URGENT

2001-11-14 Thread Robert Pegram
for other information (like subscribing). __ 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

RE: Unable to rebuild database from hot backup

2001-10-26 Thread Robert Pegram
connection 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: (858) 538-5051 San Diego, California-- Public Internet access

RE: Unable to rebuild database from hot backup

2001-10-26 Thread Robert Pegram
ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists