RE: How Oracle screwed California

2002-04-29 Thread MacGregor, Ian A.
r 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Licences for testing

2002-05-03 Thread MacGregor, Ian A.
essage 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 off

RE: Reverse Key Index Performance

2002-05-06 Thread MacGregor, Ian A.
e 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Ne

RE: Transactions per second

2002-05-09 Thread MacGregor, Ian A.
st how to get the size of the TPS and also how I can test for the number of Transaction per second. We are using a 3 tier architecture, Java client. EJB and Oracle 9i. I would be very useful if some help is available in this regards Regards Prem Chandran N &quo

RE: WAITS

2002-05-09 Thread MacGregor, Ian A.
ODY, 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: MacGregor, Ian A. INET: [EMAIL PROTECT

RE: Create synonyms in externally authenticated user's schema

2002-05-13 Thread MacGregor, Ian A.
Title: Create synonyms in externally authenticated user's schema If you have the proper privilege,       create synonym . for .;   Be warned, Oracle's OS authentication is extremely easy to spoof.   Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original

RE: Compressing Export Dumps|

2002-05-16 Thread MacGregor, Ian A.
;) 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: MacGregor, Ian

RE: Dedicated Server versus Shared Server

2002-05-16 Thread MacGregor, Ian A.
taining: 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Networ

RE: Wait Event "PX Deq: Execution Msg"

2002-05-16 Thread MacGregor, Ian A.
mmand for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mail

RE: Re[2]: SQLPlus was Oracle - "can you imagine" ;-)

2002-05-17 Thread MacGregor, Ian A.
essage 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 o

RE: SQLPlus was Oracle - "can you imagine" ;-)

2002-05-17 Thread MacGregor, Ian A.
: Multiple recipients of list ORACLE-L "MacGregor, Ian A." wrote: > > I believe, fifteen years ago, it had already changed to SQL>. Yes. Dates from Oracle5, 17 years ago. > I'm also pretty sure that iag/iap had also already been introduced. OCI was >definitely t

RE: What makes Export slow ?

2002-05-20 Thread MacGregor, Ian A.
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 othe

RE: ORA_ENCRYPT_LOGIN

2002-05-21 Thread MacGregor, Ian A.
Title: SQL Server to Oracle DB Even without this parameter being set the password is encrypted.  What the parameter does is stop the password from being sent in the clear if logging in with the encrypted password fails.   I believe the encryption is a 54-bit  variant of DES.  It is very rar

RE: Data Warehouse experts, a simple question for you| Outdated?

2002-05-21 Thread MacGregor, Ian A.
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).

Oracle 9i and Tables Owned by SYS

2002-05-21 Thread MacGregor, Ian A.
ny idea on the SYS tables? Must they be granted individually? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Oracle 9i and Tables Owned by SYS

2002-05-22 Thread MacGregor, Ian A.
in 2 sys.dbms_space.unused_space('SYS','PARTLOB$','TABLE', 3 :a1, :a2, :a3, :a4, :a5, :a6, :a7 ); 4 end; 5 / PL/SQL procedure successfully completed. hth Connor --- "MacGregor, Ian A." <[EMAIL PROTECTED]> wrote: > I am in the process of

RE: ORA_ENCRYPT_LOGIN

2002-05-22 Thread MacGregor, Ian A.
l having developers connect to the production box via SQL*Plus client on developer workstations, so that the password is not sent in the clear?   -----Original Message-From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 21, 2002 8:18 PMTo: Mu

RE: Oracle 9i and Tables Owned by SYS

2002-05-22 Thread MacGregor, Ian A.
y? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Data Warehouse experts, a simple question for you

2002-05-22 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-50

RE: Statistical sampling and representative stats collection

2002-05-22 Thread MacGregor, Ian A.
sage > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > === message truncated === __ Do You Ya

RE: Statistical sampling and representative stats collection

2002-05-24 Thread MacGregor, Ian A.
D] (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://

RE: Statistical sampling and representative stats collection

2002-05-29 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services

CLOBS AND Semicolons

2002-05-31 Thread MacGregor, Ian A.
nt_info_temp which is a global temporary table built with "on commit" preserve rows to a permanent location. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ia

RE: INDEX move

2002-06-05 Thread MacGregor, Ian A.
ou 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Wrong Results Bug in Oracle 8.1.7.1

2002-06-08 Thread MacGregor, Ian A.
r_id from the view with the 'voucher_id = ' predicate the other fields are projected correctly, but returns voucher_id as null. === Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.c

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-09 Thread MacGregor, Ian A.
Yep sure is. Ian -Original Message- Sent: Sunday, June 09, 2002 5:43 AM To: Multiple recipients of list ORACLE-L Ian, is that peopleslop? joe MacGregor, Ian A. wrote: >SQL> SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE ROWNUM < 10; > >VOUCHER_ > &

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-09 Thread MacGregor, Ian A.
It's failing in development and working in production. Ian -Original Message- Sent: Sunday, June 09, 2002 7:13 PM To: Multiple recipients of list ORACLE-L what modules, if you dont mind me asking, i'm at a site where we're going to implement HR, Financials And EPM soon. thanks,

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-10 Thread MacGregor, Ian A.
ponte -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: Wrong Results Bug in Oracle 8.1.7.1 Accounts payable.  But this is not a Peoplesoft problem, but an Oracle on

RE: ldap info

2002-06-11 Thread MacGregor, Ian A.
st 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Books24X7.com (Electronic Books)

2001-08-08 Thread MacGregor, Ian A.
r how much RPG could possibly be out there? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 S

RE: X$_kglcursor.kglnaobj

2001-08-13 Thread MacGregor, Ian A.
Since each one of this sid has this object pinned, I think, you have objects with these names in your database. Does your database have these objects ? ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2 technologies   www.i2.com "MacGregor,

RE: OT - Vaccines

2001-08-16 Thread MacGregor, Ian A.
DY, 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: MacGregor, Ian A. INET: [EMAIL PROT

RE: OT - Vaccines

2001-08-17 Thread MacGregor, Ian A.
[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

RE: OT - Vaccines

2001-08-17 Thread MacGregor, Ian A.
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

RE: hash join order

2001-08-23 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] F

RE: !! *Very* important Oracle-L message !!

2001-08-29 Thread MacGregor, Ian A.
s 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 subscrib

RE: PeopleSoft8 Oddities

2001-08-29 Thread MacGregor, Ian A.
ng 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (

An Interesting Grouping Question

2001-08-30 Thread MacGregor, Ian A.
relational one. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: An Interesting Grouping Question

2001-08-30 Thread MacGregor, Ian A.
Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: An Interesting Grouping Question | One Solution

2001-08-31 Thread MacGregor, Ian A.
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 remo

RE: An Interesting Grouping Question | One Solution

2001-08-31 Thread MacGregor, Ian A.
ssage- Sent: Friday, August 31, 2001 1:08 PM To: [EMAIL PROTECTED] Cc: MacGregor, Ian A. Ian, You just had to throw down the gauntlet, didn't you? :) Here's my solution. You may consider it cheating, as I've done pretty much what your developer came up with, but I used a s

RE: An Interesting Grouping Question

2001-09-04 Thread MacGregor, Ian A.
--- 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

File Upload and Download via IAS

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

RE: File Upload and Download via IAS

2001-09-05 Thread MacGregor, Ian A.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Do fast full index scans do physical disk reads?

2001-09-06 Thread MacGregor, Ian A.
he HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

White Space in Commands.

2001-09-07 Thread MacGregor, Ian A.
ROR at line 1: ORA-01434: private synonym to be dropped does not exist One learns something new every day. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] F

RE: dbms_jobs

2001-09-07 Thread MacGregor, Ian A.
ficial ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To RE

RE: Do fast full index scans do physical disk reads?

2001-09-07 Thread MacGregor, Ian A.
7;t part of the index? Thanks for your reply, Cherie "MacGregor,

RE: Do fast full index scans do physical disk reads?

2001-09-10 Thread MacGregor, Ian A.
ing those physical reads? Or, in the case where the index isn't cached, is the benefit that you don't have to read all of the columns in the table that aren't part of the index? Thanks for your reply, Cherie "MacGregor, Ian A."

RE: Do fast full index scans do physical disk reads?

2001-09-10 Thread MacGregor, Ian A.
ndexes or can you do it on non-unique multi-column indexes as well? Thanks, Cherie "MacGregor, Ian A." To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc:

RE: Last time an Index was used..

2001-09-10 Thread MacGregor, Ian A.
- 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

RE: Do fast full index scans do physical disk reads?

2001-09-10 Thread MacGregor, Ian A.
September 10, 2001 5:50 AM To: Multiple recipients of list ORACLE-L Ian, I'll look at compressing the index. Does that only work on unique indexes or can you do it on non-unique multi-column indexes as well? Thanks, Cherie "MacGregor,

RE: Do fast full index scans do physical disk reads?

2001-09-10 Thread MacGregor, Ian A.
001 5:50 AM To: Multiple recipients of list ORACLE-L Ian, I'll look at compressing the index. Does that only work on unique indexes or can you do it on non-unique multi-column indexes as well? Thanks, Cherie "MacGregor, Ian A."

RE: Oracle, security & the USAF?

2001-09-10 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Net

RE: Do fast full index scans do physical disk reads?

2001-09-10 Thread MacGregor, Ian A.
, 2001 3:36 PM To: MacGregor, Ian A.; 'Multiple recipients of list ORACLE-L ' I resent the self-touting, the email you are probably refering to was a sarcastic one of someone (I believe Mark's) email. I am actually fairly humble for the most part. Although I tend to be quite sar

RE: Your views on Quest - Shareplex

2001-05-29 Thread MacGregor, Ian A.
end 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). -- P

RE: Your views on Quest - Shareplex

2001-05-30 Thread MacGregor, Ian A.
:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 11:07 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Your views on Quest - Shareplex > -Original Message- > From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] > > We are looking into the product as well, but

Recovery Manager (RMAN)

2001-06-05 Thread MacGregor, Ian A.
EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Recording Destructive DDL

2001-06-05 Thread MacGregor, Ian A.
Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

RE: Recording Destructive DDL

2001-06-06 Thread MacGregor, Ian A.
this function? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San D

RE: NEW TIME ZONE

2001-06-06 Thread MacGregor, Ian A.
om 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 (

Veritas Quick I/0 and Oracle/ Asycnchronous I/O

2001-06-08 Thread MacGregor, Ian A.
ECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: SID on sqlplus prompt?

2001-06-09 Thread MacGregor, Ian A.
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

RE: Dedicated connections on MTS server

2001-06-09 Thread MacGregor, Ian A.
#x27;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

Recording Destructive SQL Trapping "Alter Table Drop Column" So

2001-06-11 Thread MacGregor, Ian A.
AM To: Multiple recipients of list ORACLE-L You are getting current SQL but you need to go thru all SQL for this session to find out if there was alter table drop (column). Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL P

RE: Current Osuser

2001-06-11 Thread MacGregor, Ian A.
Title: Current Osuser  select sys_context('USERENV', 'OS_USER') FROM DUAL;   Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Monday, June 11, 2001 2:26 PMTo: Multiple recipients of list

RE: how to substr '%' from the data?

2001-06-11 Thread MacGregor, Ian A.
By using the instr function.   Here is an example.  N.B., the  space between the  words "and"  and "seven" is returned.         select substr('Four score and seven years ago',1,   instr('Four score and seven years ago', 'seven') -1)  from dual   SUBSTR('FOURSCO---Four score and

CORRECTION To: Destructive SQL Trapping "Alter Table Drop Column"

2001-06-12 Thread MacGregor, Ian A.
object_security.record_destructive_ddl (x.column_name); end if; end loop; else ... Is it a performance thing? Is it faster to retrieve the SQL all the time and only check for dropped columns when you have to? And Is that also the reason f

RE: Digestive DBA Special

2001-06-12 Thread MacGregor, Ian A.
Title: RE: Digestive DBA Special The wearing of the red shirt to  hide a bloody wound  is usually said of  Admiral Nelson.  The wearing of brown pants  to hide a panicked bowel reaction is not.   Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED]  -Original Message

RE: logminer in the 9i world, etc

2001-06-12 Thread MacGregor, Ian A.
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

RE: getting recursive error, any ideas?

2001-06-12 Thread MacGregor, Ian A.
essage 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: MacGregor, Ian A. INET: [EMAIL

RE: Call Stored procedure from another Stored procedure.

2001-06-13 Thread MacGregor, Ian A.
ttp://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourse

RE: Call Stored procedure from another Stored procedure.

2001-06-13 Thread MacGregor, Ian A.
nt 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Dieg

RE: OT RE: Digestive DBA special

2001-06-13 Thread MacGregor, Ian A.
her information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet a

RE: HELP !!! scrpt works with sql plus but not in a procedure

2001-06-13 Thread MacGregor, Ian A.
lf 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

Ora-1031 (Insufficient Privileges) Inserting BLOB Data With Perl

2001-11-20 Thread MacGregor, Ian A.
for bind variables in Perl. Ian MacGregor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

2001-11-20 Thread MacGregor, Ian A.
dated, updated_by, content_type, content_disposition ) VALUES ( ?, ?, ?, ?, ?, ?, ?, SYSDATE, ?, SYSDATE, ?, ?, ? ) > > The question marks are place-holders for bind variables in Perl. > > > Ian MacGregor > > > > > -- > Please see the official ORACLE-L FA

RE: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

2001-11-20 Thread MacGregor, Ian A.
?, ?, ?, ?, ?, ?, SYSDATE, ?, SYSDATE, ?, ?, ? ) > > The question marks are place-holders for bind variables in Perl. > > > Ian MacGregor > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: MacGregor, Ia

RE: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

2001-11-20 Thread MacGregor, Ian A.
bind variables in Perl. Ian MacGregor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: A problem

2001-11-26 Thread MacGregor, Ian A.
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

RE: Altering Indexes

2001-11-27 Thread MacGregor, Ian A.
'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

RE: Buffer Busy Waits -- Sanity check please

2001-12-01 Thread MacGregor, Ian A.
rk Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ------------ To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling o

RE: Embedding perl in Oracle

2001-12-05 Thread MacGregor, Ian A.
ic 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 message BODY, include a line containing: UNSU

How Many Processes are Performing Simultaneous DML on A Table?

2001-12-20 Thread MacGregor, Ian A.
-- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

RE: Little OT: CLOB, Oracle Text, and ADO

2001-12-21 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: Little OT: CLOB, Oracle Text, and ADO

2001-12-21 Thread MacGregor, Ian A.
age 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 off

Where Does the Java Run in IFS

2001-12-27 Thread MacGregor, Ian A.
uthor: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, se

ALTER TABLE MOVE LOB ... Watch Out !!!!

2002-01-04 Thread MacGregor, Ian A.
t, and moved the 7 good records back in. I had never seen Oracle corrupt a table so, and hope to never again!! Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] F

RE: How to calculate user load on the system

2002-01-16 Thread MacGregor, Ian A.
CLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To

RE: How to calculate user load on the system

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

RE: Access to Oracle

2002-01-24 Thread MacGregor, Ian A.
like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Function In Select Statment

2002-01-29 Thread MacGregor, Ian A.
and for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: can sharepool error cause sna to go down?

2002-01-30 Thread MacGregor, Ian A.
ike subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Migration errors

2002-01-30 Thread MacGregor, Ian A.
ACLE-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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: how to remove java from 8.1.6

2002-01-30 Thread MacGregor, Ian A.
he 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: is it f*ing f*day yet? / ORACLE-L Digest -- Volume 2002,

2002-02-01 Thread MacGregor, Ian A.
ibing). __________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Servic

RE: Oracle remote compromise./ Why Not Run The External procedure

2002-02-08 Thread MacGregor, Ian A.
about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: ORA-00600 errors

2002-02-28 Thread MacGregor, Ian A.
: 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat C

RE: "Does anybody really know what time it is?"

2002-03-01 Thread MacGregor, Ian A.
moved 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: FW: Expiration of your subscription to the ORACLE-L list

2002-03-01 Thread MacGregor, Ian A.
XACT 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.ora

  1   2   3   4   5   >