RE: Toad vs SQL Navigator

2001-11-01 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City

RE: Java in the database

2001-10-29 Thread Christopher Spence
- From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Friday, October 26, 2001 20:51 Subject: RE: Java in the database Take a look at OrionServer (www.orionserver.com) at $1,500 / server and 5x faster than Web Logic, I would wonder why people

RE: Java in the database

2001-10-29 Thread Christopher Spence
Actually the 5x faster is a third party benchmark for Orion Server before it was intergrated with Oracle. I forget who did the benchmark, but it is on www.orionserver.com They compared Web Logic, Tomcat, Ressin, Orion, and I believe one other. Do not criticize someone until

RE: Win XP

2001-10-29 Thread Christopher Spence
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Win XP

2001-10-29 Thread Christopher Spence
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Win XP

2001-10-29 Thread Christopher Spence
: Christopher Spence 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: Java in the database

2001-10-26 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Java in the database

2001-10-26 Thread Christopher Spence
Take a look at OrionServer (www.orionserver.com)  at $1,500 / server and 5x faster than Web Logic, I would wonder why people would use others.  And OAS9i uses Orion as the core now. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them,

RE: Java in the database

2001-10-26 Thread Christopher Spence
') 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: Christopher Spence INET: [EMAIL

RE: RAID for a development box

2001-10-24 Thread Christopher Spence
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: RAID for a development box

2001-10-24 Thread Christopher Spence
. Christopher Spence To: Multiple recipients of list ORACLE-L cspence [EMAIL PROTECTED] @FuelSpot.comcc: Subject: RE: RAID for a development box

RE: How long are statistics good for

2001-10-23 Thread Christopher Spence
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Which RAID level do you use?

2001-10-19 Thread Christopher Spence
-- Author: Christopher Spence 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: Which RAID level do you use?

2001-10-19 Thread Christopher Spence
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Changing optimizer mode and collecting statistics

2001-10-18 Thread Christopher Spence
, 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: Christopher Spence INET: [EMAIL PROTECTED

RE: Uncle Larry in the news

2001-10-18 Thread Christopher Spence
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Little Brother Larry sorta ON topic

2001-10-18 Thread Christopher Spence
FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: Little Brother Larry sorta ON topic

2001-10-18 Thread Christopher Spence
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Program field in v$session

2001-10-05 Thread Christopher Spence
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Backup Strategy

2001-10-05 Thread Christopher Spence
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Restricted mode

2001-10-05 Thread Christopher Spence
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Installation of designer 6.0 with personal oracle 8.1.6

2001-10-05 Thread Christopher Spence
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: perplexing plan?

2001-10-05 Thread Christopher Spence
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Q about autoextent tablespaces and performance

2001-10-05 Thread Christopher Spence
Title: Q about autoextent tablespaces and performance I generally add about 33% to the size of the uncompressed export. This gives me some idea how much space it may take. Of course, this depends on how many indexes (as they are not stored in export) and storage parameters on the

RE: Q about autoextent tablespaces and performance

2001-10-05 Thread Christopher Spence
Title: Q about autoextent tablespaces and performance Accidently hit send before I finished my response... Anyway, one thing I used to do is give them a CRETAB/CREIDX script and have them run it. This will allow you to build the table and indexes ahead of time, and of the size you

RE: Export - Import from Oracle v8 to v731

2001-10-04 Thread Christopher Spence
. Christopher Spence To: Multiple recipients of list ORACLE-L cspence [EMAIL PROTECTED] @FuelSpot.com cc: Subject: RE: Export - Import from Oracle v8 Sent by: root to v731 10/03/2001 12:25 PM Please respond to ORACLE-L You generally cannot export from a higher leveldatabase

RE: When optimizer reevaluate SQL statement

2001-10-04 Thread Christopher Spence
submitted identical SQL it would negate much of the benefit of using bind variables. Thus the answer is that there is reparsing, but not the kind that really does damage to performance. Regards, Chris Gait On 14 Sep 2001, at 9:55, Christopher Spence wrote: Date sent: Fri, 14 Sep 2001 09

RE: JDBC on Unix box

2001-10-04 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: question about explain plan ???

2001-10-04 Thread Christopher Spence
of 'ListGuru') 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: Christopher

RE: Dropping table is not completing

2001-10-04 Thread Christopher Spence
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Max number of sessions

2001-10-04 Thread Christopher Spence
Title: Max number of sessions Oracle uses PROCESSES + 10% + 5 for setting the hard limit of the sessions parameter. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence

RE: DISK IO?

2001-10-04 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: Max number of sessions

2001-10-04 Thread Christopher Spence
at exactly the number of sessions allowed by the processes parameter, including the background processes. That was on Solaris and on HP/UX. Looked like there was no wiggle room, period. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -Original Message----- From: C

RE: Droping System User

2001-10-04 Thread Christopher Spence
Title: RE: Droping System User The DBA_ tables are owned by SYS. But a lot of features such as AQ and such use objects owned by SYSTEM. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes.

RE: Max number of sessions

2001-10-04 Thread Christopher Spence
environment). George - Original Message - From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Thursday, October 04, 2001 2:50 PM Subject: RE: Max number of sessions Oracle uses PROCESSES + 10% + 5 for setting the hard limit

RE: inefficient SQL detector

2001-10-04 Thread Christopher Spence
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Output to Excel

2001-10-04 Thread Christopher Spence
(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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Intermedia Performance Benchmarks anyone ?

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

RE: Oracle - SQL Server

2001-10-03 Thread Christopher Spence
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Oracle - SQL Server

2001-10-03 Thread Christopher Spence
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Please Help

2001-10-03 Thread Christopher Spence
This is covered very well and in detail in the manuals, but in short it means you had a transaction write to a rollback segment, then a long running query requested this information for read consistency before the transaction (cause it was already started before the transactions started)

RE: Extents size.

2001-10-03 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Extents size.

2001-10-03 Thread Christopher Spence
no problem whatsoever. --- Christopher Spence [EMAIL PROTECTED] wrote: That is completely a myth. There is no notable performance different with a table with 10,000 extents and one with 1. The only problem is when it comes to the bitmaps when dealing with LMT and cluster when

RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000

2001-10-03 Thread Christopher Spence
Title: RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000 I did 8.1.7.1 then did 8.1.7.5 Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone:

RE: Veritas Quickio and DB_BLOCK_SIZE

2001-10-03 Thread Christopher Spence
') 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: Christopher Spence

RE: Disk layout

2001-10-03 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Extents size.

2001-10-03 Thread Christopher Spence
.. then there is an impact because of the hits on the dictionary tables. but basically yes... I've been told by various Oracle employees that up to 4096 extents cause no problem whatsoever. --- Christopher Spence [EMAIL PROTECTED] wrote: That is completely a myth. There is no notable

RE: Extents size.

2001-10-03 Thread Christopher Spence
partition? For example if I had a table wth 371 partitions (53 weeks per year * 7 years) to hold invoice data for tax purposes, do the number of extents per partition need to be kept at 1 to avoid exceeding the 505 extent value on the table as a whole? Christopher Spence wrote: LMT's have

RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000

2001-10-03 Thread Christopher Spence
? 8.1.7.2.2 is the most recent NT/2000 patchset I could find. -Don Granaman [OraSaurus - Honk if you remember UFI!] - Original Message - From: Christopher Spence To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 03, 2001 9:25 AM

RE: running catlog,catproc

2001-10-03 Thread Christopher Spence
: Christopher Spence 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, send

RE: Export - Import from Oracle v8 to v731

2001-10-03 Thread Christopher Spence
Title: Export - Import from Oracle v8 to v731 You generally cannot export from a higher level database to a lower. Although you can probably change the compatible option to 7.3.4 and do it that way (from what I hear, never tried it). Do not criticize someone until you walked a mile

RE: STATSPACK snap_id and time generated...

2001-10-03 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network

RE: intermediate table

2001-10-03 Thread Christopher Spence
You cannot use SQL against PL/SQL tables. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73

RE: Veritas Quickio and DB_BLOCK_SIZE

2001-10-03 Thread Christopher Spence
://www.orafaq.com -- Author: Christopher Spence 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: When optimizer reevaluate SQL statement

2001-10-03 Thread Christopher Spence
is that there is reparsing, but not the kind that really does damage to performance. Regards, Chris Gait On 14 Sep 2001, at 9:55, Christopher Spence wrote: Date sent: Fri, 14 Sep 2001 09:55:33 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Send reply

RE: book?

2001-10-03 Thread Christopher Spence
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Measure parsing calls...

2001-10-03 Thread Christopher Spence
: 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services

RE: BEGIN BACKUP MODE !!

2001-10-02 Thread Christopher Spence
ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Extents size.

2001-10-02 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Problem in setting PCTFREE and PCTUSED

2001-10-02 Thread Christopher Spence
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Meaning of V$WAITSTAT statistics

2001-10-02 Thread Christopher Spence
://www.orafaq.com -- Author: Christopher Spence 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: pl/sql question

2001-10-02 Thread Christopher Spence
') 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: Christopher

RE: Loadjava utility

2001-10-02 Thread Christopher Spence
to load in ther server two jar files, through the loadjava utility. But, where should be this files physically stored? Should they be in any folder under ORACLE_HOME directory? A lot of thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET

Oracle - SQL Server

2001-10-02 Thread Christopher Spence
Title: Oracle - SQL Server I know there is a way in SQL server to query oracle tables, is there a way to do the reverse? I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL server database. Anyone have any ideas on this, I searched technet

RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000

2001-10-02 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: Oracle - SQL Server

2001-10-02 Thread Christopher Spence
--- Christopher Spence [EMAIL PROTECTED] wrote: I know there is a way in SQL server to query oracle tables, is there a way to do the reverse? I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL server database. Anyone have any ideas

RE: Oracle - SQL Server

2001-10-02 Thread Christopher Spence
? * how fresh? * how big is it? Since it's temporary, this may work for you. Jared Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@FuelS cc

RE: Extents size.

2001-10-02 Thread Christopher Spence
://www.orafaq.com -- Author: Christopher Spence 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: When optimizer reevaluate SQL statement

2001-10-02 Thread Christopher Spence
SQL it would negate much of the benefit of using bind variables. Thus the answer is that there is reparsing, but not the kind that really does damage to performance. Regards, Chris Gait On 14 Sep 2001, at 9:55, Christopher Spence wrote: Date sent: Fri, 14 Sep 2001 09:55:33 -0800

RE: rollback segments during export

2001-10-01 Thread Christopher Spence
of 'ListGuru') 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: Christopher

RE: ORA-03113 when executing the initjvm script

2001-10-01 Thread Christopher Spence
faced this problem? TIA, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: How much data can SQL*Server hold?

2001-10-01 Thread Christopher Spence
Title: How much data can SQL*Server hold? I think SQL Server can hold up to 5Mb. Just kidding, in 6.5 it is 1Tb, in 7.0 It is 1,048,516 TB 32k dbs/server 32gb file size in 6.5, and 4tb file size in 7.0 And a max of 2 billion objects if I remember correctly. Do not criticize

RE: rollback segments during export

2001-10-01 Thread Christopher Spence
://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: Searching across multiple columns

2001-10-01 Thread Christopher Spence
: 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services

RE: Those who like/dislike CA may be interested

2001-10-01 Thread Christopher Spence
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Physical access to servers for maintenance

2001-09-26 Thread Christopher Spence
Title: RE: Physical access to servers for maintenance This doesn't work for NT machines, and it with Unix you cannot install 8.1.6 without X access. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their

RE: Physical access to servers for maintenance

2001-09-26 Thread Christopher Spence
(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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Physical access to servers for maintenance

2001-09-26 Thread Christopher Spence
://www.orafaq.com -- Author: Christopher Spence 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: DBA assessment - slightly OT

2001-09-26 Thread Christopher Spence
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Physical access to servers for maintenance

2001-09-26 Thread Christopher Spence
-- Author: Christopher Spence 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: Does start with/connect by uses full table scan?

2001-09-26 Thread Christopher Spence
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: VB/Oracle question

2001-09-26 Thread Christopher Spence
of 'ListGuru') 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: Christopher

RE: DBA assessment - slightly OT

2001-09-26 Thread Christopher Spence
: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: 2nd DBA or ?

2001-09-21 Thread Christopher Spence
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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network

RE: Optimal Disk Layout??

2001-09-21 Thread Christopher Spence
(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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Design Issue - Quick response appreciated

2001-09-21 Thread Christopher Spence
Generally it is bad practice to use columns in the primary key, which change. They introduce many different problems. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence

RE: coalesce tablespace

2001-09-21 Thread Christopher Spence
://www.orafaq.com -- Author: Christopher Spence 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: Design Issue - Quick response appreciated

2001-09-21 Thread Christopher Spence
recipients of list ORACLE-L Subject: RE: Design Issue - Quick response appreciated In our case, we do not have any other columns --- 1. which could identify uniquely a record and yet do not undergo a change. Thanks, Rao -Original Message- From: Christopher

RE: Waking SMON Not Doing Trick

2001-09-21 Thread Christopher Spence
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Waking SMON Not Doing Trick

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

RE: Undo x Rollback Segments in 9i

2001-09-21 Thread Christopher Spence
://www.orafaq.com -- Author: Christopher Spence 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: Design Issue - Quick response appreciated

2001-09-21 Thread Christopher Spence
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Undo x Rollback Segments in 9i

2001-09-21 Thread Christopher Spence
for a while? Or do you need to recreate the database in order to do that? Thanks, Cherie Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@FuelS cc

RE: Rachel - RE: 2nd DBA or ?

2001-09-21 Thread Christopher Spence
with Christopher Spence, if this is a in-house Development, or continued developed oracle application environment, then of course you will need additional people to help you out. I initially replied to this post, because I was given the same opportunity to bring in another DBA for the UK. I chose to do

RE: 2nd DBA or ?

2001-09-20 Thread Christopher Spence
-- Author: Christopher Spence 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: coalesce tablespace

2001-09-20 Thread Christopher Spence
(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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: List of changed objects in the DB

2001-09-20 Thread Christopher Spence
of 'ListGuru') 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: Christopher

RE: Compiling package

2001-09-19 Thread Christopher Spence
://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: sizeiof table!!!

2001-09-19 Thread Christopher Spence
, 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: Christopher Spence INET: [EMAIL PROTECTED

RE: How to move a databse from Solaris to Llinux

2001-09-19 Thread Christopher Spence
://www.orafaq.com -- Author: Christopher Spence 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

  1   2   3   4   5   6   7   >