Clob, toad, and a trigger not working

2002-04-25 Thread Shaw John-P55297
urs from third party stuff and not from sqlplus - or better yet a work around? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

Slow select distinct

2002-04-29 Thread Shaw John-P55297
27; '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL -- Please see the official

RE: Slow select distinct

2002-04-30 Thread Shaw John-P55297
seems to go back to the sort on the 9500 rows being returned. -Original Message- Sent: Monday, April 29, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Shaw John-P55297 wrote: > > I got a query that selects a list of addresses based an occurence at that > location. > t

RE: RE: Slow select distinct

2002-04-30 Thread Shaw John-P55297
Thanks for the idea - however the alternative you suggested actually ran slower. It's seems to be the size of the distinct sort. -Original Message- Sent: Tuesday, April 30, 2002 9:59 AM To: Multiple recipients of list ORACLE-L >- Original Message - >From: Shaw

RE: Slow select distinct

2002-04-30 Thread Shaw John-P55297
AME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Going to Cost

2002-01-22 Thread Shaw John-P55297
://www.orafaq.com -- Author: Shaw John-P55297 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

RE: SCOTT/TIGER

2002-01-24 Thread Shaw John-P55297
- 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 r

OEM question

2002-01-30 Thread Shaw John-P55297
do to see this other instance with enterprise manager? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: HOW TO KNOW INDEX NOT IN USE?

2002-02-05 Thread Shaw John-P55297
Title: RE: HOW TO KNOW INDEX NOT IN USE? I can get it. -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 05, 2002 11:21 AMTo: Multiple recipients of list ORACLE-LSubject: RE: HOW TO KNOW INDEX NOT IN USE? Nope.  Same behavior for me.

RE: Weird ODBC Issue

2002-02-18 Thread Shaw John-P55297
LE-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: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services

address parse

2002-02-26 Thread Shaw John-P55297
Title: RE: UWIN and Oracle Anybody already have an address string parser (plsql) already written that they would care to share?  

RE: address parse

2002-02-26 Thread Shaw John-P55297
ay also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Re[2]: address parse

2002-02-26 Thread Shaw John-P55297
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public In

RE: How's the job market?

2002-03-01 Thread Shaw John-P55297
istGuru') 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: Shaw J

RE: LIKE and % operator

2002-03-04 Thread Shaw John-P55297
m). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

alter index rebuild online

2002-03-05 Thread Shaw John-P55297
I'm still back on 8.1.6 and when I tried to use 'alter index rebuild online' I got corrupted indexes. I saw on metalink that it's supposed to be fixed by 8.1.7.1 - anybody using successfully now? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sha

Another Transferring data from one table to another fast Q

2002-08-13 Thread Shaw John-P55297
Title: RE: Transferring data from one table to another How about if your table has (I didn't do it) a LONG column. CTAS doesn't work and I don't see the nologging option for the ccopy command - in 8.1.6 anyway. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTE

RE: working with datafile > 2Gb in HadHat 7.3

2002-08-30 Thread Shaw John-P55297
------- 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 rem

RE: Oracle Parner Network

2002-08-30 Thread Shaw John-P55297
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: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Ne

RE: methodology to keep only certain programs to connect to

2002-09-10 Thread Shaw John-P55297
use v_$mystat - it has the sid - then do your join with v$session -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 10:58 AMTo: Multiple recipients of list ORACLE-LSubject: methodology to keep only certain programs to connect to

RE: Oracle Version on Unix

2002-09-11 Thread Shaw John-P55297
OTECTED] 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, send an E-Mail message to: [EM

RE: (Fwd) Re: Upgrading from Forms 5, Oracle 7

2002-06-21 Thread Shaw John-P55297
ET: [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, send an E-Mail message to:

RE: (Fwd) Re: Upgrading from Forms 5, Oracle 7

2002-06-24 Thread Shaw John-P55297
e database? "personal", "standard", "enterprise", etc??? On 21 Jun 2002 at 5:23, Shaw John-P55297 wrote: Date sent: Fri, 21 Jun 2002 05:23:20 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Send reply to:

RE: database 9iR2 and client-server with Forms 6i / RE: (Fwd) Re:

2002-06-24 Thread Shaw John-P55297
the same manner as a user would (in other words, not in "developer" mode)? Thanks, Eric On 24 Jun 2002 at 6:08, Shaw John-P55297 wrote: Date sent: Mon, 24 Jun 2002 06:08:28 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >

RE: Forms Question

2002-06-27 Thread Shaw John-P55297
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: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

dblink / global names explanation please

2002-06-29 Thread Shaw John-P55297
ficial ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---

RE: Foxbase to Oracle

2002-07-30 Thread Shaw John-P55297
y also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

RE: Cost vs Rule

2002-03-07 Thread Shaw John-P55297
nd for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

RE: Cost vs Rule

2002-03-07 Thread Shaw John-P55297
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: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cal

Partitioning question

2002-03-14 Thread Shaw John-P55297
application is still rule based is there any value to partitioning? Some of the tables are over 30 million rows and 5G. If my understanding is correct I wouldn't see any performance improvement but would make maintenance simpler. -- Please see the official ORACLE-L FAQ: http://www.orafaq.

RE: Partitioning question

2002-03-14 Thread Shaw John-P55297
goes south. I prefer to set the database to 'choose' mode which allows the best of both worlds. Dick Goulet Reply Separator____ Author: Shaw John-P55297 <[EMAIL PROTECTED]> Date: 3/14/2002 9:33 AM I am new to the world of partitioning. 8

Another partitioning question

2002-03-15 Thread Shaw John-P55297
) and owner_table !='X' tablespace test; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acces

RE: Another partitioning question

2002-03-18 Thread Shaw John-P55297
ition p5 values less than (100000) and owner_table ='X' tablespace test) partition p6 values less that (10) and owner_table !='X' tablespace test; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat Ci

Another partitioning question part 2

2002-03-18 Thread Shaw John-P55297
; tablespace test, partition p2 values less than (5000) and owner_table ='X' tablespace test, partition p3 values less than (10000) and owner_table ='X' tablespace test, partition p4 values less than (5) and owner_table ='X' tablespace test, partiti

RE: migrate from 8i to 9i

2002-04-11 Thread Shaw John-P55297
LE-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 filing with TurboTax http://taxes.yahoo.com/ -

Is it possible to remove default (TOAD users)

2002-04-12 Thread Shaw John-P55297
-- Author: Shaw John-P55297 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

RE: User_product_profile and sqlplusw

2002-04-15 Thread Shaw John-P55297
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: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services

RE: User_product_profile and sqlplusw

2002-04-16 Thread Shaw John-P55297
rom product_user_profile; 1 row deleted. SQL> commit; Commit complete. SQL> insert into test (aa,bb) values ('A',1); 1 row created. SQL> -Original Message- Sent: Tuesday, April 16, 2002 7:53 AM To: Multiple recipients of list ORACLE-L Thanks but that does not wo

Execution plan optimizer Question

2002-04-22 Thread Shaw John-P55297
I am starting out with a small test database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Any issues with Developer 6i running against Oracle 9i

2002-04-23 Thread Shaw John-P55297
l ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---