RE: Purely for your amusement

2003-02-28 Thread Glenn Travis
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.net -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Optimizer help, get query to run as good as with RULE hint

2003-02-14 Thread Glenn Travis
(by index rowid) 109 1INDEX (analyzed) NON-UNIQUE AR HZ_CUST_ACCT_SITES_N1 (range scan) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Optimizer help, get query to run as good as with RULE hint

2003-02-14 Thread Glenn Travis
-- --- 47073 23815K 826 Doesn't this suggest setting sort_area_size larger? -Original Message- From: Glenn Travis Sent: Friday, February 14, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: Optimizer help, get

New Schema or New Database?

2003-01-21 Thread Glenn Travis
the databases into one instance as schemas, but don't want to limit the different applications to 'one-size-fits-all' for performance/recovery scenarios. Any advice would be greatly welcomed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Travis INET

RAC (Real Application Clusters)

2002-09-26 Thread Glenn Travis
? This is a technical overview and we will be seeing conversions (Apps and non-Apps environments) as well as failure scenarios. Any advice/comments are welcome. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services

RE: Privileges needed for truncate

2002-09-24 Thread Glenn Travis
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: arg list too long in unix

2002-08-29 Thread Glenn Travis
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Grant access to EVERYTHING w/out granting DBA privs.

2002-08-15 Thread Glenn Travis
NO GLENNSELECT_CATALOG_ROLENO -Original Message- From: Glenn Travis Sent: Wednesday, August 14, 2002 2:22 PM To: OAUGnet-DBA Subject: Grant access to EVERYTHING w/out granting DBA privs. I want to create a user and grant it access

Grant access to EVERYTHING w/out granting DBA privs.

2002-08-14 Thread Glenn Travis
will need to bring up TOAD, or PL/SQL Developer and be able to see any users objects and procedures. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE:

2002-07-24 Thread Glenn Travis
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: Glenn

RE: patching 8.1.7

2002-05-22 Thread Glenn Travis
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: Glenn

RE: patchset 8.1.7.3 or 8.1.7.4

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

RE: Currval and buffer gets

2002-04-24 Thread Glenn Travis
Title: RE: Currval and buffer gets On HP-UX: model = 9000/800/N4000-55OS release level= B.11.11processor count = 8clock speed = 550 MHzmemory = 16384 Mb SQL set serveroutput on size 1;SQL @test.sql27 /run time using view x_$dual in centiseconds=600run time using table dual in

RE: Memory?

2002-04-24 Thread Glenn Travis
in this e-mail is subject to the terms and conditions CN expressed in any applicable terms of business. -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET

RE: Anything new from IOUG? + OWI Born!! (Anjo/Mogens, please n

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

Patch Install (8.1.7.3) and oraInventory

2002-04-22 Thread Glenn Travis
FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: Locally managed tablespaces/What a DBA can do ?

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

RE: Security Hole

2002-04-16 Thread Glenn Travis
FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Buf Hit Ratio

2002-04-08 Thread Glenn Travis
-- - 08-APR-2002 10:35:16 18,446,744,069,434,437,169 171,781,916 18,446,744,070,280,471,598 2,103,859 18,446,744,047,946,114,866966,679 1,032,014,671 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn

RE: RMAN

2002-04-04 Thread Glenn Travis
') 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: Glenn Travis

RE: Oracle From a Sybase DBA perspective

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

ORA-1652: unable to extend temp segment - BUT I have plenty of sp

2002-03-25 Thread Glenn Travis
32,11293 APPS TEMP select parameter, value from nls_session_parameters 1.00 (a couple of others totalling 6MB) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: lights?

2002-03-12 Thread Glenn Travis
, 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: Glenn Travis INET: [EMAIL PROTECTED] Fat

RE: Battle of the databases, Part II

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

RE: Users reading from rollback segments

2002-02-27 Thread Glenn Travis
to ask is if we can tell who will need to read the rollback segments sometime soon. And you can't. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Hmmm. I think I CAN predict FUTURE needs of the rollback segments

Users reading from rollback segments

2002-02-26 Thread Glenn Travis
). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Users reading from rollback segments

2002-02-26 Thread Glenn Travis
: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Subject: Users reading from rollback segments Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback

RE: Users reading from rollback segments

2002-02-26 Thread Glenn Travis
. otherwise it is 0. oracle 8.1.6 you can take an active rollback segment offline, but also kill the transaction. 8.17 supposed to fix the bug. I assume it will let the transaction finished. Joan Glenn Travis wrote: Is there a way to tell if anyone is reading from the rollback segments

RE: Problem with Rollback segment getting locked

2002-02-25 Thread Glenn Travis
Check that last sentence - should be: Remember, if they are P*R*I*V*A*T*E rollback segments, they must be specified in the rollback_segments parameter to be brought online. -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Monday, February 25, 2002 10:18 AM

Missing datafile that cannot be recovered (cloned) and SMON probl

2002-02-21 Thread Glenn Travis
ideas or is our instance hopelessly confused? __ Glenn Travis Database Administrator Business Intelligence Support [EMAIL PROTECTED] 919-531-0434 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat

RE: RE: MC/Serviceguard vs Sun Clusters

2002-02-08 Thread Glenn Travis
Separator Author: Glenn Travis [EMAIL PROTECTED] Date: 2/7/2002 1:07 PM Could you explain the file corruption in a little more detail? I cannot imagine how failover would cause file corruption, much less how a properly configured running Oracle instance can get

RE: MC/Serviceguard vs Sun Clusters

2002-02-07 Thread Glenn Travis
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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Unbreakable Oracle - Metaslink

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

RE: RTFM questions (formally RE: PL/SQL)

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

RE: Questions

2002-01-11 Thread Glenn Travis
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: Glenn Travis INET: [EMAIL PROTECTED

RE: recovery during refresh

2001-12-19 Thread Glenn Travis
-- Author: Glenn Travis 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: RECOMPILE INVALID OBJECTS

2001-12-17 Thread Glenn Travis
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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: DATABASE CREATION SCRIPT

2001-10-31 Thread Glenn Travis
-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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Move tablespace with no downtime?

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

RE: RE: Oravle vs. Informix

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

Multiple triggers on same event

2001-09-24 Thread Glenn Travis
by the owner of the table always fires last... __ Glenn Travis [EMAIL PROTECTED] Business Intelligence Support 919-531-0434 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services

EMC BCV Splits and Hot Backup mode.

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

RE: EMC BCV Splits and Hot Backup mode.

2001-09-24 Thread Glenn Travis
://www.orafaq.com -- Author: Glenn Travis 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: EMC BCV Splits and Hot Backup mode.

2001-09-24 Thread Glenn Travis
for recovery purpises. When you recover the database in the BCV you have to apply the archived log file and thus you are supplying the missing piece. Hope this helps. Regards, RS --- Glenn Travis [EMAIL PROTECTED] wrote: Well, yeah. But why is it inconsistent? Please provide details. As you

RE: How to find the current instance name?

2001-09-21 Thread Glenn Travis
: Glenn Travis 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 an E

RE: Determining Oracle status

2001-09-18 Thread Glenn Travis
(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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Need script to generate DDL for snapshot/materialized view re

2001-09-13 Thread Glenn Travis
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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network

RE: hash join order

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

RE: MOVE Tables from One Tablespace to Another Tablespace !!

2001-08-21 Thread Glenn Travis
://www.orafaq.com -- Author: Glenn Travis 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 Acquires 'Seminal' E-Commerce Patent

2001-08-20 Thread Glenn Travis
http://www.internetnews.com/intra-news/article/0,,7_868161,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: but will it run windows?

2001-08-17 Thread Glenn Travis
Title: RE: but will it run windows? Exactly. There is bad code (and drivers) everywhere. Windows OS does not protect itself as well as the unix OS. NT, 2000 and XP are all better than 98 in this realm, however. MS is finally getting the point. But the point is valid. A bad program should

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Glenn Travis
Title: Message I have 2 p133 pcs at home (one running win98 for kids games, the other running linux mandrake). can you believe buy.com was selling 512MB PC133 SDRAM for $50 yesterday?! (it was their dealoftheday special and not the cheap stuff either). wow! we've come along way since I

RE: Personal Top 3 Oracle titles

2001-08-14 Thread Glenn Travis
Title: RE: Personal Top 3 Oracle titles Don't believe everything you read. There are trolls everywhere... I always visit my local Barnes and Noble or Borders bookstore and scan the book for myself. Unless the review comes from someone I know or respect. -Original Message-From:

RE: relink executables

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

RE: Timed statistics and SQL_TRACE for already running session

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

rename foreign keys from system-assigned constraint names to more

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

RE: free up datafile space problem ???

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

RE: Off Topic - Anybody know how to copy a DVD?

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

RE: alter index??

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

RE: Off Topic - Anybody know how to copy a DVD?

2001-07-31 Thread Glenn Travis
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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Off Topic - Anybody know how to copy a DVD?

2001-07-31 Thread Glenn Travis
I've got that code ona t-shirt! http://www.copyleft.net/item.phtml?dynamic=1referer=%2Fcategory.phtml%3Fpage%3Dcategory_apparel.phtmlpage=product_1180_front.phtml -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Tuesday, July 31,

RE: Off Topic - Anybody know how to copy a DVD?

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

RE: Off Topic - Anybody know how to copy a DVD?

2001-07-31 Thread Glenn Travis
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: Glenn

RE: Off Topic - Anybody know how to copy a DVD?

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

RE: Off Topic - Anybody know how to copy a DVD?

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

RE: Off Topic - Anybody know how to copy a DVD?

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

RE: Unusable index

2001-07-30 Thread Glenn Travis
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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: AutoExtend

2001-07-20 Thread Glenn Travis
://www.orafaq.com -- Author: Glenn Travis 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: Multiple Listeners

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

RE: New Listener Question

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

RE: New Listener Question

2001-07-18 Thread Glenn Travis
You are right, sir! I stand corrected. and thanks! -Original Message- Wilton Sent: Wednesday, July 18, 2001 1:48 PM To: Multiple recipients of list ORACLE-L On Wed, 18 Jul 2001, Glenn Travis wrote: I disagree. Mine only registers itself if I have the service_names entry

RE: List of installed patches?

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

List of installed patches?

2001-07-12 Thread Glenn Travis
How can I find out what patches are installed in my Oracle Installation? (I searched metalink, but only found references to Oracle Apps). Oracle 8.1.6 Sun Sparc Solaris 8 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat

RE: GMT

2001-07-11 Thread Glenn Travis
: Glenn Travis 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 an E

RE: Yahoo!

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

No Subject

2001-05-29 Thread Glenn Travis
workaround of how to accomplish this? thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Oracle DBA vs. Oracle Apps DBA - Different? and how?

2001-05-23 Thread Glenn Travis
experience with Apps because can't get hired, BUT can't get hired without experience... Opinions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: disk information alert

2001-05-23 Thread Glenn Travis
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: Glenn Travis

RE: Bulkcopy

2001-05-22 Thread Glenn Travis
] -Original Message-From: Glenn Travis [mailto:[EMAIL PROTECTED]]Sent: Monday, May 21, 2001 2:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Bulkcopy sqlldr. ATT obviously uses Sybase. -Original Message-From: [EMAIL PROTECTED] [mailto

Article- IBM vs. Oracle: It Could Get Bloody

2001-05-22 Thread Glenn Travis
party in the applications market could serve it well on the database front because Oracle competes in applications with many of the partners it counts on to help sell its databases. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED

RE: RE: Bulkcopy

2001-05-22 Thread Glenn Travis
Separator Author: Glenn Travis [EMAIL PROTECTED] Date: 5/22/2001 7:16 AM apologies. no offense was intended. on a side note, Informix has a feature that lets you define a table which references a flat file in unix. This allows them to bypass the buffer cache and facilitate fast table loads. I

More articles of interest

2001-05-21 Thread Glenn Travis
Oracle's Self-Praise Conflicts with Analyst Findings http://www.internetnews.com/asp-news/article/0,,3411_767421,00.html DB2, 9i war looms large http://gethelp.devx.com/pubs/infoworld/vol23/issue20/010514hndbwars.asp

RE: Bulkcopy

2001-05-21 Thread Glenn Travis
sqlldr. ATT obviously uses Sybase. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Carle, William T (Bill), NLCIOSent: Monday, May 21, 2001 11:46 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Bulkcopy Howdy, The only bulkcopy

Check for number only

2001-05-18 Thread Glenn Travis
-- Author: Glenn Travis 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: BMC Patrol - 2nd Wave

2001-05-17 Thread Glenn Travis
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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

sqlldr help

2001-05-17 Thread Glenn Travis
with sqlldr or do I need to load the data as is and use PL/SQL (and cursor loops) to concatentate the data? thanks for any help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

DBAs' reaction mixed on Oracle9i clustering

2001-05-15 Thread Glenn Travis
drives, giving businesses greater scalability in their database operations. http://www.zdnet.com/eweek/stories/general/0,11011,2717049,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Oracle 9i interview article (interesting read)

2001-05-15 Thread Glenn Travis
http://searchdatabase.techtarget.com/qna/0,,sid13_gci506376,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Oracle 9i Articles - self tuning, launch delayed to June

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

SQL question

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

RE: SQL question

2001-05-01 Thread Glenn Travis
/test/file.out','/',-1),length('/dir1/dir2/test/file.out')) shortnm from dual; FILENM SHORTNM /dir1/dir2/test/file.out file.out -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 3:33 PM

Oracle response to IBM's $1 billion buy of Informix: good read.

2001-04-26 Thread Glenn Travis
and Informix, predictably, had a different take on the effects of the purchase. Additional reporting by Sonia R. Lelii of eWEEK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Database and System Throughput

2001-04-25 Thread Glenn Travis
-- Author: Glenn Travis 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

Oracle 9i Release (May?)

2001-04-19 Thread Glenn Travis
ricing has not been announced yet for 9i, but it will retain the "power unit" pricing model, says Burton. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Glenn Travis
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: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services

RE: How to get rid off file permanently?

2001-04-13 Thread Glenn Travis
pelling 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:

Oracle on Solaris...

2001-03-29 Thread Glenn Travis
e's the link -- http://searchsolaris.techtarget.com/searchSolaris_Original_Content_Item/0,40 30,536359,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califor

Redo Log size used

2001-03-26 Thread Glenn Travis
What can I query to see how much of the redo log file is currently in use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

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

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-19 Thread Glenn Travis
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: Gle

  1   2   >