RE: METABLINK on the Fritz?

2001-01-31 Thread MacGregor, Ian A.
Title: METABLINK on the Fritz? There was an article posted on metalink stating that Oracle did not foresee such a large increase in the number of metalink users, and stating that upgrades to the hardware were planned. I noticed that it'sstill pretty slow today. I assume yesterday's work was

RE: OT - WHAT is a FEDERATED DATABASE ???

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

RE: 175 Terabyte Objectivity Database

2001-02-06 Thread MacGregor, Ian A.
Database OOoooh, how COOL!..Objectivity is neither Oracle nor SS is it ( gasp ) "federated" in any sense? Can you tell us more? This is interesting.. -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Monday, February

RE: ORA-29521 with Corba Advice ?

2001-02-08 Thread MacGregor, Ian A.
ude 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat Ci

RE: Offline doubt - Exclusive OR operator in PL/SQL??.

2001-02-13 Thread MacGregor, Ian A.
e 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: MacGregor, Ian A. INET: [EMAI

RE: Need help in moving LOB index

2001-02-15 Thread MacGregor, Ian A.
') 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: MacGregor, Ian A. INET: [EMAIL

RE: anyone interested in XML

2001-02-27 Thread MacGregor, Ian A.
Where does one find the dbms_xml package? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-From: Marin Dimitrov [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 27, 2001 5:20 AMTo: Multiple recipients of list ORACLE-LSubject: Re:

RE: change unix user when running external procedure

2001-03-13 Thread MacGregor, Ian A.
: http://www.orafaq.com -- Author: MacGregor, Ian A. 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: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

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

Lemon Juice in Ants Pooh-Poohed

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

RE: Lemon Juice in Ants Pooh-Poohed/Redo Log Switching

2001-03-20 Thread MacGregor, Ian A.
Y, 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: MacGregor, Ian A. INET: [EMAIL PROTECTED]

RE: OT -- A humorous reply to the Canada rulz

2001-03-20 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Networ

RE: Execute priv to an isolated procedure inside a package

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

Using Profiles to Force Users off After Inactivity

2001-03-27 Thread MacGregor, Ian A.
-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Bad Cookies with Internet Application Server 1.0

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

RE: authentication externally on WinNT

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

RE: Insert Cardinalities into the data dictionary directly

2001-04-18 Thread MacGregor, Ian A.
ailing 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: MORE NEWS: ANOTHER ELLISON GUARANTEE - RE: News flash - IBM b

2001-04-25 Thread MacGregor, Ian A.
, they should be able to install it in a business week or less. what losers! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

OT: Reading the Oracle Tea Leaves

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

RE: OT: Reading the Oracle Tea Leaves

2001-04-26 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: UTL_FILE error

2001-04-27 Thread MacGregor, Ian A.
: 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services

RE: UTL_FILE error

2001-04-27 Thread MacGregor, Ian A.
myself on having some sort of familiarity. Pride goeth before a fall. Any other ideas? David A. Barbour Oracle DBA, OCP(and still searching for enlightenment) This is MacGregor, Ian A. wrote: You need to handle the exception, for example Exception When no_data_found

After Update on TABLE_NAME For Each Row... Triggers and R.I.

2001-05-03 Thread MacGregor, Ian A.
the parent table, and then raises an exception if no parent key is found. Is there another way? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City

RE: After Update on TABLE_NAME For Each Row... Triggers and

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

RE: Getting ORA-01732 trying to insert into table (NOT view)

2001-05-04 Thread MacGregor, Ian A.
') 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: MacGregor, Ian A. INET: [EMAIL

RE: ODBC Connections Bad?

2001-05-11 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL

RE: dbms_job.remove

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

RE: Explain plan of a table you do not own

2002-09-23 Thread MacGregor, Ian A.
') 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: MacGregor, Ian A. INET

RE: How to reproduce a hanging connect attempt

2002-09-24 Thread MacGregor, Ian A.
(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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

ODBC Security Problems

2002-09-26 Thread MacGregor, Ian A.
Do you use ODBC to download data to say, EXCEL? The following will be of interest http://www.ciac.org/ciac/bulletins/m-127.shtml Ian Macgregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian

RE: Changing the Staus of a Database to Read Only

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

ORA-1115

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

Goddess Abuse Time

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

Why Use Anydata?

2002-10-04 Thread MacGregor, Ian A.
: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: DBMS_STATS.GATHER_DATABASE_STATS analyzes SYS and SYSTEM inde

2002-10-07 Thread MacGregor, Ian A.
: 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network

RE: Why Use Anydata? DBA Woes

2002-10-07 Thread MacGregor, Ian A.
ignored. Rachel --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I remember when anydata was first discussed a few months ago. I questioned how it could be part of proper database design; from what domain would the anydata column draw its values? As I recall everyone advised against its use

RMAN and TSM

2002-10-09 Thread MacGregor, Ian A.
catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Making a tablespace read-only - identifying blocking tx

2002-10-09 Thread MacGregor, Ian A.
Title: Message Just a slight correction it will wait until any transaction against the entire database, not just the tablespaceis completed. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]] Sent:

OT: RE: CodeNotes for Oracle9i...

2002-10-15 Thread MacGregor, Ian A.
') 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: MacGregor, Ian

RE: Access with ACCESS

2002-10-17 Thread MacGregor, Ian A.
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 8.1.7.2 or 8.1.7.4

2002-10-11 Thread MacGregor, Ian A.
Title: Message There is a new listener bug detailed in security alert 42 which allows someone to execute a Denial of Service attack by crashing or hanging the listener. For Oracle 8i I only see patches at the 8.1.7.4 level. Interestingly, the 8.0 database listener is notvulnerable. Ian

RE: Database Design: unique PK across all tables

2002-11-04 Thread MacGregor, Ian A.
ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

OT: Oracle Embraces the Grid

2002-11-07 Thread MacGregor, Ian A.
http://computerworld.com/hardwaretopics/hardware/story/0,10801,75700,00.html Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services

RE: Changing column format

2002-11-08 Thread MacGregor, Ian A.
://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: Data Purging Strategy

2002-11-08 Thread MacGregor, Ian A.
-- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

RE: Oracle 10i

2002-11-08 Thread MacGregor, Ian A.
, 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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat

RE: Oracle 10i new releases

2002-11-08 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

ASO Checksumming Parameters

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

RE: ASO Checksumming Parameters

2002-11-19 Thread MacGregor, Ian A.
: returning status: connection in progress any idea what is wrong or missing? The client is 9.0.1.3 and the server is 9.0.1.4 both on Solaris 8 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian

RE: Oracle9i : OLAP and Data Mining Options

2002-07-18 Thread MacGregor, Ian A.
-- Author: MacGregor, Ian A. 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

Is Statspack a Security Problem?

2002-07-24 Thread MacGregor, Ian A.
MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Explain Plan and SQL Text Length

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

RE: Explain Plan and SQL Text Length

2002-07-24 Thread MacGregor, Ian A.
-- Author: MacGregor, Ian A. 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: Is Statspack a Security Problem?

2002-07-24 Thread MacGregor, Ian A.
I'm not saying it's not fixable. The creation of dba level accounts such as dbsnmp and outln by Oracle is fixable as well. But I'll wager there are folks out there who didn't know the grants on the statspack tables were to public. Of course none of our developers or ad hoc query writers

RE: Cursor Sharing| Soft Parsing

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

RE: Cursor Sharing| Soft Parsing

2002-07-25 Thread MacGregor, Ian A.
12:38 AM To: Multiple recipients of list ORACLE-L On Wednesday 24 July 2002 22:08, MacGregor, Ian A. wrote: Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables

RE: Cursor Sharing| Soft Parsing

2002-07-25 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City

RE: Cursor Sharing| Soft Parsing

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

Open -- Parse --Execute -- Fetch Rows -- Close

2002-07-26 Thread MacGregor, Ian A.
for an appointment. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 12:38 AM To: Multiple recipients of list ORACLE-L On Wednesday 24 July 2002 22:08, MacGregor, Ian A. wrote: Please define soft parsing

RE: Hot tables and Their Costs

2002-07-30 Thread MacGregor, Ian A.
Title: Message You already have paret of what you need from the stats$sql_summary table which tells you how often a statement has been executed. Bear in mind this table will truncate any statement to 1000 bytes. You will probably also need the stats$sqltext table. This table was added to

RE: Table Naming Conventions

2002-07-31 Thread MacGregor, Ian A.
-- Author: MacGregor, Ian A. 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: Table Naming Conventions

2002-07-31 Thread MacGregor, Ian A.
') 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: MacGregor, Ian

RE: soft parse

2002-08-02 Thread MacGregor, Ian A.
We had a detailed discussion about this very thing a little overoneweek ago. Check the archives for messages with the subject, "Cursor Sharing| Soft Parse." Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message-From: BigP [mailto:[EMAIL

OT: Windows 2000 SP3 License Agreement

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

Data Type in A View

2002-08-03 Thread MacGregor, Ian A.
that. However this results in, ORA-12060: shape of prebuilt table does not match definition query. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City

RE: missed Anjo's webcast..

2002-08-08 Thread MacGregor, Ian A.
Title: RE: missed Anjo's webcast.. First, I didn't see the broadcast. I believe the claim that a high BHR may not indicate a healthy system, has become it is always indicative of an unhealthy system. Egad, by BHR is over 90% and no users are are complaining, I better start tinkering! Isn't

RE: missed Anjo's webcast..

2002-08-08 Thread MacGregor, Ian A.
ear Accelerator Center [EMAIL PROTECTED] [MacGregor, Ian A.]-----Original Message-From: MacGregor, Ian A. Sent: Thursday, August 08, 2002 2:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: missed Anjo's webcast.. First, I didn't see the broadcast. I believe the claim that

No Disk I/O Associated With The Session ???

2002-08-09 Thread MacGregor, Ian A.
To: MacGregor, Ian A.; Multiple recipients of list ORACLE-L Ian, You have run into something that I've seen in the past which is a performance problem, but which is not caused by a bad BHR. What I have noticed are PeopleSoft queries, done by their query tool(YUCK), that have all of their data

Case Statements, Distributed Queries, ORA-22804 Errors

2002-08-12 Thread MacGregor, Ian A.
://www.orafaq.com -- Author: MacGregor, Ian A. 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: Context indexes

2002-08-14 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

UTF-16

2002-08-21 Thread MacGregor, Ian A.
the default character set for SQL NCHAR datatypes. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: DB Refreshes

2002-08-27 Thread MacGregor, Ian A.
(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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Seconds in Wait

2002-08-30 Thread MacGregor, Ian A.
Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Slightly OT: Rounding Negative Numbers

2002-08-30 Thread MacGregor, Ian A.
://www.orafaq.com -- Author: MacGregor, Ian A. 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: Seconds in Wait

2002-08-30 Thread MacGregor, Ian A.
://www.orafaq.com -- Author: MacGregor, Ian A. 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: automatic segment space management

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

RE: automatic segment space management

2002-09-03 Thread MacGregor, Ian A.
--- MacGregor, Ian A. [EMAIL PROTECTED] wrote: The question posed was not whether extent management local should be used, but whether automatic segment space management should be used. As this is a data warehouse, I would not expect you to have transactions trying to change the same block

Sampling V$SESSTAT

2002-09-04 Thread MacGregor, Ian A.
have a listing of the most useful statistics that they would like to share? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: ANSI Isolation Levels

2002-09-05 Thread MacGregor, Ian A.
: http://www.orafaq.com -- Author: MacGregor, Ian A. 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: ANSI Isolation Levels

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

RE: OPS Sequences: nocache == order ??

2002-09-06 Thread MacGregor, Ian A.
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: MacGregor

RE: OPS Sequences: nocache == order ??

2002-09-07 Thread MacGregor, Ian A.
://www.orafaq.com -- Author: MacGregor, Ian A. 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: copying all schemas except sys

2002-09-19 Thread MacGregor, Ian A.
: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send

RE: ORA_ENCRYPT_LOGIN

2002-05-21 Thread MacGregor, Ian A.
Title: SQL Server to Oracle DB Even without this parameter being setthe password is encrypted. What the parameter does is stop the password from being sent in the clear if logging in with the encrypted password fails. I believe the encryption is a 54-bit variant of DES. It is very rare

RE: Data Warehouse experts, a simple question for you| Outdated?

2002-05-21 Thread MacGregor, Ian A.
: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Oracle 9i and Tables Owned by SYS

2002-05-21 Thread MacGregor, Ian A.
they be granted individually? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Oracle 9i and Tables Owned by SYS

2002-05-22 Thread MacGregor, Ian A.
procedure successfully completed. hth Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I am in the process of moving a small database to Oracle 9.0.1.3. I have installed my own space management spaces. It measures growth of objects and tablespace usage and works well in Oracle 8i

RE: ORA_ENCRYPT_LOGIN

2002-05-22 Thread MacGregor, Ian A.
on developer workstations, so that the password is not sent in the clear? -Original Message-From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 21, 2002 8:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA_ENCRYPT_LOGIN Even without this parameter

RE: Oracle 9i and Tables Owned by SYS

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

RE: Data Warehouse experts, a simple question for you

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

RE: Statistical sampling and representative stats collection

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

RE: Statistical sampling and representative stats collection

2002-05-24 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL

RE: Statistical sampling and representative stats collection

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

CLOBS AND Semicolons

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

RE: INDEX move

2002-06-05 Thread MacGregor, Ian A.
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: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Wrong Results Bug in Oracle 8.1.7.1

2002-06-08 Thread MacGregor, Ian A.
. === Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-09 Thread MacGregor, Ian A.
Yep sure is. Ian -Original Message- Sent: Sunday, June 09, 2002 5:43 AM To: Multiple recipients of list ORACLE-L Ian, is that peopleslop? joe MacGregor, Ian A. wrote: SQL SELECT VOUCHER_ID FROM PS_VCHR_MM_VW WHERE ROWNUM 10; VOUCHER_ 3394 3395 3396

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-09 Thread MacGregor, Ian A.
in development and working in production. Ian -Original Message- Sent: Sunday, June 09, 2002 7:13 PM To: Multiple recipients of list ORACLE-L what modules, if you dont mind me asking, i'm at a site where we're going to implement HR, Financials And EPM soon. thanks, joe MacGregor, Ian A. wrote

RE: Wrong Results Bug in Oracle 8.1.7.1

2002-06-10 Thread MacGregor, Ian A.
-Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: Wrong Results Bug in Oracle 8.1.7.1 Accounts payable. But this is not a Peoplesoft problem, but an Oracle one. I tried

RE: ldap info

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

  1   2   3   4   >