Patch to 9.2.0.4

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

RE: Patch to 9.2.0.4

2003-12-05 Thread Robertson Lee - lerobe
Hmmm, ignore my post. For an unconnected reason we had to reboot the server and I can start the instance no problems. -Original Message- Robertson Lee - lerobe Sent: 05 December 2003 14:30 To: Multiple recipients of list ORACLE-L Hi Oracle 9.2.0.3 AIX 5L anyone fail to start

RE: Oracle 9i physical IO - why only one block reads

2003-12-01 Thread Robertson Lee - lerobe
--_=_NextPart_001_01C3B825.DE0C531A-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Happy Thanksgiving

2003-11-26 Thread Robertson Lee - lerobe
or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Happy Thanksgiving

2003-11-26 Thread Robertson Lee - lerobe
prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe

RE: UNIX OT: exclude files in tar

2003-11-25 Thread Robertson Lee - lerobe
: http://www.orafaq.net -- Author: Robertson Lee - lerobe 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

RE: RAC listserv

2003-11-13 Thread Robertson Lee - lerobe
this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network

RE: OT (DB2)

2003-11-12 Thread Robertson Lee - lerobe
Many thanks. I am back on again. Regards Lee -Original Message- Sent: 11 November 2003 21:59 To: Multiple recipients of list ORACLE-L -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 November 2003 00:45 To: Multiple recipients

RE: bug info, not displayed!!

2003-11-12 Thread Robertson Lee - lerobe
-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

OT (DB2)

2003-11-11 Thread Robertson Lee - lerobe
have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED

RE: Oracle Error

2003-11-11 Thread Robertson Lee - lerobe
-- Author: Robertson Lee - lerobe 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

RE: ORA-27102: out of memory in Tru64

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

RE: Export Split Script (FAO LISA)

2003-10-30 Thread Robertson Lee - lerobe
the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: 2G trace files - solved...sort of

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

9i RAC on AIX 5L

2003-10-29 Thread Robertson Lee - lerobe
this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City

RE: Re: How to drop a datafile ?

2003-10-29 Thread Robertson Lee - lerobe
to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: 9i RAC on AIX 5L

2003-10-29 Thread Robertson Lee - lerobe
] sts://[EMAIL PROTECTED]/ Research is what I'm doing when I don't know what I'm doing. -- Wernher Von Braun (1912-1977) Robertson Lee - lerobe [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 29/10/2003 06:19 a.m. Please respond to ORACLE-L To:Multiple

RE: Oracle /db2

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

_DB_FILE_DIRECT_IO_COUNT

2003-10-21 Thread Robertson Lee - lerobe
to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Block size written

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

RE: _DB_FILE_DIRECT_IO_COUNT

2003-10-21 Thread Robertson Lee - lerobe
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Where can I download 10g ?

2003-10-17 Thread Robertson Lee - lerobe
received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED

RE: A quick note

2003-10-09 Thread Robertson Lee - lerobe
almost humanistic type responses (occasionally) John -Original Message- Robertson Lee - lerobe Sent: 08 October 2003 11:34 To: Multiple recipients of list ORACLE-L Hi everyone, I'm back in the land of the living after spending a year on a DB2 EEE project. I've just started working

RE: DB Parameters

2003-10-09 Thread Robertson Lee - lerobe
://www.orafaq.net -- Author: Robertson Lee - lerobe 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

A quick note

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

RE: A quick note

2003-10-08 Thread Robertson Lee - lerobe
examples and code cuts to demonstrate the point. The best part is that is that the machine is programmed to exibit almost humanistic type responses (occasionally) John -Original Message- Robertson Lee - lerobe Sent: 08 October 2003 11:34 To: Multiple recipients of list ORACLE-L Hi everyone

RE: svrmgrl echo v$database in script

2002-10-04 Thread Robertson Lee - lerobe
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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

2002-10-04 Thread Robertson Lee - lerobe
. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: svrmgrl echo v$database in script

2002-10-03 Thread Robertson Lee - lerobe
the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: datafile sizing question

2002-09-25 Thread Robertson Lee - lerobe
ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Best Practice - Partitioned object, one partition per tablesp

2002-09-25 Thread Robertson Lee - lerobe
ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Lost ofall redo logs

2002-09-20 Thread Robertson Lee - lerobe
You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

sql - ignoring index...

2002-09-20 Thread Robertson Lee - lerobe
and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Lost ofall redo logs

2002-09-19 Thread Robertson Lee - lerobe
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Moving data between tablespaces[Scanned]

2002-09-17 Thread Robertson Lee - lerobe
: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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

RE: Ioug meeting or HOTSOS Seminar

2002-09-12 Thread Robertson Lee - lerobe
this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network

RE: recovery question - I know I am missing something

2002-09-12 Thread Robertson Lee - lerobe
or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Ioug meeting or HOTSOS Seminar

2002-09-11 Thread Robertson Lee - lerobe
://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Ioug meeting or HOTSOS Seminar

2002-09-11 Thread Robertson Lee - lerobe
care to elaborate -Original Message- Sent: 11 September 2002 09:48 To: Multiple recipients of list ORACLE-L I think it depends on whose hand you have to shake as you enter the conference... (sorry - thats a little bit of an in joke) Cheers Connor --- Robertson Lee - lerobe

RE: Oracle on Win platforms

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

RE: Coercion issue

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

RE: Coercion issue

2002-09-04 Thread Robertson Lee - lerobe
this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network

RE: Letting users kill their own sessions

2002-08-30 Thread Robertson Lee - lerobe
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Patrice, I think I posted this not so long ago but I have this one and it works. Regards HTH Lee /***//* *//* Author: Lee Robertson *//* *//* Title: killsession.sql

RE: How to increase maxextents of ROLLBACK segment_type?

2002-08-28 Thread Robertson Lee - lerobe
I don't wantto sound too obvious but isn't the answer in the error message ?? . RTFMtime. As an aside, why do you need to extend your system rollback segment Lee -Original Message-From: Jonny Delmont [mailto:[EMAIL PROTECTED]]Sent: 28 August 2002 10:53To: Multiple recipients of

RE: utl_file_dir vs create directory

2002-08-22 Thread Robertson Lee - lerobe
have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL

RE: utl_file_dir vs create directory

2002-08-22 Thread Robertson Lee - lerobe
or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

FW: assistance

2002-08-22 Thread Robertson Lee - lerobe
. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Moving to UK - what are Oracle contracts like?

2002-08-16 Thread Robertson Lee - lerobe
this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network

RE: Simple favor from the guru's

2002-08-16 Thread Robertson Lee - lerobe
this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Moving to UK - what are Oracle contracts like?

2002-08-16 Thread Robertson Lee - lerobe
. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Newbie ?

2002-08-16 Thread Robertson Lee - lerobe
received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL

RE: RE: PL/SQL Editor.

2002-08-15 Thread Robertson Lee - lerobe
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Newbie ?

2002-08-15 Thread Robertson Lee - lerobe
-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Shutdown Abort Damages Database!

2002-08-13 Thread Robertson Lee - lerobe
and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Shutdown Abort Damages Database!

2002-08-13 Thread Robertson Lee - lerobe
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Shutdown Abort Damages Database!

2002-08-13 Thread Robertson Lee - lerobe
:-) -Original Message- Sent: 13 August 2002 16:14 To: Multiple recipients of list ORACLE-L On Tue, Aug 13, 2002 at 06:13:27AM -0800, Robertson Lee - lerobe wrote: Bloody compaq HP Gr !!! -Original Message- Sent: 13 August 2002 14:43 To: Multiple recipients

RE: How tocheck the dir existence on a remote server

2002-08-12 Thread Robertson Lee - lerobe
prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe

RE: Statspack archiving

2002-08-12 Thread Robertson Lee - lerobe
of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: SOME SOLUTIONS!

2002-08-09 Thread Robertson Lee - lerobe
-- Author: Robertson Lee - lerobe 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

Oracle to Access

2002-07-31 Thread Robertson Lee - lerobe
Hi, Oracle 8.1.7.3 Tru64 5.1 MSAccess 2000 Preparing to be shot down in flames but I have been looking through some documentation and also some White Papers but for some reason I just don't get it. I need to see Access tables from an Oracle DB. The paper I am reading (from Metalink)

RE: Oracle Heterogenous Services

2002-07-31 Thread Robertson Lee - lerobe
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: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Oracle Heterogenous Services

2002-07-31 Thread Robertson Lee - lerobe
Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Heterogenous Services John, I have done this from PC to Oracle Database on a UNIX server but not the other way around. I

RE: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread Robertson Lee - lerobe
the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: larry want to take over your e-mai

2002-07-12 Thread Robertson Lee - lerobe
computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: killing sessions

2002-07-12 Thread Robertson Lee - lerobe
://www.orafaq.com -- Author: Robertson Lee - lerobe 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

RE: More on the OCP priceing

2002-07-12 Thread Robertson Lee - lerobe
://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

FW: Do you know your Server Performance and Availability ?

2002-07-11 Thread Robertson Lee - lerobe
the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: runInstaller

2002-07-11 Thread Robertson Lee - lerobe
this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network

Statspack Intervals

2002-07-10 Thread Robertson Lee - lerobe
All, I've just been rolling out statspack against all of our production DBs. What I am not sure about is how often I should take a snapshot ? I am planning on holding one months worth of data and then backing it up and then purging. How often do you guys take snapshots and does my

RE: Statspack Intervals

2002-07-10 Thread Robertson Lee - lerobe
solving: 5 to 15 minute interval. Really wrong are intervals of an hour or so(only usefull for comparision) Anjo. - Original Message - From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 10, 2002 11:43

RE: Statspack Intervals

2002-07-10 Thread Robertson Lee - lerobe
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: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Object in hot file

2002-07-03 Thread Robertson Lee - lerobe
Title: RE: Unix - scheduling Try this one select distinct e.owner,f.file_name ,e.segment_name from DBA_EXTENTS E , DBA_DATA_FILES FWHERE E.FILE_ID = F.FILE_IDand f.file_name = 'insert your filename here'and e.owner = 'insert the object owner here' HTH Lee -Original

Hints being ignored

2002-06-28 Thread Robertson Lee - lerobe
All Oracle 8.0.5.0.0 Tru64 4.0f Select statement as follows. The hint is being totally ignored. Any ideas ?? Regards Lee SELECT /*+ INDEX(CONSUMER_COMM_D2C CONSUMER_COMM_D2C_PK) */ i.household_id || '|' || 'd' || '|' || d.promotion_item_id || '|' || xp.campaign_id || '|' ||

RE: Things to do when writing scripts in the Korn Shell

2002-06-27 Thread Robertson Lee - lerobe
or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: the ora certified masters cert, yet again

2002-06-26 Thread Robertson Lee - lerobe
have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL

RE: RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Robertson Lee - lerobe
your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: the ora certified masters cert, yet again

2002-06-25 Thread Robertson Lee - lerobe
') 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: Robertson Lee - lerobe INET

RE: Difference Between DBMS/RDBMS

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

RE: OT: GNU or [G]NU (Pronunciation of...)

2002-06-24 Thread Robertson Lee - lerobe
have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat

RE: OT: Viruses

2002-06-21 Thread Robertson Lee - lerobe
? This list does not forward binary attachments. Jared Robertson Lee - lerobe [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/19/2002 01:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:OT: Viruses

RE: 8.1.7.4 patch for Linux

2002-06-21 Thread Robertson Lee - lerobe
-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

OT: Viruses

2002-06-19 Thread Robertson Lee - lerobe
Has anyone else received viruses from this list recently. This is the only list I am subscribed to via my works email now and I have had about 4 sent to me in the last 3 weeks. Sorry for the non-oracle subject matter Lee The information contained in this communication is confidential,

RE: Management Reports

2002-06-14 Thread Robertson Lee - lerobe
this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network

RE: How to find out the latest object created in DB?

2002-06-13 Thread Robertson Lee - lerobe
From sqlplus type the following desc user_objects and everything should become clear. Regards Lee -Original Message-From: Jalil Zabourdine [mailto:[EMAIL PROTECTED]]Sent: 13 June 2002 11:03To: Multiple recipients of list ORACLE-LSubject: How to find out the latest object

Wait event problems

2002-06-13 Thread Robertson Lee - lerobe
All, Oracle 8.0.5.0.0 Tru64 v4.0f We are running a job and statspack reports show that our only problem (it is running like a dog) is the following SQL*Net more data from client. Done some reading and still none the wiser. Anyone else had this sort of problem and if so how did you

RE: Wait event problems

2002-06-13 Thread Robertson Lee - lerobe
this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Discount book website

2002-06-12 Thread Robertson Lee - lerobe
is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET

Partitions

2002-06-05 Thread Robertson Lee - lerobe
All, Oracle 8.0.5 Tru64 4.0f We have a partitioned table here that has been left for sometime now and we need to split up the last partition into at least 6 to 7 resized partitions. My take on it after RTFM ing was to 1) Unload the data 2) Create my new tablespaces for the new

RE: Partitions

2002-06-05 Thread Robertson Lee - lerobe
Information Network Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] lerobe@acxiom cc: .co.uk Subject: Partitions Sent

Undocumented Parameters

2002-05-30 Thread Robertson Lee - lerobe
Someone posted a bit of SQL to list out the undocumented parameters and guess what ... I deleted it. Could someone repost please ?? TIA Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally

Advice needed please

2002-05-30 Thread Robertson Lee - lerobe
. Regards Lee -Original Message- From: Dudley Dave - ddudle Sent: 29 May 2002 16:04 To: Robertson Lee - lerobe Subject:RE: Do you still have that SQL Expert? No, you miss the point. I'm explicitly NOT using PQ (or at least

RE: Undocumented Parameters

2002-05-30 Thread Robertson Lee - lerobe
of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Advice needed please

2002-05-30 Thread Robertson Lee - lerobe
Sent: 29 May 2002 16:04 To: Robertson Lee - lerobe Subject:RE: Do you still have that SQL Expert? No, you miss the point. I'm explicitly NOT using PQ (or at least not explicitly using it). Using a parallel hint on huge table unloads

ProC problem

2002-05-27 Thread Robertson Lee - lerobe
received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City

RE: ProC problem

2002-05-27 Thread Robertson Lee - lerobe
or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: so when did you switch from NT to unix for oracle

2002-05-24 Thread Robertson Lee - lerobe
or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: ok one for you windows/oracle people out there

2002-05-22 Thread Robertson Lee - lerobe
. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL

Oracle on (Ssshhh NT)

2002-05-21 Thread Robertson Lee - lerobe
All, Anyone can point me in the direction of some excellent books re. the setup/admin/tuning of Oracle on NT in specific. I could google it but theres nothing better than personal recommendations. It would appear wehave a(nother !!)major client here who requires an Oracle/NT solution and

RE: patching 8.1.7

2002-05-21 Thread Robertson Lee - lerobe
: Robertson Lee - lerobe 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: Oracle on (Ssshhh NT)

2002-05-21 Thread Robertson Lee - lerobe
) and Oracle9i for Windows(R) 2000 Tips Techniques by Sale, Jesse ?? you can get a table of contents and sample chapter on the site: http://shop.osborne.com/cgi-bin/oraclepress/ (then click on Server Technologies) --- Robertson Lee - lerobe [EMAIL PROTECTED] wrote: All, Anyone can point me

  1   2   3   4   >