RE: When optimizer reevaluate SQL statement

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

RE: When optimizer reevaluate SQL statement

2001-09-13 Thread Hillman, Alex
of the object - theoretically should also reparse. Anything else? Also is there possibility to force reparsing of SQL statement if let say index was added - short of flashing shared pool? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET

Quest bought EZSQL

2001-09-13 Thread Hillman, Alex
when they are thretening profits. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

bitmap indexes and rule based optimizer

2001-09-12 Thread Hillman, Alex
Anybody knows whether rule based optimizer can use bitmap indexes? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: bitmap indexes and rule based optimizer

2001-09-12 Thread Hillman, Alex
can use bitmap indexes? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Copying backups across a narrow pipe.

2001-09-11 Thread Hillman, Alex
FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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: manage oracle on SAP system

2001-09-10 Thread Hillman, Alex
Typo. Alex Hillman -Original Message- Sent: Friday, September 07, 2001 6:31 PM To: Multiple recipients of list ORACLE-L Alex, Are you joking or it's a typo ? but I like Iracle (Irate+Oracle ??:) SAP DBA... - Kirti -Original Message- From: Hillman, Alex [SMTP:[EMAIL

RE: db engines VS flat files

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

RE: Hardware requirements when migration oracle from NT to Li

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

RE: manage oracle on SAP system

2001-09-07 Thread Hillman, Alex
://www.orafaq.com -- Author: Hillman, Alex 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: Max IO size - File System vs Raw

2001-09-07 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

When optimizer reevaluate SQL statement

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

what to check in alert.log

2001-09-05 Thread Hillman, Alex
Any suggestions what to check for in alert.log besides ORA- ? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: 81721 upgrade and event 10520

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

RE: 81721 upgrade and event 10520

2001-09-05 Thread Hillman, Alex
://www.orafaq.com -- Author: Hillman, Alex 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: Spooling output of a select statement to a file through store

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

financial problems with fatcity.com

2001-08-29 Thread Hillman, Alex
developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: financial problems with fatcity.com

2001-08-29 Thread Hillman, Alex
developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED

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

2001-08-21 Thread Hillman, Alex
') 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: Hillman, Alex INET

RE: High DML Table - Suggestions??

2001-08-20 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

How to find maximum number of concurrent sorts from instance star

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

Using triggers for data validation

2001-08-17 Thread Hillman, Alex
://www.orafaq.com -- Author: Hillman, Alex 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: Re[2]: Datafile Migration Tool

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

RE: Re[2]: Datafile Migration Tool

2001-08-15 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: OT Dorothy Parker :)

2001-08-09 Thread Hillman, Alex
') 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: Hillman, Alex INET: [EMAIL

RE: How to locate who dropped a view using log miner?

2001-08-08 Thread Hillman, Alex
(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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: How to locate who dropped a view using log miner?

2001-08-08 Thread Hillman, Alex
') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Hillman

RE: Timed statistics and SQL_TRACE for already running session

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

RE: SQL tuning / optimization problem - IS NOT NULL - Clarify

2001-08-08 Thread Hillman, Alex
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: Hillman

RE: Recovery without backup.

2001-08-08 Thread Hillman, Alex
Title: Recovery without backup. It existed before 8i. There is an example in Backup and Recovery book. alter database create datafile ... and then recover. Alex Hillman -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 08, 2001 3:22

RE: ORA-00600 on Production DB - Need advice/Still Searching

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

RE: How to determine checkpoint rate?

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

RE: Evaluation questions

2001-08-01 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: performance pl/sql for DW conclusion

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

RE: performance pl/sql for DW conclusion

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

RE: alter index??

2001-07-31 Thread Hillman, Alex
-- Author: Hillman, Alex 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: sqlloader process dies

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

RE: 8.1.6. on Linux installation problem

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

RE: Another Braindead Friday...

2001-07-27 Thread Hillman, Alex
://www.orafaq.com -- Author: Hillman, Alex 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: Solution (sorta) - Re: Another Braindead Friday...

2001-07-27 Thread Hillman, Alex
://www.orafaq.com -- Author: Hillman, Alex 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: deletion of data from a large table

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

RE: OT, It's all about Alex

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

need procedure to extract DDL for table

2001-07-26 Thread Hillman, Alex
Does anybody have stored procedure or PL/SQL script to extract DDL for the table? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

catparr.sql

2001-07-26 Thread Hillman, Alex
Is there any sense to run catparr.sql if I do not use OPS? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: OT, WOW really early

2001-07-25 Thread Hillman, Alex
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: Hillman, Alex

RE: Locally managed tablespaces

2001-07-20 Thread Hillman, Alex
Hillman, Alex wrote: You canuse any storage parameters you like but oracle will ignore them exept for initial for LMT with autoallocate. I would personally do not use autoallocate. Also you cannot use autoallocate for temporary tablespace and shouldn't use it for rollback. Alex Hillman

RE: Oracle Apps customization help working with consultants

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

RE: Locally managed tablespaces

2001-07-19 Thread Hillman, Alex
') 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: Hillman, Alex INET

RE: RE: New Listener Question

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

sort segments

2001-07-18 Thread Hillman, Alex
Are there any circumstances when temporary tablespace can contain more than 1 sort segment? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: New Listener Question

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

RE: Last Update

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

RE: Last Update

2001-07-17 Thread Hillman, Alex
') 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: Hillman, Alex INET

RE: Multiple Listeners

2001-07-16 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: view contents of datafile

2001-07-12 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City

RE: 9i standby

2001-07-12 Thread Hillman, Alex
(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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: A danger in cloning databases

2001-07-11 Thread Hillman, Alex
(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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Second RBS in system tablespace

2001-07-11 Thread Hillman, Alex
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: Hillman, Alex

RE: gzip does not want to work with files 2G

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

db-links question

2001-07-09 Thread Hillman, Alex
am layzy (sp?) and tired (fighting with Ross for access to printing presses :-) ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Oracle support phone number

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

gzip does not want to work with files 2G

2001-07-09 Thread Hillman, Alex
I have Solaris 5.8 angzip does not want to work with files 2G - tells that file is too large. Anybody has any idea why? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

export in cron

2001-07-06 Thread Hillman, Alex
that called export and if not - how to catch it? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: export in cron

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

RE: How to implement and use DBMS_STATS?

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

RE: SAP R3 and Locally Managed Tablespaces

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

RE: How to implement and use DBMS_STATS?

2001-07-06 Thread Hillman, Alex
://www.orafaq.com -- Author: Hillman, Alex 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: SAP R3 and Locally Managed Tablespaces

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

RE: Schema organization

2001-07-05 Thread Hillman, Alex
(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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: can/do indexes chain?

2001-07-05 Thread Hillman, Alex
: http://www.orafaq.com -- Author: Hillman, Alex 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: PFILE location in NT

2001-07-03 Thread Hillman, Alex
Title: PFILE location in NT It was true for versions before 8.1. Beginning with 8.1 default is the same as in unix - $ORACLE_HOME/dbs Alex Hillman -Original Message-From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 03, 2001 6:20 AMTo: Multiple

RE: Select only one of three tables

2001-07-03 Thread Hillman, Alex
FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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: SGA, miscellaneous keeps growing...

2001-07-03 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED

RE: Sql question

2001-06-29 Thread Hillman, Alex
') 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: Hillman, Alex INET: [EMAIL

RE: Wher is an error ?

2001-06-28 Thread Hillman, Alex
'; else echo 'bbb'; fi aaa 17:17:51:oracle8i@coin-app:/u07/export8i:ORUNDEF 515- why does it print aaa instead of bbb? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: authid definer

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

RE: Fragmentation Locally Managed Tablespaces

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

RE: Number of books sold 10000

2001-06-28 Thread Hillman, Alex
-- Author: Hillman, Alex 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: OT 24 x 7 on NT - ot

2001-06-28 Thread Hillman, Alex
Title: RE: OT 24 x 7 on NT - ot At least your memory is good :-) Alex Hillman -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 5:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT 24 x 7 on NT - ot Lisa, my

Number of books sold 10000

2001-06-27 Thread Hillman, Alex
-- Author: Hillman, Alex 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: OT RE: 24 x 7 on NT?

2001-06-27 Thread Hillman, Alex
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: Hillman

RE: Griping about auditing (not the Oracle Kind)

2001-06-26 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City

Storage allocation for LOB and LONG datatypes

2001-06-25 Thread Hillman, Alex
: http://www.orafaq.com -- Author: Hillman, Alex 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: Griping about auditing (not the Oracle Kind)

2001-06-25 Thread Hillman, Alex
Title: RE: Griping about auditing (not the Oracle Kind) I suggest CYA as much as possible and escalate the issue and begin search foranother job. Also if you are an FTE - now is a good time to go on vacation or become sick. Because if something breaks damagement knows much better how to

How to suppress export, import intractivity

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

RE: OT - interviewing your superior

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

RE: Prompt in Korn shell

2001-06-21 Thread Hillman, Alex
- for current working directory and ORACLE_SID for example. I know how to do it in bash but cannot do it right in Korn. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Prompt in Korn shell

2001-06-21 Thread Hillman, Alex
working directory and ORACLE_SID for example. I know how to do it in bash but cannot do it right in Korn. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: What the difference between qio and direct I/O option in VxFS

2001-06-20 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

export of longs

2001-06-20 Thread Hillman, Alex
couldn't do it in 7.3.3 when I tried. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Prompt in Korn shell

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

RE: Redo latch contention

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

RE: Redo latch contention

2001-06-18 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: JDeveloper Connection to Oracle DB

2001-06-18 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Sort_multiblock_read_count

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

RE: Sort_multiblock_read_count

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

RE: Tuning Sorts

2001-06-15 Thread Hillman, Alex
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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: Reorgs in general

2001-06-15 Thread Hillman, Alex
, 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat

RE: Forever running Analyze

2001-06-13 Thread Hillman, Alex
[Hillman, Alex] -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table

RE: Forever running Analyze

2001-06-13 Thread Hillman, Alex
...compute statistics for col1, col2, etc - for columns with squed values Alex Hillman -Original Message-From: Hillman, Alex [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 11:07 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Forever running Analyze Looks like

  1   2   3   >