Re: Renumber a set of grupped rows?

2004-01-20 Thread Mark Richard
to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services

Re: Renumber a set of grupped rows?

2004-01-20 Thread Mark Richard
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Spool to Excel File

2004-01-19 Thread Mark Richard
Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: alter table rename error

2004-01-15 Thread Mark Richard
Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: alter table rename error

2004-01-15 Thread Mark Richard
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: kill session privilage

2004-01-14 Thread Mark Richard
and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Application Server Caching

2004-01-14 Thread Mark Richard
Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Application Server Caching

2004-01-14 Thread Mark Richard
. Mark Richard [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ban.com.au cc

Re: sql question

2004-01-12 Thread Mark Richard
b21tYW5kIGZvciBvdGhlciBpbmZvcm1hdGlvbiAobGlrZSBzdWJzY3JpYmluZykuDQoNCg== --{56703FBA-6707-4823-B54F-C1F79FFDC9D6}-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: A STRANGE QUERY

2004-01-12 Thread Mark Richard
in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard

Re: sql question (RESEND)

2004-01-12 Thread Mark Richard
-- Author: Mark Richard 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 yourself from this mailing list

RE: Export / Import Question

2004-01-11 Thread Mark Richard
Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Export / Import Question

2004-01-11 Thread Mark Richard
large company that can spare the expense. Jared On Sun, 2004-01-11 at 13:44, Mark Richard wrote: Hi Ron, If it's going to be an ongoing occurance you might want to consider Princeton Softech's Relational Tools for Servers suite. In particular, the Move for Servers product. I use

RE: Should we stop analyzing?

2003-12-30 Thread Mark Richard
as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: 24 x 7 x 365

2003-12-10 Thread Mark Richard
ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Help on tkprof output

2003-12-02 Thread Mark Richard
and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: insert and commit 1000 records at a time

2003-10-16 Thread Mark Richard
to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network

Re: Analyze - For All option

2003-10-16 Thread Mark Richard
: Mark Richard 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 yourself from this mailing list, send an E

Re: Resource for index

2003-10-14 Thread Mark Richard
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: question about ordering in a table

2003-10-14 Thread Mark Richard
be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Data Modelling Tools for a DBAs Job

2003-10-13 Thread Mark Richard
to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network

Re: Populating BLOB's from a SQL Script? - Solution

2003-10-08 Thread Mark Richard
. Mark Richard [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL

Populating BLOB's from a SQL Script?

2003-10-06 Thread Mark Richard
that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL

Re: Seems odd to me....(bug?)

2003-10-02 Thread Mark Richard
and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: RE: Create Table..As Select: Number formats

2003-10-02 Thread Mark Richard
://www.orafaq.net -- Author: Mark Richard 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 yourself from

RE: Using dimensions

2003-09-29 Thread Mark Richard
as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: minus vs. where not exists, vs. where not in

2003-09-21 Thread Mark Richard
to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City

RE: minus vs. where not exists, vs. where not in

2003-09-21 Thread Mark Richard
. On 2003.09.21 19:54, Mark Richard wrote: I don't have any scientific proof but I imagine the sort_area_size could be different between not exists and minus. When doing minus the entire select string would have to be compared for equality, which could be very large depending on your string. Minus

Re: Oracle's use of Indexes

2003-09-18 Thread Mark Richard
: http://www.orafaq.net -- Author: Mark Richard 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 yourself

Re: tunning an index built

2003-09-18 Thread Mark Richard
endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Re: SQL help needed

2003-09-17 Thread Mark Richard
- --- Original Message --- - From: Mark Richard [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tue, 16

Re: SQL help needed

2003-09-16 Thread Mark Richard
to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services

Re: SQL help needed

2003-09-16 Thread Mark Richard
. Mark Richard [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L

Parallel index read without alter index... ?

2003-09-07 Thread Mark Richard
not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED

Re: EXECUTE IMMEDIATE and PL/SQL variables - SOLVED

2003-09-04 Thread Mark Richard
' INTO n_count; dbms_output.put_line('Number is '||n_count); END; / Mark Richard

EXECUTE IMMEDIATE and PL/SQL variables???

2003-09-03 Thread Mark Richard
to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City

LONG RAW versus BLOB performance

2003-08-27 Thread Mark Richard
Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Analytical Functions

2003-08-14 Thread Mark Richard
to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network

Re: stats and query plans

2003-08-14 Thread Mark Richard
of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: Tuning ideas requested

2003-08-14 Thread Mark Richard
://www.orafaq.net -- Author: Mark Richard 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

Tuning ideas requested

2003-08-05 Thread Mark Richard
in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET

RE: drop user

2003-08-04 Thread Mark Richard
: http://www.orafaq.net -- Author: Mark Richard 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 yourself

Re: read only tablespace

2003-07-31 Thread Mark Richard
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: data is skewed - what does it mean ?

2003-07-25 Thread Mark Richard
be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Union quries: INTERSECT, MINUS, etc

2003-07-24 Thread Mark Richard
by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Find the table's name that using sequences

2003-07-16 Thread Mark Richard
EAEeAAgQAQAAAGUAAABXRUxMLFRIRVJFQ09VTERCRUJVU0lORVNTTE9HSUNSRUFTT05TQVNU T1dIWVlPVVdPVUxESEFWRU9ORVNFUVVFTkNFUEVSVEFCTEVBTFNPLElET05US05PV0lGSVdPVUxE RVZFAA13 --0__=C5BBE7F6DF123FE48f9e8a93df938690918cC5BBE7F6DF123FE4-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat

Re: Query tuning stumper

2003-07-15 Thread Mark Richard
by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: security without using different usernames

2003-07-15 Thread Mark Richard
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Transparent database objects after merging

2003-07-15 Thread Mark Richard
to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network

Re: Commit 1000 at a time, thats what I ended up doing

2003-07-09 Thread Mark Richard
to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City

Re: update about 100K records

2003-07-08 Thread Mark Richard
not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat

Re: update about 100K records

2003-07-08 Thread Mark Richard
Ryan's method is pretty hi-tech for me, and he is flying above the clouds and does not want to get down to poor little me, even after the inviation... :-) But this one here, --- Mark Richard [EMAIL

Re: something appears to be funny with ROWNUM

2003-07-08 Thread Mark Richard
://www.orafaq.net -- Author: Mark Richard 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 yourself from

Re: something appears to be funny with ROWNUM

2003-07-08 Thread Mark Richard
- better than my attempt. Mark Richard

Re: concatenated index

2003-07-07 Thread Mark Richard
be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: concatenated index

2003-07-07 Thread Mark Richard
specified the hint. It still seems to be using the index. Thanks in advance Novice No more Oracle certifiable DBA From: Mark Richard [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: concatenated index Date: Mon, 07 Jul 2003 20:09:24

Re: Index question

2003-06-25 Thread Mark Richard
as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: SELECT Output Default Ordering ?

2003-06-25 Thread Mark Richard
that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network

Re: OR Vs UNION

2003-06-24 Thread Mark Richard
shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Index question

2003-06-24 Thread Mark Richard
as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: MS Access as a front-end to Oracle DB

2003-06-22 Thread Mark Richard
not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services

Re: Partitions of table read only

2003-06-19 Thread Mark Richard
://www.orafaq.net -- Author: Mark Richard 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 yourself from

RE: Re: Opinions of high-volume DDL and data population

2003-06-16 Thread Mark Richard
Raj, Thanks, however adding the attribute to this table is the correct thing to do - it's a historical table to supply show me something as at x date/time for the particular record. Basically when originally created (years before my time) someone assumed that a record would never be updated

RE: Opinions of high-volume DDL and data population

2003-06-16 Thread Mark Richard
a redesign spinning out a few new tables, the volumes involved absolutely collapsed. Nice surprise! peter -Original Message- From: Mark Richard [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 07:24 To: Multiple recipients of list ORACLE-L Subject: Opinions of high-volume DDL and data

RE: Re: Opinions of high-volume DDL and data population

2003-06-16 Thread Mark Richard
You should also rebuild the table afterwards because after adding a new column, you'll have plenty of chained rows which are, as you are probably aware, very bad thing indeed for application performance. Rebuild is done by using alter table move. On 2003.06.16 02:24, Mark Richard wrote: Hi List

RE: db file sequential read [WAS:wait event puzzler] - getting silly

2003-06-15 Thread Mark Richard
as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Opinions of high-volume DDL and data population

2003-06-15 Thread Mark Richard
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: How to put a TOP 1 in a select

2003-06-11 Thread Mark Richard
-- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: applying transactions

2003-06-11 Thread Mark Richard
-- Author: Mark Richard 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 yourself from this mailing list

RE: How to put a TOP 1 in a select

2003-06-10 Thread Mark Richard
in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET

Re: sql query optimization

2003-06-10 Thread Mark Richard
: http://www.orafaq.net -- Author: Mark Richard 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 yourself

Re: Oracle 9i vs SQL Server

2003-06-10 Thread Mark Richard
shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: How to put a TOP 1 in a select

2003-06-10 Thread Mark Richard
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: sql query optimization

2003-06-10 Thread Mark Richard
to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: How to put a TOP 1 in a select

2003-06-09 Thread Mark Richard
that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City

Re: Create index script in pl/sql

2003-06-06 Thread Mark Richard
be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: Re[2]: performance questions

2003-06-05 Thread Mark Richard
business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: performance questions

2003-06-04 Thread Mark Richard
Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: performance questions

2003-06-04 Thread Mark Richard
do we renegotiate SLA? or how do we get a new value for SLA? thanks sai --- Mark Richard [EMAIL PROTECTED] wrote: I agree totally... Adding more databases to a server doesn't invalidate a negotiated SLA. If you can't meet the SLA then someone has a problem. Perhaps tuning is required

Re: SQL Query Help

2003-05-29 Thread Mark Richard
of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Alternative way to write delete query

2003-05-27 Thread Mark Richard
information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard

RE: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Mark Richard
that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network

Re: oracle full table scan

2003-04-02 Thread Mark Richard
shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: How to use small oracle database in my program

2003-04-01 Thread Mark Richard
be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Best Practise for exception handling in PL/SQL

2003-03-24 Thread Mark Richard
be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Explain Plan vs Actual Execution Plan

2003-03-23 Thread Mark Richard
information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET

RE: Force to use a tablespace

2003-03-19 Thread Mark Richard
shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Ab Initio, Unix Scripting, and Datawarehousing

2003-03-19 Thread Mark Richard
of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Comparing strings whilst ignoring some characters

2003-03-16 Thread Mark Richard
to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Excessive SQL*Net message from client waits

2003-03-13 Thread Mark Richard
by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Excessive SQL*Net message from client waits

2003-03-13 Thread Mark Richard
Please ignore my silly comments about 3000 queries. My brain is waking up and realising that 3000 is the number of SQL*Net messages. In essence, ignore my message and listen to Jonathan. - Forwarded by Mark Richard/TRANSURBAN on 14/03/2003 09:56

Re: Slow running jobs

2003-03-11 Thread Mark Richard
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle position on hints

2003-03-10 Thread Mark Richard
of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Oracle position on hints (talking about bind variables)

2003-03-10 Thread Mark Richard
of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Character Set / Encrypted text question

2003-03-05 Thread Mark Richard
shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: What to check?

2003-03-03 Thread Mark Richard
to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: What to check?

2003-03-02 Thread Mark Richard
of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Purely for your amusement

2003-02-27 Thread Mark Richard
: Mark Richard 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 yourself from this mailing list, send

Re: update 30mil rows

2003-02-25 Thread Mark Richard
given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Select Statement Gone South??

2003-02-25 Thread Mark Richard
to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858

  1   2   >