RE: Oracle Version on Unix

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: methodology to keep only certain programs to connect to

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 Parner Network

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: working with datafile > 2Gb in HadHat 7.3

------- 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

Another Transferring data from one table to another fast Q

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: Foxbase to Oracle

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

dblink / global names explanation please

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: Forms Question

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

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

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: (Fwd) Re: Upgrading from Forms 5, Oracle 7

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: (Fwd) Re: Upgrading from Forms 5, Oracle 7

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: Slow select distinct

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:

RE: RE: Slow select distinct

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

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

Slow select distinct

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

Clob, toad, and a trigger not working

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

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

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 ---

Execution plan optimizer Question

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: User_product_profile and sqlplusw

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

RE: User_product_profile and sqlplusw

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

Is it possible to remove default (TOAD users)

-- 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: migrate from 8i to 9i

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/ -

Another partitioning question part 2

; 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: Another partitioning question

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

) 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: Partitioning question

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

Partitioning question

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: Cost vs Rule

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

RE: Cost vs Rule

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

alter index rebuild online

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

RE: LIKE and % operator

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

RE: How's the job market?

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: Re[2]: address parse

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: address parse

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

address parse

Title: RE: UWIN and Oracle Anybody already have an address string parser (plsql) already written that they would care to share?  

RE: Weird ODBC Issue

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

RE: HOW TO KNOW INDEX NOT IN USE?

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.

OEM question

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: SCOTT/TIGER

- 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

Going to Cost

://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