date:20010228


** Oracle Licensing Compaq Software For 9i Product

Hoping to make its upcoming Oracle 9i Real Application Clusters 
software as attractive to as wide an audience as possible, Oracle 
will build pieces of Compaq Computer's TruCluster technology into 
the Oracle product under a new licensing deal announced Tuesday. 
The move will add management capabilities to Real Application 
Clusters and make the software more portable, according to 
Oracle.

While clustering might sound like technology that only a geek 
could love, it's critical to management efforts to improve the 
availability and scalability of IT systems. Real Application 
Clusters, perhaps the most significant component of the Oracle 9i 
database due out around mid-year, will allow the database to run
over a cluster of servers without changing the applications that 
run on the database--especially online-transaction-processing 
software. Oracle's current clustering technology, Oracle Parallel 
Server, has been a slow seller because it requires making complex 
changes to application code.

The TruCluster Server code is expected to first appear in the 
second release of Real Application Clusters, due out by year's 
end. Oracle and Compaq already have a tight development 
relationship: Compaq's Tru64 Unix OS is the development platform 
for Real Application Clusters. "We recognize that they have 25 
years' experience with clustering," says Juan Jones, VP of 
Oracle's systems platform division. He was referring to Digital 
Equipment Corp., which developed advanced clustering technology 
long before its 1998 acquisition by Compaq. - Rick Whiting, InformationWeek
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: How do i Cofigure oracle 8 i?

2001-02-28 Thread Mark Leith


First off, go and get the Installation Guide for your specific platform -
www.technet.oracle.com
Then go ahead and find the Oracle 8i Reference Guide -
www.technet.oracle.com
Then the Net8 Admin Guide - www.technet.oracle.com
Then the Oracle8i Admin Guide.. from www.tecblah.debaldeblah.com
You get the picture. We cannot answer every question that you may come
accross while doing this, so your best bet is to get the guides, read them,
attempt your task, try to find the answer in the manual, and then if you
fail, come to list..



-Original Message-
Ranjan
Sent: Wednesday, February 28, 2001 09:36
To: Multiple recipients of list ORACLE-L


Hi guys,

I have to use Oracle 8i for one of my project.
I have work on oracle7 , but Oracle 8i is bit confusing for me.

First the installation there are two installer OracleClient and OracleNet .
Each has got foure different type of installation like programmer,
administrator, etc.

I have installed custom type on my interanet server of OracleNet and custom
type on my machine of OracleClient .

Now I need to know what kind of cofiguration i need to do on both the
machine.
how do i create and where do i create my database.
And how do i comuunicate with my database?


I don't know how and where to start?



Thanx in advance
rajiv


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajiv Ranjan
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Mark Leith
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Oracle's Updates Subscription Service

2001-02-28 Thread Weaver, Walt


Say, is it just me or has the cost of the Updates Subscription Service gone
up considerably in the past six months or so? 

We're currently pricing out what it'll cost us to purchase 8.1.7 Standard
Edition and the numbers we're getting are a heck of a lot higher than they
were in November.

Has the cost of CD-ROM's gone up that much? Is the economy now in an
inflationary period? Where's Allen Greenspan when you need him?

Whatever happened to those hazy, golden, halcyon days when upgrades were
included in product support?

Sometimes, Oracle just sucks. I'm seriously considering getting on track for
a MySQL certification.   :)

--Walt Weaver
  Bozeman, Montana, USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re:ODS


Murali,

Since we use what I really believe is an Operational Data Store or ODS, I'll
provide the insight from here, others may have their own opinion.

We are a manufacturer of power components, little modules that fit into
larger power supplies, like the one in your PC.  As a result we have a number of
manufacturing lines each building different or the same product at the same
time.  Each of these lines has a number of automatic testers that test the
product.  These testers need data on the specifications that they are to test
the modules to at each point in the process and they also need a location where
they send the results of those tests.  On top of all that we also collect
statistical process control data and failure analysis data when a technicians
repair a defective module, at least before it gets filled with epoxy.  All of
this data is flowing through the factory all day, 24x7.  On top of that
engineers are looking at the results data looking for trends in both tester
performance from lost of angles, and module behavior.  Yes this ODS does feed
into our Data Warehouse on a daily basis, but of more importance is the
real-time monitoring that occurs to keep yields in line with company
expectations.

What size is this monster, 100GB and growing at about 20% per year (who said
anything about a recession).  We use EMC disk with mirroring, a HP9000 K570 as
the processor with redundant processors and power supplies, and the box will be
getting EMC's PowerPath software in a month or so.  The block size is 8K and the
SGA is running around 500MB, believe it or not the biggest performance boost we
gave the instance was to raise the shared pool to 150M.  We use 4 DBWR slaves
and 10M logfiles to keep the recovery granularity fairly fine, although we
haven't had to recover this db in over 4 years.  This system is running 24x7,
gets quarterly cold backup with weekly hot backups, runs in archivelog mode, and
dedicated server.  One note, the predecessor to the current computer set the
company record for uptime on a HP-UX box at 18 months, including the database. 
On an average day I'd estimate that this system takes in half to 1GB of data and
sends out better than 10GB in answer to user requests. We also "retire" to tape
approximately 100MB of data a day and dump 300MB of redundant data each day too.

Dick Goulet

Reply Separator
Author: "Murali Vallath" [EMAIL PROTECTED]
Date:   2/27/2001 12:39 PM


Hello Everyone,

This new term Operational Data Store(ODS) has many definitions, like staging 
area to the data warehouse, data mart, A data warehouse or reporting 
database,  a archive area etc etc. updated almost real time.

From your experience, is this being used in the Oracle world. What size are 
these databases? What configuration is this on? What is the uptime?

I have a requirement that this should be a 24*7 database. Anyone would like 
to share their experiences.

Regards,

Murali Vallath

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Murali Vallath
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: 
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

8.1.6 upgrade

2001-02-28 Thread Kevin Kostyszyn


Hi all,
Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0?  I have done
exactly what oracle said to do and it appears as though it is missing a .dll
and without the installation is hosed.  Do you have to upgrade to some other
version first?  The instance I upgraded was 8.1.6.1, then when it crashed I
tried a reinstall and it still gives me the same error.  Any help would be
great, I see nothing in the documentaition with the patch that says I have
to be at anything other than 8.1.6.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: Creating activity in a database

Title: RE: Creating activity in a database





Can you illustrate pt. 3 please; 


|| i'd have to do the same thing you will, namely, pull
 an RTFM on the logminer facility..


some one told me that I must run the database in ARCHIVELOG mode in order to get a good activity in there. Is that true? 

|| Was he wearing an Armani suit? Did he smell like Eau de Ferrari? I think you can easily
 pop out a few redo logs thru logminer w/o running in A/L mode...and, btw, if you are
 doing a performance test...for a PRODUCTION database...you'll be in A/L mode *anyway*.
 Unless, of course, you are a up-and-coming benchmark engineer, and you'll be running
 without any logging.


How does it matter?


|| This is the kind of question Eric Pierce handles with aplomb. My best answer
 would be to refer you to him.

Re: Connection manager

2001-02-28 Thread Don Jerman


Been there -- I don't know about availability, but this is what we have to
do for people working at home through their ISP.  I'm assuming NAT
produces similar problems.  You can use CMAN for firewall tunnelling with
or without MTS, don't know about connection concentration, though, as we
don't need it yet.

Background: on NT and some other OS's, Oracle listeners use a different
port for reply (like FTP does), so the NAT server doesn't equate the
incoming reply packets with the outgoing connection.  Most NAT servers
recognize and compensate for FTP connections, but not for Oracle.  CMAN
will not redirect its clients to another port, so the server-side redirect
is hidden and the client remains connected.

Fix: On the server subnet, establish a CMAN server with a fixed address
and (if necesary) make the firewall server route all incoming connections
to 1620 (or whatever port you're using) to it.  You'll need to use a
different port than the Oracle listener if you're running CMAN on the
oracle server.  See the docs to configure CMAN appropriately for your
network security needs. By default it's fairly promiscuous so you'll
probably want to make sure it only connects to Oracle servers inside your
subnets, and you may want to restrict the outside addresses it will
serve.  Once I copied the sample config files into the ADMIN directory I
was able to get it running with no complications, but I did revisit the
routing issue for our site.

In the TNSNAMES file of the client (or in the naming service, whatever
you're using) add (SOURCE_ROUTE=ON) and add an address line for each CMAN
server needed to reach the oracle server (if, for instance, you have
multiple DMZ layers you may need multiple CMAN servers to make connections
visible.).  The CMAN servers will be sent the description information and
will establish the connection to the next leg of the route (another CMAN
server or the data server).  Naturally, each CMAN server needs to be able
to resolve the address of the server that comes after it in the route.

Since you didn't list the errors, I assume this will work.  It's possible
the client needs a CMAN server on the back side of their NAT server, too,
but probably not, unless you're doing server-to-server connections.  If
they do, just add it to the address list in the appropriate order.

Here's a sample TNSNAMES entry (this is what gave me the most trouble):
MYSERVER.MY.ORG =
  (DESCRIPTION =
(SOURCE_ROUTE = ON)
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = FIREWALL.MY.ORG )(PORT = 1620))
  (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVER.MY.ORG)(PORT = 1521))
)
(CONNECT_DATA =
  (SERVICE_NAME = MY_SERVICE.MY.ORG)
)
  )

Hope that helps!


[EMAIL PROTECTED] wrote:

 Looking for some help with Connection  Manager.
 Suddenly got hit with a NAT issue from a customer site.

 Any suggestions on the use of Connection manager to alleviate this
 situation would be appreciated.

 Also:

 a)   Does Connection manager require the use of MTS?

 b)   Is Connection manager available with both Standard edition and
 Enterprise edition?

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author:
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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).


begin:vcard 
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology,Division of Highways
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology,Division of Highways=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard

Re: 8.1.6 upgrade

2001-02-28 Thread TCarlson



We have done this on several machines without a problem. Don't use the
patch on server running Designer 6.5. Bad Mojo.
I have an open iTAR with Oracle about this.

Todd Carlson
Oracle 8  8i Certified DBA
Bunge Corporation


   
   
"Kevin 
   
Kostyszyn"   To: Multiple recipients of list ORACLE-L  
   
kevin@dulcia[EMAIL PROTECTED]
   
n.com   cc:   
   
Sent by: Subject: 8.1.6 upgrade
   
root@fatcity.  
   
com
   
   
   
   
   
02/28/2001 
   
09:25 AM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




Hi all,
   Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0?  I have
done
exactly what oracle said to do and it appears as though it is missing a
.dll
and without the installation is hosed.  Do you have to upgrade to some
other
version first?  The instance I upgraded was 8.1.6.1, then when it crashed I
tried a reinstall and it still gives me the same error.  Any help would be
great, I see nothing in the documentaition with the patch that says I have
to be at anything other than 8.1.6.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: 
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: Oracle's Updates Subscription Service

Title: RE: Oracle's Updates Subscription Service





Walt, you have just shattered my picture of you as a gentle man
surrounded by docile ruminants, never uddering a discouraging word. 


Yes, it's amazing, the price of the software. My line to folks
is: For your money, Oracle is the best database...if it were my
money, it would be almost anything but..


MySQL *is* tunable.could be fun


-Original Message-
From: Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle's Updates Subscription Service



Say, is it just me or has the cost of the Updates Subscription Service gone
up considerably in the past six months or so? 


We're currently pricing out what it'll cost us to purchase 8.1.7 Standard
Edition and the numbers we're getting are a heck of a lot higher than they
were in November.


Has the cost of CD-ROM's gone up that much? Is the economy now in an
inflationary period? Where's Allen Greenspan when you need him?


Whatever happened to those hazy, golden, halcyon days when upgrades were
included in product support?


Sometimes, Oracle just sucks. I'm seriously considering getting on track for
a MySQL certification. :)


--Walt Weaver
 Bozeman, Montana, USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
 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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: ODS

Title: RE: ODS





Dick, 


100gb allocated or actually used?


thx


Ross


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:ODS



Murali,


 Since we use what I really believe is an Operational Data Store or ODS, I'll
provide the insight from here, others may have their own opinion.


 We are a manufacturer of power components, little modules that fit into
larger power supplies, like the one in your PC. As a result we have a number of
manufacturing lines each building different or the same product at the same
time. Each of these lines has a number of automatic testers that test the
product. These testers need data on the specifications that they are to test
the modules to at each point in the process and they also need a location where
they send the results of those tests. On top of all that we also collect
statistical process control data and failure analysis data when a technicians
repair a defective module, at least before it gets filled with epoxy. All of
this data is flowing through the factory all day, 24x7. On top of that
engineers are looking at the results data looking for trends in both tester
performance from lost of angles, and module behavior. Yes this ODS does feed
into our Data Warehouse on a daily basis, but of more importance is the
real-time monitoring that occurs to keep yields in line with company
expectations.


 What size is this monster, 100GB and growing at about 20% per year (who said
anything about a recession). We use EMC disk with mirroring, a HP9000 K570 as
the processor with redundant processors and power supplies, and the box will be
getting EMC's PowerPath software in a month or so. The block size is 8K and the
SGA is running around 500MB, believe it or not the biggest performance boost we
gave the instance was to raise the shared pool to 150M. We use 4 DBWR slaves
and 10M logfiles to keep the recovery granularity fairly fine, although we
haven't had to recover this db in over 4 years. This system is running 24x7,
gets quarterly cold backup with weekly hot backups, runs in archivelog mode, and
dedicated server. One note, the predecessor to the current computer set the
company record for uptime on a HP-UX box at 18 months, including the database. 
On an average day I'd estimate that this system takes in half to 1GB of data and
sends out better than 10GB in answer to user requests. We also retire to tape
approximately 100MB of data a day and dump 300MB of redundant data each day too.


Dick Goulet


Reply Separator
Author: Murali Vallath [EMAIL PROTECTED]
Date: 2/27/2001 12:39 PM



Hello Everyone,


This new term Operational Data Store(ODS) has many definitions, like staging 
area to the data warehouse, data mart, A data warehouse or reporting 
database, a archive area etc etc. updated almost real time.


From your experience, is this being used in the Oracle world. What size are 
these databases? What configuration is this on? What is the uptime?


I have a requirement that this should be a 24*7 database. Anyone would like 
to share their experiences.


Regards,


Murali Vallath


_
Get your FREE download of MSN Explorer at http://explorer.msn.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Murali Vallath
 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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: 
 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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: 8.1.6 upgrade

2001-02-28 Thread Boivin, Patrice J


I just upgraded my test server from 8.1.6.1.1. to 8.1.6.3.0, then up to
8.1.6.3.1..  You can get 8.1.6.3.1. at
ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81pat
chsets/81631/ 

I had previously installed a trial version of Savant QDiagnostics, but after
de-installing the thing I am left with a QDBA account that cannot be
deleted.

Drop user qdba cascade hangs whether I do it from DBA Studio, SQL*Plus or
svrmgrl.

I logged a TAR with Oracle, their response was to ask me a dozen questions,
as if they haven't seen this before.

I created a dummy user, created a table, inserted some records into it, then
successfully dropped the table and the user.  So I think this has to do with
either memory shortage on my test machine, or the QDBA user itself.  Perhaps
those "compressed" packages it owns in the database.

Anyway, I had no apparent problems, except now the Oracle Management Server
service refuses to start, it says something like "the environment pointers
have changed".  I haven't logged a TAR regarding that yet, I have to answer
the dozen questions Oracle Support threw at me.

Let me know if you find out anything more, we plan to upgrade to 8.1.6 this
summer and I have to verify that this version is actually stable.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Rgion des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 



-Original Message-
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, February 28, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Subject:8.1.6 upgrade

Hi all,
Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0?  I
have done
exactly what oracle said to do and it appears as though it is
missing a .dll
and without the installation is hosed.  Do you have to upgrade to
some other
version first?  The instance I upgraded was 8.1.6.1, then when it
crashed I
tried a reinstall and it still gives me the same error.  Any help
would be
great, I see nothing in the documentaition with the patch that says
I have
to be at anything other than 8.1.6.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Boivin, Patrice J
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re:ODS

2001-02-28 Thread Bill Conner



i have used ODS, mostly to get data off the production server for report 
generation,
but sense it was there i also used it to data loads into a DWH.  This cut 
out the
impact on the production server on the data scrubbing part of loading the DWH.


Hello Everyone,

This new term Operational Data Store(ODS) has many definitions, like staging
area to the data warehouse, data mart, A data warehouse or reporting
database,  a archive area etc etc. updated almost real time.

 From your experience, is this being used in the Oracle world. What size are
these databases? What configuration is this on? What is the uptime?

I have a requirement that this should be a 24*7 database. Anyone would like
to share their experiences.

Regards,

Murali Vallath

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Murali Vallath
   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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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:
   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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Bill Conner
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

2/28/01 - PL/SQL Syntax Request

2001-02-28 Thread Gorden-Ozgul, Patricia E


I need help.  I'm sorry if this is a cross-posting for you.

I'd like to see some example PL/SQL code, perhaps a procedure, that will
pass
through each record of a table, test for combinations of column values and
based upon
a specific value (which would be determined by an IF... THEN... matrix), set
a variable.
The value stored in this variable would then be used to update a different
column of the
very same table from which the original record was read.

The matrix:

(IF)   (THEN)
Key A M C  one two three four five

CA  IND   1 1  CZ  STA OFF   BOO  AD
CA  IND   3 1  CZ  STA OFF   REP  AD
CA  IND   1 4  CZ  STA OFF   AV   AD
...
PH  IND   1 1  PH  STA OFF   BOO  PO
PH  OUT   1 1  PH  REF NULL  RBO  PO
...
...


The data table IN (before processing):

Col1 Col2 Col3 Col4  Col5 Col6 Col7 Col8
Col9

CA   IND  31
CA   IND  31
PH   IND  11
CA   IND  14
PH   OUT  11
CA   IND  31
...
...

The data table OUT (after processing):

Col1 Col2 Col3 Col4  Col5 Col6 Col7 Col8
Col9

CA   IND  31 CZ   STA  OFF  REP
AD
CA   IND  31 CZ   STA  OFF  REP
AD
PH   IND  11 PH   STA  OFF  BOO
PO
CA   IND  14 CZ   STA  OFF  AV
AD
PH   OUT  11 PH   REF  NULL RBO
PO
CA   IND  31 CZ   STA  OFF  REP
AD
...
...


I'm looking for the PL/SQL code syntax to perform a task such as this.

Wow.  That was a mouthful.  Good discipline.

Any and all help will be appreciated.


__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gorden-Ozgul, Patricia E
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: Table Storage Estimates

2001-02-28 Thread Sanjay Kumar


Thanks all for the solution. I too thought of having a 1 : 1 relationship by
separating the long raw column from the table. But I believe I am not
permitted to do that (Strange). Since this is a third party product, I
am not suppose to change any of the design issues and also the datatype.

I believe row chaining is obvious in this situation. Also the average row
length is 10M. The size of the database block size is 8.

When I queried the dba_extents to find the number of blocks that have been
occupied, it showed 16620 and the number of rows are 113.

I am totally confused now. Any help greatly appreciated.

Sanjay


- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 12:46 AM


Your estimate comes to around 1 row per block.
What is the average row lenght once data is in the db
? Do you have row chaining ?

What is your block size ? Can you increase it ?

If a lot of queries do not need the long raw column
you can put it in another table with a 1 to 1
relationship with the parent table.

If your planning to have 200 rows of 1 block each, I
do not understand why you are adding datafiles as the
data should not occupied more than 3200K if you
blocksize is 16K. Increase the size of the initial
datafile instead of adding new ones.

--- Sanjay Kumar [EMAIL PROTECTED] a crit : 
Hi,

 I have a table which has a structure similar to the
 following.

 MID NOT NULL
 VARCHAR2(24)
 NAME
 VARCHAR2(512)
 PRIORITY
 NUMBER(38)
 PERSISTENT
 CHAR(1)
 EXP_DATE
 DATE
 BODY
 LONG RAW


 I estimated the table storage for this table using
 the formula given in the Oracle documentation. It
 comes to around 1 rows per block.

 It is estimated that the number of rows for this
 table will not exceed 200.

 My questions are

 1. Doesnt this lead to fragmentation.?
 2. I have added three datafiles to this tablespace
 as of now and it seems like this might require more
 space. How do I effectively redesign this
 table to avoid contention and chaining?

 3. Moreover, initially when there were 105 rows
 inserted, I issued a count(*) and it took about 5
 minutes? How do I reduce the time taken to execute
 the query?


 I would highly appreciate if someone comes forward
 to help me on this.

 I am using Oracle 8.1.6 on Solaris

 Sanjay





=
Stephane Paquette
DBA Oracle
[EMAIL PROTECTED]

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Sanjay Kumar
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: 8.1.6 upgrade

2001-02-28 Thread Kimberly Smith


Check to see if the QDBA account has any jobs set to run.
If so, you should break and remove them.  It does set up
jobs so the chances are good that this is the issue.

-Original Message-
Sent: Wednesday, February 28, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L


I just upgraded my test server from 8.1.6.1.1. to 8.1.6.3.0, then up to
8.1.6.3.1..  You can get 8.1.6.3.1. at
ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81pat
chsets/81631/ 

I had previously installed a trial version of Savant QDiagnostics, but after
de-installing the thing I am left with a QDBA account that cannot be
deleted.

Drop user qdba cascade hangs whether I do it from DBA Studio, SQL*Plus or
svrmgrl.

I logged a TAR with Oracle, their response was to ask me a dozen questions,
as if they haven't seen this before.

I created a dummy user, created a table, inserted some records into it, then
successfully dropped the table and the user.  So I think this has to do with
either memory shortage on my test machine, or the QDBA user itself.  Perhaps
those "compressed" packages it owns in the database.

Anyway, I had no apparent problems, except now the Oracle Management Server
service refuses to start, it says something like "the environment pointers
have changed".  I haven't logged a TAR regarding that yet, I have to answer
the dozen questions Oracle Support threw at me.

Let me know if you find out anything more, we plan to upgrade to 8.1.6 this
summer and I have to verify that this version is actually stable.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Rgion des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 



-Original Message-
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, February 28, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Subject:8.1.6 upgrade

Hi all,
Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0?  I
have done
exactly what oracle said to do and it appears as though it is
missing a .dll
and without the installation is hosed.  Do you have to upgrade to
some other
version first?  The instance I upgraded was 8.1.6.1, then when it
crashed I
tried a reinstall and it still gives me the same error.  Any help
would be
great, I see nothing in the documentaition with the patch that says
I have
to be at anything other than 8.1.6.

Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Boivin, Patrice J
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Kimberly Smith
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: 2/28/01 - PL/SQL Syntax Request

2001-02-28 Thread Khedr, Waleed


You put the following in a table (could be temporary):
Key A M C  one two three four five

CA  IND   1 1  CZ  STA OFF   BOO  AD
CA  IND   3 1  CZ  STA OFF   REP  AD
CA  IND   1 4  CZ  STA OFF   AV   AD
...
PH  IND   1 1  PH  STA OFF   BOO  PO
PH  OUT   1 1  PH  REF NULL  RBO  PO

And then joing it to the original table (or use NL) to update it.

-Original Message-
Sent: Wednesday, February 28, 2001 11:41 AM
To: Multiple recipients of list ORACLE-L


I need help.  I'm sorry if this is a cross-posting for you.

I'd like to see some example PL/SQL code, perhaps a procedure, that will
pass
through each record of a table, test for combinations of column values and
based upon
a specific value (which would be determined by an IF... THEN... matrix), set
a variable.
The value stored in this variable would then be used to update a different
column of the
very same table from which the original record was read.

The matrix:

(IF)   (THEN)
Key A M C  one two three four five

CA  IND   1 1  CZ  STA OFF   BOO  AD
CA  IND   3 1  CZ  STA OFF   REP  AD
CA  IND   1 4  CZ  STA OFF   AV   AD
...
PH  IND   1 1  PH  STA OFF   BOO  PO
PH  OUT   1 1  PH  REF NULL  RBO  PO
...
...


The data table IN (before processing):

Col1 Col2 Col3 Col4  Col5 Col6 Col7 Col8
Col9

CA   IND  31
CA   IND  31
PH   IND  11
CA   IND  14
PH   OUT  11
CA   IND  31
...
...

The data table OUT (after processing):

Col1 Col2 Col3 Col4  Col5 Col6 Col7 Col8
Col9

CA   IND  31 CZ   STA  OFF  REP
AD
CA   IND  31 CZ   STA  OFF  REP
AD
PH   IND  11 PH   STA  OFF  BOO
PO
CA   IND  14 CZ   STA  OFF  AV
AD
PH   OUT  11 PH   REF  NULL RBO
PO
CA   IND  31 CZ   STA  OFF  REP
AD
...
...


I'm looking for the PL/SQL code syntax to perform a task such as this.

Wow.  That was a mouthful.  Good discipline.

Any and all help will be appreciated.


__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gorden-Ozgul, Patricia E
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Khedr, Waleed
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re:RE: ODS


Ross,

There's 100GB in use.  I'm in the process, along with our SA of adding
another 20GB of additional available disk space.  Yeah this a pretty big ODS,
but the end users want a minimum of 90 days back data  with a build plan that
approaches the vertical over the next 6 months!!!

Dick Goulet

Reply Separator
Author: "Mohan; Ross" [EMAIL PROTECTED]
Date:   2/28/2001 7:50 AM

Dick, 

100gb allocated or actually used?

thx

Ross

-Original Message-
Sent: Wednesday, February 28, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L


Murali,

Since we use what I really believe is an Operational Data Store or ODS,
I'll
provide the insight from here, others may have their own opinion.

We are a manufacturer of power components, little modules that fit into
larger power supplies, like the one in your PC.  As a result we have a
number of
manufacturing lines each building different or the same product at the same
time.  Each of these lines has a number of automatic testers that test the
product.  These testers need data on the specifications that they are to
test
the modules to at each point in the process and they also need a location
where
they send the results of those tests.  On top of all that we also collect
statistical process control data and failure analysis data when a
technicians
repair a defective module, at least before it gets filled with epoxy.  All
of
this data is flowing through the factory all day, 24x7.  On top of that
engineers are looking at the results data looking for trends in both tester
performance from lost of angles, and module behavior.  Yes this ODS does
feed
into our Data Warehouse on a daily basis, but of more importance is the
real-time monitoring that occurs to keep yields in line with company
expectations.

What size is this monster, 100GB and growing at about 20% per year (who
said
anything about a recession).  We use EMC disk with mirroring, a HP9000 K570
as
the processor with redundant processors and power supplies, and the box will
be
getting EMC's PowerPath software in a month or so.  The block size is 8K and
the
SGA is running around 500MB, believe it or not the biggest performance boost
we
gave the instance was to raise the shared pool to 150M.  We use 4 DBWR
slaves
and 10M logfiles to keep the recovery granularity fairly fine, although we
haven't had to recover this db in over 4 years.  This system is running
24x7,
gets quarterly cold backup with weekly hot backups, runs in archivelog mode,
and
dedicated server.  One note, the predecessor to the current computer set the
company record for uptime on a HP-UX box at 18 months, including the
database. 
On an average day I'd estimate that this system takes in half to 1GB of data
and
sends out better than 10GB in answer to user requests. We also "retire" to
tape
approximately 100MB of data a day and dump 300MB of redundant data each day
too.

Dick Goulet

Reply Separator
Author: "Murali Vallath" [EMAIL PROTECTED]
Date:   2/27/2001 12:39 PM


Hello Everyone,

This new term Operational Data Store(ODS) has many definitions, like staging

area to the data warehouse, data mart, A data warehouse or reporting 
database,  a archive area etc etc. updated almost real time.

From your experience, is this being used in the Oracle world. What size are 
these databases? What configuration is this on? What is the uptime?

I have a requirement that this should be a 24*7 database. Anyone would like 
to share their experiences.

Regards,

Murali Vallath

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Murali Vallath
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: 
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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

RE: Oracle's Updates Subscription Service

2001-02-28 Thread Weaver, Walt

Title: RE: Oracle's Updates Subscription Service

Well
Ross, Our campus is out in the country (just about everywhere in Montana is out
in the country) and we are, indeed, surrounded by docile ruminants. I'd like to
say that during our off-time we go out and gaze lovingly at their udders, but
there are other things we prefer to gaze at lovingly.

Of
course, we have no problems doing online dairy backups around here.
:)

We use
MySQL here and yes it's tunable. There's even word out on the street that soon
MySQL may support the concept of a transaction. What a
concept.

MySQL
has its place, but it's causing us no end of pain here. It doesn't scale well
enough to support what we're doing. That's why we're painfully biting the bullet
and paying the big bucks for Oracle.

--Walt
Weaver

Bozeman, Montana, USA

-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 28, 2001
8:51 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Oracle's Updates Subscription Service
Walt, you have just shattered my picture of you as a gentle
man surrounded by docile ruminants, never uddering a
discouraging word.
Yes, it's amazing, the price of the software. My line to
folks is: "For your money, Oracle is the best
database...if it were my money, it would be almost
anything but.."
MySQL *is* tunable.could be fun
-Original Message- From:
Weaver, Walt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Subject: Oracle's Updates Subscription Service
Say, is it just me or has the cost of the Updates Subscription
Service gone up considerably in the past six months or
so?
We're currently pricing out what it'll cost us to purchase
8.1.7 Standard Edition and the numbers we're getting
are a heck of a lot higher than they were in
November.
Has the cost of CD-ROM's gone up that much? Is the economy now
in an inflationary period? Where's Allen Greenspan
when you need him?
Whatever happened to those hazy, golden, halcyon days when
upgrades were included in product support?
Sometimes, Oracle just sucks. I'm seriously considering
getting on track for a MySQL
certification. :)
--Walt Weaver Bozeman, Montana,
USA -- Please see the official
ORACLE-L FAQ: http://www.orafaq.com --
Author: Weaver, Walt
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-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
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).

Re:RE: RE: MetaSlop - Another Response Scenario for Paul.


Is Oracle trying to drive us nuts?  Why of course they are.  Take today, the OTS
phone line said that metastink was up and available, but when I got an analyst
he told me they had mail from the "metalame support team" that it would be down
until early afternoon, Florida time?

Reply Separator
Author: "Kevin Kostyszyn" [EMAIL PROTECTED]
Date:   2/28/2001 8:16 AM

RE: RE: MetaSlop - Another Response Scenario for Paul.I just don't think
that I can stand metalink much longer!!  Is Oracle trying to drive all of us
nutz, if so, at least they are getting that right!!!
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, Ross
  Sent: Tuesday, February 27, 2001 4:58 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: RE: MetaSlop - Another Response Scenario for Paul.


  Scenario Two:

  ## For Immediate Release
###

  Ap/UPI/AFP/Reuters ---  Redwood Shores, 27 Feb 00

  Oracle Denial of Service Attack

  Oracle Corporation announced today, in a stunning revelation, that
  they have been issuing a massive Denial of Service (DoS) attack against
  its own customers via its "Support" website, MetaBlink.

  The scam worked like this:  clever hackers within Oracle Corporation
  configured MetaLink with Oracle default values, guaranteeing devastating
  failure. As long term Oracle customers, sorely vexed by arcane command
sequences,
  byzantine product offerings, and constantly shifting product versions
  came to the "support web site" to seek help, they were shunted away,
  losing hours of productive time, watching key applications fail,
  marriages dissolve, and world peace slip from their grasp.

  Precisely at this vulnerable moment, a crack team of marketers ( or a
  team of crack-smoking marketers, field reports are not clear ) created
  a campaign to lead key customers to believe "application upgrades" and
  "more hardware" were the problem.

  Sources in the McNealy Command Bunker indicate Oracle's innovative DoS
  is working, as record numbers of customers are throwing massive amounts
  of hardware at problems relatively easy to rectify. Further, back at
  Armani HQ, Redwood Shores, initial reports are that the "application
upgrades"
  orders are coming in quickly.

  IBM, HP, and other industry leaders are likely to follow the Oracle
Corporation
  trend, and begin to knock off key customers shortly, using a combination
of
  DoS, confusing price plans, deliriously inaccurate marketing campaigns,
  and other tools of corporate psychological warfare.

  ( - Ross Mohan, Cub Reporter, Daily Planet )

  -Original Message-
  From: Paul Baumgartel [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, February 27, 2001 3:21 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: RE: MetaSlop



  And if you were running a comparable system, what would *you* say?



  Paul Baumgartel
  InstiPro, Inc.
  [EMAIL PROTECTED]
  212 813-0829 x103 (office)
  917 549-4717 (mobile)



  -Original Message-
  Sent: Tuesday, February 27, 2001 2:51 PM
  To: Multiple recipients of list ORACLE-L



  Man, these guys just invite the wise-ass comment, don't they?  Such as:

  Well maybe if the product worked better/was less confusing/had better
  documentation we wouldn't all be in Metalink!
  Oh no!  If 4 new servers brought the system to its knees just think how
bad
  it'll be when the rest of the hardware arrives!
  4 new top-of-the-line servers, just think what that'll do to their power
  unit charges!

  Plus I can't rid myself of the image of us all 'staggering' to Metalink
for
  help.

  Jim

   [EMAIL PROTECTED] 02/27/01 01:21PM 
  For those interested, right from the horses mouth, or other orifice as you
  desire:

  News  Notes
MetaLink Performance - An Update




We apologize for the slow response times recently on MetaLink. All over
  the
  world our customers are coming to and using this valuable
knowledge base in staggering numbers. Our Global IT team are working
these
  performance issues as their number one priority.

What is Being Done
This week four new front-end web servers were brought on line to help
  manage
  the load. Additional hardware has been purchased and will
arrive soon which will make a significant improvement in performance.

We appreciate your patience during this time of significant growth in
  MetaLink
  usage.

Thanks,
The MetaLink Team

  --

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEADTITLERE: RE: MetaSlop - Another Response Scenario for
Paul./TITLE
META http-equiv=Content-Type content="text/html; charset=iso-8859-1"
META content="MSHTML 5.50.4207.2601" name=GENERATOR/HEAD
BODY
DIVSPAN class=046201216-28022001FONT face=Arial color=#ff size=2I just

don't think that I can stand metalink much longer!!nbsp; Is Oracle trying to

Re: 2/28/01 - PL/SQL Syntax Request

2001-02-28 Thread Tim Sawmiller


How about:

update table_name set
col5 = decode(string1,string2,'PH',string3 'CZ',).
,col6 = decode(string4,string5,'STA',string6, 'REF',)
,col7 =etc
,col8 =etc

string1 and string4, etc  could be the concatentation of the four determinant columns, 
string 2,3,5,6, etc would be the determining values.

 [EMAIL PROTECTED] 02/28/01 11:41AM 
I need help.  I'm sorry if this is a cross-posting for you.

I'd like to see some example PL/SQL code, perhaps a procedure, that will
pass
through each record of a table, test for combinations of column values and
based upon
a specific value (which would be determined by an IF... THEN... matrix), set
a variable.
The value stored in this variable would then be used to update a different
column of the
very same table from which the original record was read.

The matrix:

(IF)   (THEN)
Key A M C  one two three four five

CA  IND   1 1  CZ  STA OFF   BOO  AD
CA  IND   3 1  CZ  STA OFF   REP  AD
CA  IND   1 4  CZ  STA OFF   AV   AD
...
PH  IND   1 1  PH  STA OFF   BOO  PO
PH  OUT   1 1  PH  REF NULL  RBO  PO
...
...


The data table IN (before processing):

Col1 Col2 Col3 Col4  Col5 Col6 Col7 Col8
Col9

CA   IND  31
CA   IND  31
PH   IND  11
CA   IND  14
PH   OUT  11
CA   IND  31
...
...

The data table OUT (after processing):

Col1 Col2 Col3 Col4  Col5 Col6 Col7 Col8
Col9

CA   IND  31 CZ   STA  OFF  REP
AD
CA   IND  31 CZ   STA  OFF  REP
AD
PH   IND  11 PH   STA  OFF  BOO
PO
CA   IND  14 CZ   STA  OFF  AV
AD
PH   OUT  11 PH   REF  NULL RBO
PO
CA   IND  31 CZ   STA  OFF  REP
AD
...
...


I'm looking for the PL/SQL code syntax to perform a task such as this.

Wow.  That was a mouthful.  Good discipline.

Any and all help will be appreciated.


__
Pat Gorden-Ozgul   BNL-ISD Systems
[EMAIL PROTECTED] 631-344-5159





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Gorden-Ozgul, Patricia E
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Tim Sawmiller
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: 8.1.6 upgrade

Title: RE: 8.1.6 upgrade





as QDBA do


execute q$bgproc.stop_driver;


note the results



log out, then in as internal


drop user qdba cascade;


and



let us know what happens, OK?



-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 8.1.6 upgrade



I just upgraded my test server from 8.1.6.1.1. to 8.1.6.3.0, then up to
8.1.6.3.1.. You can get 8.1.6.3.1. at
ftp://oracle-ftp.oracle.com/server/patchsets/wgt_tech/server/windowsNT/81pat
chsets/81631/ 


I had previously installed a trial version of Savant QDiagnostics, but after
de-installing the thing I am left with a QDBA account that cannot be
deleted.


Drop user qdba cascade hangs whether I do it from DBA Studio, SQL*Plus or
svrmgrl.


I logged a TAR with Oracle, their response was to ask me a dozen questions,
as if they haven't seen this before.


I created a dummy user, created a table, inserted some records into it, then
successfully dropped the table and the user. So I think this has to do with
either memory shortage on my test machine, or the QDBA user itself. Perhaps
those compressed packages it owns in the database.


Anyway, I had no apparent problems, except now the Oracle Management Server
service refuses to start, it says something like the environment pointers
have changed. I haven't logged a TAR regarding that yet, I have to answer
the dozen questions Oracle Support threw at me.


Let me know if you find out anything more, we plan to upgrade to 8.1.6 this
summer and I have to verify that this version is actually stable.


Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO | Région des Maritimes, MPO


E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 




 -Original Message-
 From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, February 28, 2001 11:26 AM
 To: Multiple recipients of list ORACLE-L
 Subject: 8.1.6 upgrade


 Hi all,
  Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0? I
have done
 exactly what oracle said to do and it appears as though it is
missing a .dll
 and without the installation is hosed. Do you have to upgrade to
some other
 version first? The instance I upgraded was 8.1.6.1, then when it
crashed I
 tried a reinstall and it still gives me the same error. Any help
would be
 great, I see nothing in the documentaition with the patch that says
I have
 to be at anything other than 8.1.6.


 Sincerely,
 Kevin Kostyszyn
 DBA
 Dulcian, Inc
 www.dulcian.com
 [EMAIL PROTECTED]


 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Kevin Kostyszyn
  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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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: Boivin, Patrice J
 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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

eek!


We just had an earthquake. I'm fairly freeked.

How's everyone's disaster recover strategy? I'll think I'll be reviewing
ours today.



Dennis Taylor

Niels is bohring.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: Import (urgent)

2001-02-28 Thread Shantanu Talukder


That's not true anymore. In IBM/AIX you have to create
JFS with large file enable option and in addition to
that in your /etc/security/limits file you need to set

fsize=-1, which means 'unlimited'. Now, you can check
it by using 'ulimit' command. 



--- Shankar Shanmugaswamy [EMAIL PROTECTED] wrote:
 Hi,
 
 You can check the size of the DMP file getting
 created , in Unix 
 you cannot exceed more than 2GB.
 Pls check and inform.
 
 S.S
 
  [EMAIL PROTECTED] 02/23/01 06:45AM 
 Hello All
 
 I am getting this error when doing a full import.
 
 IMP-3: ORACLE error 3113 encountered
 ORA-03113: end-of-file on communication channel
 IMP-00021: operating system error - error code (dec
 9, hex 0x9)
 IMP-0: Import terminated unsuccessfully
 
 IMP-00021: operating system error - error code (dec
 9, hex 0x9)
 
 On Oracle 8.0.5 on Solaris 2.6
 
 TIA
 
 -- 
 Sajid Iqbal
 Database Team Leader
 
 
 
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com 
 -- 
 Author: Sajid Iqbal
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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: Shankar Shanmugaswamy
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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).


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shantanu Talukder
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: Beta program opportunity

2001-02-28 Thread Deshpande, Kirti


Hi, 
I am running it on a HP-UX 11.0 server and currently connected to 2
databases. 
Top shows StorageXpert using anywhere between 1 to 9% CPU. I have been
running it since morning (for about 4 hours now).
What version are you using? Mine is Beta Version 1.0b4 build 1.0.4.249. 
Have you contacted Quest?  

- Kirti Deshpande

 -Original Message-
 From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, February 28, 2001 10:55 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Beta program opportunity
 
 I started up StoragExpert and within a about 2 minutes it was using 50% of
 my CPU.  Any ideas?
 
 Ron
 
 -Original Message-
 Sent: Friday, February 16, 2001 1:52 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Okay, here goes. First a disclaimer:  I am NOT getting paid for this.
 I 
 think this is a cool product. I don't promote things on this list if I
 earn 
 income from them. Having said that
 
 I have been participating in a beta (maybe alpha?) program with Quest 
 Software for a new product called StorageXpert. I'm going to include the 
 "marketing/press release" info below, they are opening up the beta program
 
 to anyone who wants it (don't know if it runs against NT as yet).
 
 Having worked with it (and no, I don't know the pricing schedule at all) I
 
 think you guys might want to check it out. I've used it to find hot spots
 on
 
 my disks, and link them back to the tables and queries that are causing
 the 
 problems. I've been able to drag a programmer over and SHOW him what his 
 query is doing to my database. You know the old "a picture is worth a 
 thousand words" cliche?  This is a GRAPHIC display of usage (all those 
 lovely equalizers :)  ).
 
 I showed it to my sysadmin and he freaked.. loved it.
 
 I've been running it for about 4 months now without problems.
 
 So... press release below, those of you who want to play with it, have
 fun, 
 those who don't, please just hit delete.
 
 Rachel
 
 ***
 
 Have you checked out this new cool product StorageXpert for Oracle. This 
 product facilitates detection of the exact cause of the I/O bottlenecks in
 
 your Oracle environment. This product is currently beta from Quest
 Software 
 and it enables you to:
 
 
 - Identify Oracle objects that suffer from I/O bottlenecks
 - Provide storage device usage patterns and I/O wait information
 - Identify programs/SQL contributing to the I/O problem
 - Map I/O operations for Oracle files in the storage devices
 - Easily use the granular and meaningful I/O information which is provided
 a
 
 concise and user-friendly format
 
 
 Beta testing ends March 29th 2001. Discover how you can find the root of 
 your storage bottlenecks today! Please check out the "Systems
 Requirements" 
 link at http://www.quest.com/storage_xpert/system_requirements.asp. You
 can 
 download the product at http://www.quest.com/storage_xpert/. Please send 
 your feedback to [EMAIL PROTECTED] and technical support 
 queries/issues/problems to [EMAIL PROTECTED]
 
 
 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Rachel Carmichael
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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: Smith, Ron L.
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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: Deshpande, Kirti
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT

Help - Tuning SQL

2001-02-28 Thread Armstead, Michael A


I've got some simple questions on tuning SQL. Please reply with references,
I'm not looking for guesses.

*   If you have a SELECT statement with a WHERE clause and 2 AND
clauses, which one is processed first, the WHERE clause, the first AND
clause, or the second AND clause?
*   Is there any performance loss in using "" over "!="?

Michael Armstead
Database Administrator, OCP-Certified
Corporate  Finance Information Systems
Glaxo SmithKline



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Armstead, Michael 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 list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: eek!


At 11:17 AM 2/28/01 -0800, you wrote:
We just had an earthquake. I'm fairly freeked.


See how freaked I was? I mis-spelled 'freaked'.


Dennis Taylor

Niels is bohring.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: eek!

2001-02-28 Thread Ruth Gramolini


Where are you?  RBG

- Original Message - 
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 2:17 PM


 We just had an earthquake. I'm fairly freeked.
 
 How's everyone's disaster recover strategy? I'll think I'll be reviewing
 ours today.
 
 
 
 Dennis Taylor
 
 Niels is bohring.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Dennis Taylor
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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: Ruth Gramolini
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: EXPORT PROBLEM

2001-02-28 Thread Rocky Welch


Hi Mala,
If you're on 8.1.6 it's a bug. If you do your export without the
consistent parameter it should finish okay but you should patch your
current installation.

--- mala singh [EMAIL PROTECTED] wrote:
 Hi DBAs
 
 I have problem at time of full export of Database.The following are the 
 error message at end of full export.
 EXP-8: ORACLE error 1403 encountered
 ORA-01403: no data found
 ORA-06512: at "SYS.DBMS_IJOB", line 450
 ORA-06512: at "SYS.DBMS_IJOB", line 482
 ORA-06512: at line 1
 EXP-0: Export terminated unsuccessfully
 Please help.
 Thanks in advance.
 
 -Mala
 
 

_
 Get Your Private, Free E-mail from MSN Hotmail at
 http://www.hotmail.com.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: mala singh
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: eek!

2001-02-28 Thread Kevin Kostyszyn


Wow, Seattle, that's strange.  I don't remember that happening. 6.2, whoo,
some damage goin on out there.

-Original Message-
Taylor
Sent: Wednesday, February 28, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L


We just had an earthquake. I'm fairly freeked.

How's everyone's disaster recover strategy? I'll think I'll be reviewing
ours today.



Dennis Taylor

Niels is bohring.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis Taylor
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Kevin Kostyszyn
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: eek!

2001-02-28 Thread Maser, Donna (SEA)


Hi Dennis,
  You must be on the west coast!  That was FUN!!  (I'm in the Seattle area,
but originally from Alaska, where earthquakes are 
considered to be more a form of entertainment than a major disaster.)  Did
you run to the computer room as soon as the aftershocks ceased?  Were the
machines all still in place?  If not, you have a problem.
Donna

-Original Message-
Sent: Wednesday, February 28, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L


We just had an earthquake. I'm fairly freeked.

How's everyone's disaster recover strategy? I'll think I'll be reviewing
ours today.



Dennis Taylor

Niels is bohring.


The information contained in this email is intended for the
personal and confidential use of the addressee only. It may
also be privileged information. If you are not the intended
recipient then you are hereby notified that you have received
this document in error and that any review, distribution or
copying of this document is strictly prohibited. If you have
received  this communication in error, please notify Celltech
Group immediately on:

+44 (0)1753 534655, or email '[EMAIL PROTECTED]'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maser, Donna  (SEA)
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: 8.1.6 upgrade

2001-02-28 Thread Jerry C


Hi Kevin,

We had this exact problem. It is a known issue, according to Oracle
"Support". They said it was caused by the following services being left
running during the patch:

MSDTS, SNMP and IIS Admin Services

You need to stop these before applying the patch.

Basically you're hosed. I hope it's not production (as it was with us!). The
"workaround" is to install /upgrade to 8.1.6.3 on another machine (our DBA
used his laptop), and copy all the dll's over.

Hope this helps!

Jerry

- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 2:11 PM


 All dlls are showing.  If nt can find, why isn't oracle?  Is it possible
 that something in the registry got hosed and it is looking in the wrong
spot
 to execute?

 -Original Message-
 Housholder
 Sent: Wednesday, February 28, 2001 12:52 PM
 To: Multiple recipients of list ORACLE-L


 if i remember correctly, on some of the patches for 8.1.6,
 some of the dlls had an ATTRIB of hidden...make sure
 to check folder option, show all types...as well as going out
 to DOS screen...and running ATTRIB *.*

 patrick
 ===
 Patrick Housholder
 Sr. Staff Anl Tech Spt Design
 United Airlines Flight Training Center
 Denver CO


 *-Original Message-
 *From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin
 *Kostyszyn
 *Sent: Wednesday, February 28, 2001 8:26 AM
 *To: Multiple recipients of list ORACLE-L
 *Subject: 8.1.6 upgrade
 *
 *
 *Hi all,
 * Has anyone upgraded 8.1.6 EE on Windows NT to 8.1.6.3.0?  I
 *have done
 *exactly what oracle said to do and it appears as though it is
 *missing a .dll
 *and without the installation is hosed.  Do you have to upgrade to
 *some other
 *version first?  The instance I upgraded was 8.1.6.1, then when it
 *crashed I
 *tried a reinstall and it still gives me the same error.  Any help would
be
 *great, I see nothing in the documentaition with the patch that says I
have
 *to be at anything other than 8.1.6.
 *
 *Sincerely,
 *Kevin Kostyszyn
 *DBA
 *Dulcian, Inc
 *www.dulcian.com
 *[EMAIL PROTECTED]
 *
 *--
 *Please see the official ORACLE-L FAQ: http://www.orafaq.com
 *--
 *Author: Kevin Kostyszyn
 *  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-Mail message
 *to: [EMAIL PROTECTED] (note EXACT spelling 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: Patrick Housholder
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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: Kevin Kostyszyn
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jerry C
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

* Oracle DBAs Needed in the Virginia Beach VA Area..

2001-02-28 Thread Orastaff


Software client needs 3 Oracle DBAs for its' I.T. team to staff a facility
that is relocating from the Northeast U.S. to the Virginia Beach, Virginia area.
The selected candidates May have to work in New Jersey for the first couple
of months..
but will be provided lodging and travel expenses to come home on weekends.
After that, positions will be permanently located in the Virginia Beach area.
One of the candidates selected will be a manager type who will supervise the
group.

* Requirements:
- 3+ yrs Oracle DBA experience on Unix and/or NT platforms
- Possible work in NJ for the first couple of months
- U.S. citizenship or green card required 

These positions offer:
   * Stability 
   * The opportunity to become a key member of the team.
   * Base Salary -up to in the 80's

NO sub contracting positions available.
*U.S. citizenship or green card holders only
PLEASE do not send your resume if you are not in the United States.

Oracle Placement Specialist
OraStaff, Inc.
Ph: 1-800-549-8502-Please do not call if you need sponsorship
Email: [EMAIL PROTECTED]
Please use job code: One/VaBeach/DBA/Merritt/

Note: This is only one of the many opportunities that we have available
across the U.S. 
for candidates with Oracle skills who are U.S. citizens or permanent residents. 
So if this one is not a match for you, we invite you 
to send us your resume- as we quite possibly have the opportunity that you
are seeking.

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the
posiitiondescribed above- if it is not a match for your skills.
Thanks,
Bill Law


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orastaff
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: eek!

2001-02-28 Thread Daniel . Curry


Where was the earthquake?  I am in the SFBay area and have not seen/felt
anything about an earthquake.   


Daniel Curry
Tsola, Inc.
[EMAIL PROTECTED]
650.486.2624

 -Original Message-
Sent:   Wednesday, February 28, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L
Subject:eek!

We just had an earthquake. I'm fairly freeked.

How's everyone's disaster recover strategy? I'll think I'll be reviewing
ours today.



Dennis Taylor

Niels is bohring.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: 
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: eek!


few miles south of Seattle, magnitude 6.2

Someone opined that it was cause by Windows crashing...


At 11:25 AM 2/28/01 -0800, Kevin Kostyszyn wrote:
whoa, where?



Dennis Taylor

Niels is bohring.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: eek!

2001-02-28 Thread Kimberly Smith


It was centered in Seattle.  We felt it here in Portland to.
Nothing like working in a fab, that if a certain something goes
wrong all of Gresham is gone, while in the middle of an earthquake.
Good thing I don't panic easy:-)


-Original Message-
Sent: Wednesday, February 28, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L


We just had an earthquake. I'm fairly freeked.

How's everyone's disaster recover strategy? I'll think I'll be reviewing
ours today.



Dennis Taylor

Niels is bohring.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Kimberly Smith
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

QDBA has been banished from my test server (was RE: 8.1.6 upgrade )

2001-02-28 Thread Boivin, Patrice J


Well, that was gruesome.

I couldn't log in as QDBA, so forget about using dbms_job.

I ended up revoking CONNECT, RESOURCE, and every other role it had.

Then I did a shutdown abort, startup restrict.

QDBA's job was still listed.

I took the risk of issuing a DELETE statement against dba_jobs, and against
the job$ view.  I don't know if that did anything useful but at least there
were no rows returned.

I granted connect, resource back to qdba.

I bounced the database again.

Then I managed to log in as QDBA, and as that user I manually (well, using
SQL scripts) dropped all of this user's objects.

Then I logged in as SYSTEM and I quite enjoyed deleting this beast from my
test machine.

Obviously when you issue a DROP USER command, Oracle doesn't do anything to
clean up that user's jobs - it just hangs.

Live and learn, now I know what to do if this happens again - use a liberal
does of REVOKE statements, GRANT again, then log on as that user.  Drop
everything that user owns manually, because DROP USER is too lazy to do it.
Once you have done DROP USER's job for it, you can issue the DROP USER
command.

Strangely it still took 8i at least ten seconds to drop the user, even
though it didn't own anything.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Rgion des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: EXPORT PROBLEM

2001-02-28 Thread mala singh

I am using 8.1.7.I think this is bug.What isur view
-Mala

From: Rocky Welch [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: EXPORT PROBLEM
Date: Wed, 28 Feb 2001 11:45:51 -0800

Hi Mala,
If you're on 8.1.6 it's a bug. If you do your export without the
consistent parameter it should finish okay but you should patch your
current installation.

--- mala singh [EMAIL PROTECTED] wrote:
  Hi DBAs

  I have problem at time of full export of Database.The following are the
  error message at end of full export.
  EXP-8: ORACLE error 1403 encountered
  ORA-01403: no data found
  ORA-06512: at "SYS.DBMS_IJOB", line 450
  ORA-06512: at "SYS.DBMS_IJOB", line 482
  ORA-06512: at line 1
  EXP-0: Export terminated unsuccessfully
  Please help.
  Thanks in advance.

  -Mala

_
  Get Your Private, Free E-mail from MSN Hotmail at
  http://www.hotmail.com.

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: mala singh
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-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling 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).

=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rocky Welch
   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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: mala singh
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Snapshot refresh and redo log

2001-02-28 Thread Glenn Travis


Is there any way to do a snapshot refresh and not log it?  We refresh
numerous snapshots (materialized views) every hour and it fills up our
archive filesystem pretty heavily.  There is not much other redo log
information generated on this system other than the refresh.  Suggestions?

-- 
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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: eek!

2001-02-28 Thread Weaver, Walt


I'd say the fun quotient is inversely proportional to the number of things
that fall on your head.

At least that was my experience in Fairbanks in 1976 when an earthquake
occured there...

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
Sent: Wednesday, February 28, 2001 12:58 PM
To: Multiple recipients of list ORACLE-L


Hi Dennis,
  You must be on the west coast!  That was FUN!!  (I'm in the Seattle area,
but originally from Alaska, where earthquakes are 
considered to be more a form of entertainment than a major disaster.)  Did
you run to the computer room as soon as the aftershocks ceased?  Were the
machines all still in place?  If not, you have a problem.
Donna

-Original Message-
Sent: Wednesday, February 28, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L


We just had an earthquake. I'm fairly freeked.

How's everyone's disaster recover strategy? I'll think I'll be reviewing
ours today.



Dennis Taylor

Niels is bohring.


The information contained in this email is intended for the
personal and confidential use of the addressee only. It may
also be privileged information. If you are not the intended
recipient then you are hereby notified that you have received
this document in error and that any review, distribution or
copying of this document is strictly prohibited. If you have
received  this communication in error, please notify Celltech
Group immediately on:

+44 (0)1753 534655, or email '[EMAIL PROTECTED]'

Celltech Group plc
216 Bath Road, Slough, SL1 4EN, Berkshire, UK

Registered Office as above. Registered in England No. 2159282
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maser, Donna  (SEA)
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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: Weaver, Walt
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: EXPORT PROBLEM

2001-02-28 Thread Rocky Welch


I hate to say it but consult the metalink. That's how I found out about it
on 8.1.6.

--- mala singh [EMAIL PROTECTED] wrote:
 I am using 8.1.7.I think this is bug.What isur view
 -Mala
 
 From: Rocky Welch [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: Re: EXPORT PROBLEM
 Date: Wed, 28 Feb 2001 11:45:51 -0800
 
 Hi Mala,
 If you're on 8.1.6 it's a bug. If you do your export without the
 consistent parameter it should finish okay but you should patch your
 current installation.
 
 --- mala singh [EMAIL PROTECTED] wrote:
   Hi DBAs
  
   I have problem at time of full export of Database.The following are
 the
   error message at end of full export.
   EXP-8: ORACLE error 1403 encountered
   ORA-01403: no data found
   ORA-06512: at "SYS.DBMS_IJOB", line 450
   ORA-06512: at "SYS.DBMS_IJOB", line 482
   ORA-06512: at line 1
   EXP-0: Export terminated unsuccessfully
   Please help.
   Thanks in advance.
  
   -Mala
  
  
  

_
   Get Your Private, Free E-mail from MSN Hotmail at
   http://www.hotmail.com.
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: mala singh
 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-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling 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).
 
 
 =
 Rocky Welch
 Senior Consultant - Internet Services Group
 Arthur Andersen
 
 __
 Do You Yahoo!?
 Get email at your own domain with Yahoo! Mail.
 http://personal.mail.yahoo.com/
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Rocky Welch
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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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).
 

_
 Get Your Private, Free E-mail from MSN Hotmail at
 http://www.hotmail.com.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: mala singh
   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-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling 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).


=
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen

__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rocky Welch
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

Re: Help - Tuning SQL

2001-02-28 Thread Joseph S. Testa


Since you insisted on no guessing the only true test is for you to do
it.  Since we dont have your database to test it out on,

its time for you to bust out the documentation, look at explain plan,
tkprof,.


Happy testing.

joe

I've got some simple questions on tuning SQL. Please reply with
references,
I'm not looking for guesses.

*   If you have a SELECT statement with a WHERE clause and 2 AND
clauses, which one is processed first, the WHERE clause, the first AND
clause, or the second AND clause?
*   Is there any performance loss in using "" over "!="?

Michael Armstead
Database Administrator, OCP-Certified
Corporate  Finance Information Systems
Glaxo SmithKline

-- 
Joe Testa  http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph S. Testa
  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-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling 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).

RE: eek!