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
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
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
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
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:
://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
-
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
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
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.
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
Title: RE: UWIN and Oracle
Anybody already have an address string parser (plsql)
already written that they would care to share?
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
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
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
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
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
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
-------
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
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
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
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
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:
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:
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]>
>
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
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
---
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
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
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
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.
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
) 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
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
; 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
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/
-
--
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
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
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
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
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
---
40 matches
Mail list logo