date:20010321

Ok, does someone one to define SRDF and BCV for
those of us that don't have any idea what you're
talking about?

Jared

On Wed, 21 Mar 2001, Koivu, Lisa wrote:

> Hi Yosi, how are you?
>
> I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF
> question but I can tell you that we have BCV's implemented here.  We use
> them for backup and recovery (and it's extremely slick and fast, let me tell
> you!  Worth every penny we paid) However you can also mount the BCV's and
> access the data.  Honestly I don't see any reason why I wouldn't be able to
> install Oracle on this server and open up a read-only database on the BCV's.
> Except for maybe the fact that my employer practically chokes when Oracle
> quotes pricing.
>
> We are running HP/UX.  If you want more specific info, email me directly and
> I'll be glad to answer questions.
>
> Have a great day...
>
> Lisa Rutland Koivu
> Oracle Database Administrator

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

What does "data block" in report.txt stand for?

2001-03-21 Thread Chuan Zhang




Hi, All,
 
  Could someone help me to figure out the 
meaning of  "data block" contention in "Buffer busy wait statistics" section in 
utlbstat/utlestat report.txt or "data block" class in v$waitstat? 
 
 
Thanks very much in advance.
 
Chuan

RE: 1/2 control file failure - will database halt?

2001-03-21 Thread mark . thompson


The whole reason for multiple control files is so this is not a problem.
You simply copy the "good" control file over the "bad" control file(s) and
start up again.  They are copies of each other.

-Original Message-
Sent: Wednesday, March 21, 2001 7:26 PM
To: Multiple recipients of list ORACLE-L



You can mirror the controlfiles at the hw/os level instead if you want to 
protect against this.

oli


>
> I've been told a single control file failure will halt
> the database, even if you've got another control file on
> a second device; that the database will only come up again
> after editing the init.ora to remove the reference to the
> faulty control file and initiating a fresh startup.
>
> Is this still true, if it ever was true for any version of Oracle, for
> Oracle 8.X+? The person who warned me about the halt has been using
> Oracle since version 5.
>
>
> Thanks very much.
>
>  - Dana
>
>
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/

-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  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: dbms_obfuscation package

On Wed, 21 Mar 2001, Rachel Carmichael wrote:

> help!  I am by no means the world's best PL/SQL programmer (heck, I can
> barely program in it, PL/SQL 101 is on my desk at home)
>
> I am trying to see how hard it would be to add encryption to sensitive data
> in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.
>

Ahem...

Yours truly has an article on Oracle and encryption which
includes using DBMS_OBFUSCATION_TOOLKIT.

Complete with code.

www.cybcon.com/~jkstill/util

Jared

-- 
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: dbms_obfuscation package


yoou need to create the package -- run $ORACLE_HOME/rdbms/admin/catobtk.sql 
as SYS, then you can get MY error :)



>From: "Vinod Nagaraj" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: dbms_obfuscation package
>Date: Wed, 21 Mar 2001 16:00:30 -0800
>
>when i run the plsql block for the encryption i got this error, pls tell 
>what to
>do
>
>ERROR at line 7:
>ORA-06550: line 7, column 1:
>PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT' must be 
>declared
>
>thanks
>
>
>Vadim Gorbounov wrote:
>
> > Sorry, important add-in,
> > this should work too
> >
> >dbms_obfuscation_toolkit.DESencrypt(
> >input_string => data,
> >key_string => key,
> >encrypted_string => ddata);
> > Vadim
> >
> > -Original Message-
> > Sent: Wednesday, March 21, 2001 4:30 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > help!  I am by no means the world's best PL/SQL programmer (heck, I can
> > barely program in it, PL/SQL 101 is on my desk at home)
> >
> > I am trying to see how hard it would be to add encryption to sensitive 
>data
> > in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.
> >
> > I created a table:
> > SQL> desc test_encrypt
> > NameNull?Type
> > ---  
> > COL1 VARCHAR2(10)
> > COL2 VARCHAR2(10)
> >
> > and wrote a quick and dirty PL/SQL anonymous block:
> >
> > begin
> > declare
> > encrypted_str varchar2(10);
> > inp_string varchar2(10);
> >
> >   begin
> >  inp_string := '123456';
> > 
>dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);
> >  insert into test_encrypt values (inp_string,encrypted_str);
> >  commit;
> >   end;
> > end;
> > /
> >
> > when I run this, I get the following error:
> >
> >  dbms_obfuscation_toolkit.desencrypt
> > (inp_string,'lksdjfasljf',encrypted_str);
> >  *
> > ERROR at line 7:
> > ORA-06550: line 7, column 6:
> > PLS-00307: too many declarations of 'DESENCRYPT' match this call
> > ORA-06550: line 7, column 6:
> > PL/SQL: Statement ignored
> >
> > now, I KNOW that they overload the procedure, they say so in the
> > dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin
> >
> > but what am I doing wrong that it's not recognizing that I'm using 
>varchar
> > not raw and accepting what I input???
> >
> > Not urgent, but annoying
> >
> > Rachel
> > _
> > 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: Vadim Gorbounov
> >   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).
><< vknagar.vcf >>

_
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).

RE: Single Code Table or Separate Code tables dilemma

2001-03-21 Thread Daniel Harron


Check "The Data Warehouse Lifecycle Toolkit" by Ralph Kimball for the
definitive answer.

-Daniel

-Original Message-
Sent: Wednesday, March 21, 2001 7:32 PM
To: Oracledba (E-mail); ORACLE-L (E-mail)


Guys,

We r working on a Datawarehouse solution.

Our Duhvelopers want to merge all code tables into a single table by adding
a codetype column.

with reference to this, i came across this article from Steve's site
http://www.ixora.com.au/tips/design/meta-data.htm

i want to put them into different individual code tables instead of a single
table, for the foll reasons.

1. specific attributes for a particular code type is logically and
physically seperated from other code types.
2. a table lock affects only the concerned code table
3. granular control over the individual code table

i am short of arguments

wld be grateful, if ull can advise me which would be better from performance
perspective.

-Mandar


Think you know someone who can answer the above question? Forward it to
them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daniel Harron
  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).

SQLCode in 8i

2001-03-21 Thread Regina Harter


We have a number of Powerbuilder applications for which we have been using 
the SQLCode returned from a sql statement execution to determine the next 
action, depending on if the statement failed (SQLCode < 0), didn't return 
any rows (SQLCode = 100) or successfully returned data (SQLCode = 0).  We 
upgraded to 8.1.6 two weeks ago, and just discovered that, outside of an 
exception block, SQLCode now always returns 0.  Do any of you know a way to 
return to the old codes, or make it treat Powerbuilder like an exception 
block, or know of some other code we could use to gather this information?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Regina Harter
  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: RE: RE: RE: OT: Rachel in Vietnam

2001-03-21 Thread Peter Barnett


It did not work that wel.  Just gave the bad guys really good cover 
after the noise stopped.  Probably don't want to give developers that 
many places to hide.


Pete Barnett
Oracle Database Administrator
Regence BlueCross BlueShield
[EMAIL PROTECTED]


On Tue, 20 Mar 2001 [EMAIL PROTECTED] wrote:

> Sure, why not.  The BRICK-BAT method.
> 
> Reply Separator
> Author: "Mohan; Ross" <[EMAIL PROTECTED]>
> Date:   3/20/2001 5:08 PM
> 
> Wow. Talk about enforcing "foreign constraints".
> 
> -Original Message-
> Sent: Tuesday, March 20, 2001 5:01 PM
> To: Mohan; Ross; Multiple recipients of list ORACLE-L
> 
> 
> Ross,
> 
> When a B-52, otherwise known as a BUFF (Big Ugly Fat F^cker), unloads
> 150 to
> 200(B-52D with wing racks) 750LB demolition bombs nothing stands.  Even
> duhvelopers.  I've had Marines discribe the area where a BUFF strike landed
> as
> "It looked like God reached down, scooped out a three mile long by half a
> mile
> wide, by 100 foot deep piece of the earth and take it away".  I don't know
> about
> cool, but it sure was effective!!
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Mohan; Ross" <[EMAIL PROTECTED]>
> Date:   3/20/2001 4:28 PM
> 
> BUFF bomb. That sounds cool. Will it work on developers?
> 
> -Original Message-
> Sent: Tuesday, March 20, 2001 4:18 PM
> To: Mohan; Ross; Multiple recipients of list ORACLE-L
> 
> 
> Ross,
> 
> Makes sense, Nam was BUG heaven, unless they got caught in the path of a
> BUFF bomb run.  Nothing survived that. :-)
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Mohan; Ross" <[EMAIL PROTECTED]>
> Date:   3/20/2001 8:02 AM
> 
> Dick , 
> 
> Didn't you know? Rachel WAS in Nam. But she 
> never talks about it. I think it had to do
> with the bugs. 
> 
> Just a thought. 
> 
> Ross
> 
> -Original Message-
> Sent: Tuesday, March 20, 2001 8:32 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Rachel,
> 
> If you were given one, as I was in Nam, you'd not know the difference. 
> Looks like, & tastes like a crunch bar for the most part, except for the
> logo on
> top.  It just crunches better.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "Rachel Carmichael" <[EMAIL PROTECTED]>
> Date:   3/19/2001 4:10 PM
> 
> but Moom, the icky bugs TOUCHED the chocolate!   :)
> 
> 
> 
> >From: Kimberly Smith <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> >Date: Mon, 19 Mar 2001 13:45:29 -0800
> >
> >You could just lick the chocolate off.
> >
> >-Original Message-
> >Sent: Monday, March 19, 2001 10:11 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> > I have a phobia about bugs...
> >
> >what a waste of perfectly good chocolate
> >
> >
> > >From: [EMAIL PROTECTED]
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe
> > >Date: Mon, 19 Mar 2001 09:11:20 -0800
> > >
> > >OK you chocaholics try this on for size:
> > >
> > >  Reuters Monday, March 19, 2001
> > >
> > >Chocolate-Coated Bugs Are Latest Treat
> > >
> > >LONDON (Reuters) - Ants, crickets and scorpions, baked, coated
> > >in chocolate and promoted as a high-protein snack, are proving
> > >popular among peckish Londoners.
> > >
> > >Designer Todd Dalton, who trained as a chef in Louisiana and
> > >acquired a taste for cooked insects on his travels in Asia and
> > >central America, says he has sold 5,000 chocolate-coated bugs
> > >since he began marketing them in December.
> > >
> > >"They are very high in protein and very low in fat. They have a
> > >higher percentage of protein than any meat or fish that we
> > >commonly eat," he told Reuters.
> > >
> > >The creepy-crawly chocs sell for between three and 3.50 pounds
> > >($4.30-$5.00) at upmarket London stores such as Selfridges and
> > >the Conran Shop and will soon be appearingin shops in Munich
> > >and Zurich.
> > >--
> > >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: But all is not gloom and doom for Oracle...

2001-03-21 Thread Eric D. Pierce

Wait just a second, are you saying that "the press" (or, if
you prefer "journalistic corporate media") might be 
sensationalizing things about the "bad economy" just to get
keep their readership/viewer levels high? 

GASP! :)

We aren't that full of cr*p in this country, are we? :)

regards,
ep

On 21 Mar 2001, at 11:45, Tim Sawmiller wrote:

Date sent:  Wed, 21 Mar 2001 11:45:11 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> But all is not gloom and doom for Oracle.  Excerpts from Chuck Phillips of Morgan 
>Stanley on the last quarter
> 
> It's useful to keep the quarter in perspective.  
> It's a miss but not a  financial disaster:

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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).

dynamic sql questions

2001-03-21 Thread lwm


Actually, two questions here:

1. I have a dynamicly-built query that will be
executed using dynamic sql:
   select Z, (select y from tableA t1 where
t1.id=t2.id) X 
   from tableA t2;
To get the value from the query, I use:
   dbms_sql.column_value( theCursor, 1,columnValue);
   dbms_sql.column_value( theCursor, 2,columnValue);
Now, how can I get the column name (i.e. X) using
dynamic sql? 
2. I tried to use a group function in the above query
as following:
   select countZ) A, (select y from tableA t1 where
t1.id=t2.id) X 
   from tableA t2
   group by X;  
The query failed and the error message was:
   ORA-00904: invalid column name (i.e. Oracle says
that X is not a valid column name)
Is ther a way to work around this problem?
 
Thanks a lot.

WL

__
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: lwm
  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: dbms_obfuscation package

Title: RE: dbms_obfuscation package





> -Original Message-
> From: Vinod Nagaraj [mailto:[EMAIL PROTECTED]]
> 
> when i run the plsql block for the encryption i got this 
> error, pls tell what to
> do
> 
> ERROR at line 7:
> ORA-06550: line 7, column 1:
> PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT' 
> must be declared


It could be that there is no public synonym for the package (check DBA_OBJECTS to see if the package exists), or it could also be that the package has not been created in your database. There are many "builtin" packages that are only created when you run the script that specifically creates the particular package.

Most scripts are in $ORACLE_HOME/rdbms/admin , so you could find the source code for a particular package with
grep $ORACLE_HOME/rdbms/admin/*.sql dbms_obfuscation


Some packages/tables might be in other sub-directories (e.g. $ORACLE_HOME/md ) so if a search in the $ORACLE_HOME/rdbms/admin directory yields no results, you could try

find $ORACLE_HOME/*/admin/*.sql -name "*.sql" -exec grep -l dbms_obfuscation {} \;


It is left as an exercise to the alert reader to determine which command(s) should be used on other operating system(s).

By using the first UNIX command mentioned above I found out that dbms_obfuscation_toolkit is created by
$ORACLE_HOME/rdbms/admin/dbmsobtk.sql


You should also know that, in my experience, the SQL scripts in the $ORACLE_HOME/*/admin directories should almost always be run as SYS. Check the comments at the beginning of the SQL script to see if any special "run instructions" are provided.

--
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: DBA Job at a Chocolate Factory

2001-03-21 Thread Steve Adams


Hi Steve,

I once got to work on an oil rig in the middle of Bass Strait.
The pay was based on how dangerous your work was, rather than the skill
required.
It is not often that being a DBA puts you at the bottom of the pay
scale!

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Thursday, 22 March 2001 2:07
To: Multiple recipients of list ORACLE-L


Seven years ago I was offered an Oracle DBA job at a chocolate factory
and
turned it down. (Please don't tell Rachel, she already thinks I'm
crazy.) I
had two simultaneous offers for the same salary and took the one closer
to
home. While on the interview they gave me the full tour of the factory
starting with the bags of cocoa beans on the docks. The smell was
intoxicating and even wafted into the office area where I would have
worked.
They had unlimited stashes of chocolate in every cubicle. I asked the
employees if they ever got sick of chocolate and the answer was a
resounding
NO. Now my kids will never forgive me for not having taken the job at
the
chocolate factory.

This begs the question... Where and what are some of the most
interesting
Oracle DBA jobs out there? I heard of one deep underground at a mining
operation in the middle of the Nevada desert. Database is a basic
technology
that can be applied to just about any business anywhere. Any interesting
stories? Personal experiences?


Steve Orr

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve Orr
  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: Steve Adams
  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: Anybody using Network Appliance Storage boxes with Oracle?

2001-03-21 Thread Casey Dyke


We're going through a "certification" process, so to speak (offline if you're
curious), w/NetApp right now.  My testing against a 100 million row (+) table
is thus far positive, but testing is really in it's infancy.  A few comments:

- we're using tcp, not upd (reasons should be obvious)
- Gigabit ethernet cards in server and filer (a must, according to NetApp)
- test filer config is an 840 w/2 racks of 7*36 gig drives (very expandable)
- Prod should have 2 * 840's w/tdb disk layout
- Don't use 72 gig drives (we begged for 36 - again, reasons are obvious)
- yes, you can have one big wafl volume, but more are recommended for recovery
opps (ie: one volume for data files, one for redo, archives, control files ...)

- am running online redo and archived on local disk (but can be run on the
filer, just not that brave)
- snapshot capabilities look cool, but not yet tested
- PQO queries on 4 * 3 million row partitions do appear quicker than our prod
implementation
- Have heard big updates can be slow (this will be tested soon)
- hasn't shat itself yet and, to be honest, haven't seen the filer cpu top 20%
(don't read anything into the latter comment though)
- turn disk_asynch_io off or you may (probably will) encounter dbwr problems
- jury out on whether mimicing async io w/db_writer_processes (or io_slaves) is
worthwhile (NetApp does recommend it)
- Various other filer, nfs options necessary (but simple to implement)

To be honest, setup was easy.  The only eebie jeebies (how do you spell that??)
are nfs related.  New territory, does it work, will it fail - just how safe is
the nvram?  Anyway, all looks good and I can say the NetApp support team are
bending over backwards to assist us - so that's good.   Another associate down
under is in testing on a much bigger implementation than ours and he, too,
seems confidant.  We are obviously not in production and have a ways to go yet.

Keep in mind that w/NetApp your sysadmins can tool around.  EMC is a black box.
 We like control and that's one of the big reasons we're  down this path.
NetApp costs less too, although dollars are not my game, thankfully.

Please feel free to ping me w/any questions.

Cheers,

Casey ...


begin:vcard 
n:Dyke;Casey 
tel;pager:(022) 9436 9290
tel;home:61 2 9948 1487
tel;work:61 2 9005 1073
x-mozilla-html:FALSE
url:www.realsurf.com
org:Excite@Home Australia;IT-Ops
adr:;;100 Harris Street;Pyrmont;NSW;2042;Australia
version:2.1
email;internet:[EMAIL PROTECTED]
title:DBA Type Person
x-mozilla-cpt:;12680
fn:Casey Dyke
end:vcard

Re: 1/2 control file failure - will database halt?

2001-03-21 Thread Oliver Artelt



You can mirror the controlfiles at the hw/os level instead if you want to 
protect against this.

oli


>
> I've been told a single control file failure will halt
> the database, even if you've got another control file on
> a second device; that the database will only come up again
> after editing the init.ora to remove the reference to the
> faulty control file and initiating a fresh startup.
>
> Is this still true, if it ever was true for any version of Oracle, for
> Oracle 8.X+? The person who warned me about the halt has been using
> Oracle since version 5.
>
>
> Thanks very much.
>
>  - Dana
>
>
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/

-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  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: dbms_obfuscation package



thanks.. I'll try this as well

>From: Vadim Gorbounov <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: dbms_obfuscation package
>Date: Wed, 21 Mar 2001 14:37:20 -0800
>
>   Hi Rachel,
>I believe, this is bug. I had the same problem, workaround is to create
>stored procedure wrapper, not use
>dbms_obfuscation_toolkit.desencrypt in anonymous block.
>   Another important note - both key and data lengths should be
>multiples of 8.
>
>   hope this helps
>
>   Vadim Gorbounov
>   Oracle DBA
>
>-Original Message-
>Sent: Wednesday, March 21, 2001 4:30 PM
>To: Multiple recipients of list ORACLE-L
>
>
>help!  I am by no means the world's best PL/SQL programmer (heck, I can
>barely program in it, PL/SQL 101 is on my desk at home)
>
>I am trying to see how hard it would be to add encryption to sensitive data
>in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.
>
>I created a table:
>SQL> desc test_encrypt
>NameNull?Type
>---  
>COL1 VARCHAR2(10)
>COL2 VARCHAR2(10)
>
>and wrote a quick and dirty PL/SQL anonymous block:
>
>begin
>declare
> encrypted_str varchar2(10);
> inp_string varchar2(10);
>
>   begin
>  inp_string := '123456';
>dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);
>  insert into test_encrypt values (inp_string,encrypted_str);
>  commit;
>   end;
>end;
>/
>
>when I run this, I get the following error:
>
>  dbms_obfuscation_toolkit.desencrypt
>(inp_string,'lksdjfasljf',encrypted_str);
>  *
>ERROR at line 7:
>ORA-06550: line 7, column 6:
>PLS-00307: too many declarations of 'DESENCRYPT' match this call
>ORA-06550: line 7, column 6:
>PL/SQL: Statement ignored
>
>
>now, I KNOW that they overload the procedure, they say so in the
>dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin
>
>but what am I doing wrong that it's not recognizing that I'm using varchar
>not raw and accepting what I input???
>
>Not urgent, but annoying
>
>Rachel
>_
>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: Vadim Gorbounov
>   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 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).

Shared pool 'perm' behaviour

2001-03-21 Thread Connor McDonald


Anyone observed this on their platform ? (Observations
below are from Sun, v8.1.6 and 8.1.7)

Based on various things I've seen on the web,
immediately after startup I would expect about half
the shared pool to "kept aside" by Oracle (in the
'perm' area) and only released as memory comes under
pressure.

So to prove this assertion, I set 'shared_pool = 40m',
and ran the following immediately after startup:

select ksmchcls, sum(p.ksmchsiz) tot
from sys.x$ksmsp  p
group by ksmchcls;

KSMCHCLSTOT
 --
R-free  200
R-freea  40
free   16541304
freeabl 2514628
perm   21760488
recr 701904

which is what I would expect (ie about 50% in the
'perm' area)

So far so good... But then, if I bump up 'shared_pool'
to 70m, then I see

KSMCHCLSTOT
 --
R-free  350
R-freea  40
free   60401700
freeabl 2524560
perm6409504
recr 682552

thus all of a sudden, there is minimal 'perm', and
virtually all of the memory is now deemed 'free'.

The switch over point seems to be somewhere around
68m.

Can anyone shed any light on this ??

Cheers
Connor


=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie


Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to [EMAIL PROTECTED]
to subscribe send a blank email to [EMAIL PROTECTED] 
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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: dbms_obfuscation package


not the same errors, but at the same time, I am not giving it a proper 
encryption key... I'll try that tomorrow at work and see if that changes 
anything.

Thanks!


>From: "Khedr, Waleed" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: dbms_obfuscation package
>Date: Wed, 21 Mar 2001 14:49:13 -0800
>
>I do not have the package installed but I found this in the DOC which may
>help:
>
>If the input data or key given to the PL/SQL DESEncrypt function is empty,
>then Oracle raises ORA error 28231 "Invalid input to Obfuscation toolkit".
>
>If the input data given to the DESEncrypt function is not a multiple of 8
>bytes, Oracle raises ORA error 28232 "Invalid input size for Obfuscation
>toolkit".
>
>If the user tries to double encrypt data using the DESEncrypt function, 
>then
>Oracle raises ORA error 28233 "Double encryption not supported by 
>DESEncrypt
>in
>Obfuscation toolkit".
>
>Encryption Procedure Restriction
>
>The DESEncryption procedure has two restrictions. The first is that the DES
>key length for encryption is fixed at 56 bits; you cannot alter this key
>length.
>
>The second is that you cannot execute multiple passes of encryption. That
>is, you cannot re-encrypt previously encrypted data by calling the function
>twice.
>
>-Original Message-
>Sent: Wednesday, March 21, 2001 4:30 PM
>To: Multiple recipients of list ORACLE-L
>
>
>help!  I am by no means the world's best PL/SQL programmer (heck, I can
>barely program in it, PL/SQL 101 is on my desk at home)
>
>I am trying to see how hard it would be to add encryption to sensitive data
>in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.
>
>I created a table:
>SQL> desc test_encrypt
>NameNull?Type
>---  
>COL1 VARCHAR2(10)
>COL2 VARCHAR2(10)
>
>and wrote a quick and dirty PL/SQL anonymous block:
>
>begin
>declare
> encrypted_str varchar2(10);
> inp_string varchar2(10);
>
>   begin
>  inp_string := '123456';
>dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);
>  insert into test_encrypt values (inp_string,encrypted_str);
>  commit;
>   end;
>end;
>/
>
>when I run this, I get the following error:
>
>  dbms_obfuscation_toolkit.desencrypt
>(inp_string,'lksdjfasljf',encrypted_str);
>  *
>ERROR at line 7:
>ORA-06550: line 7, column 6:
>PLS-00307: too many declarations of 'DESENCRYPT' match this call
>ORA-06550: line 7, column 6:
>PL/SQL: Statement ignored
>
>
>now, I KNOW that they overload the procedure, they say so in the
>dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin
>
>but what am I doing wrong that it's not recognizing that I'm using varchar
>not raw and accepting what I input???
>
>Not urgent, but annoying
>
>Rachel
>_
>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: 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).

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

RE: dbms_obfuscation package


Rachel,

Perhaps if you used Named Notation for the arguments for the
procedure, Oracle would understand which of the overloaded
procs you're calling.

dbms_obfuscation_toolkit.desencrypt
(
 input_string => inp_string
,key_string   => 'lksdjfasljf'
,encrypted_string => encrypted_str
)
;

Let us know what works.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Rachel
Carmichael
Sent: Wednesday, March 21, 2001 3:30 PM
To: Multiple recipients of list ORACLE-L


help!  I am by no means the world's best PL/SQL programmer
(heck, I can
barely program in it, PL/SQL 101 is on my desk at home)

I am trying to see how hard it would be to add encryption to
sensitive data
in our database, so I'm playing with
DBMS_OBFUSCATION_TOOLKIT.

I created a table:
SQL> desc test_encrypt
NameNull?Type
---  
COL1 VARCHAR2(10)
COL2 VARCHAR2(10)

and wrote a quick and dirty PL/SQL anonymous block:

begin
declare
encrypted_str varchar2(10);
inp_string varchar2(10);

  begin
 inp_string := '123456';
dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf'
,encrypted_str);
 insert into test_encrypt values
(inp_string,encrypted_str);
 commit;
  end;
end;
/

when I run this, I get the following error:

 dbms_obfuscation_toolkit.desencrypt
(inp_string,'lksdjfasljf',encrypted_str);
 *
ERROR at line 7:
ORA-06550: line 7, column 6:
PLS-00307: too many declarations of 'DESENCRYPT' match this
call
ORA-06550: line 7, column 6:
PL/SQL: Statement ignored


now, I KNOW that they overload the procedure, they say so in
the
dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin

but what am I doing wrong that it's not recognizing that I'm
using varchar
not raw and accepting what I input???

Not urgent, but annoying

Rachel

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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[2]: Re: SUN vs. HP

2001-03-21 Thread Kimberly Smith


Hey, good post.  I pretty much agree with all of it except for the length
of time to fail over via ServiceGuard.  It must be dependant on how much you
are failing over because ours is no more then 10 mins. for everything to 
completely fail over and be running.  

Are you sure that exp and imp run 64 bit?  According to Oracle they did not
make that a 64 bit executable.  I have never checked mine because I really 
don't care.  That is with 8.1.5.  They may have changed that in later
releases.

-Original Message-
Sent: Wednesday, March 21, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L


I'll try here to answer two posts at the same time thereby saving a little.

HP-UX is the most close to pure Unix I've seen in some time.  My experience
with
Solaris is very thin and although it appears very stable I think there are a
number of commands that just don't work like the standard says their suppose
to.
 It's a SUN thing and I won't hold it against them.  Linux and HP are very
close
although HP provides more short cuts via aliases.  Compaq's old Ultrix
(actually
DEC back in those days) was an animal all to itself, there's no comparison
as
only the core was there, but not totally.  I've a book of standard Unix
commands
as recognized by ANSI and I haven't found one on HP that does not work as
advertised, although HP many times provides a shortcut like 'll' instead of
'ls
-al'.

As far as 32 vs. 64 bit, if your on one of the older machines, before the L
class, then your pretty much stuck with 32 bit.  You can, I understand, load
the
64 bit OS, but it recognizes the machine and installs itself in 'emulation'
mode
which is "slower than molasses running up hill in Anchorage in mid
December". 
But I do notice that the 32 bit version of HP-UX 11.0 does allow some
changes
long sought, namely more memory access and large file sizes.

If you've got one of the newer L, N, or best of all V class machines then
the 64
bit stuff REALLY cruises.  And yes exp and imp run full 64 bit too here.

MC ServiceGuard is a product that HP touts as their 'fault tolerant'
solution. 
Basically you install a second network card into the box dedicated to
ServiceGuard on two or more machines and create a private network with some
Ethernet thin cable.  One machine is designated as the MASTER and the others
are
standby slaves.  All of the boxes have to have some shared disk space.  The
idea
is that the MASTER puts out a heartbeat via the private network every so
many
seconds.  As long as the slaves see the heartbeat they go on about their
normal
business, whatever that may be.  If the heartbeat disappears for two or more
time intervals the PRIME slave or the slave if you only have two computers,
immediately shuts down and reboots, assuming the identity, disk drives, and
tasks of the MASTER.  The switch over process takes about 30 minutes.  As an
aside ServiceGuard also provides the facilities of MC Lock Manager which is
required to use Oracle Parallel server.  This utility provides disk file
locking
between two or more computers that share disk drives.  It's expensive to say
the
least, complicated to setup, and can get temperamental if the environment is
not
noise clean.  On the other hand it really does work.

Dick Goulet
-- 
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: 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: Re[2]: Re: SUN vs. HP

2001-03-21 Thread Steve Orr


> "pure Unix"
Now there's an oxymoron if there ever was one!  :-)


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 2:37 PM
To: Multiple recipients of list ORACLE-L


HP-UX is the most close to pure Unix I've seen in some time.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Orr
  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: dbms_obfuscation package

2001-03-21 Thread Vinod Nagaraj


when i run the plsql block for the encryption i got this error, pls tell what to
do

ERROR at line 7:
ORA-06550: line 7, column 1:
PLS-00201: identifier 'DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT' must be declared

thanks


Vadim Gorbounov wrote:

> Sorry, important add-in,
> this should work too
>
>dbms_obfuscation_toolkit.DESencrypt(
>input_string => data,
>key_string => key,
>encrypted_string => ddata);
> Vadim
>
> -Original Message-
> Sent: Wednesday, March 21, 2001 4:30 PM
> To: Multiple recipients of list ORACLE-L
>
> help!  I am by no means the world's best PL/SQL programmer (heck, I can
> barely program in it, PL/SQL 101 is on my desk at home)
>
> I am trying to see how hard it would be to add encryption to sensitive data
> in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.
>
> I created a table:
> SQL> desc test_encrypt
> NameNull?Type
> ---  
> COL1 VARCHAR2(10)
> COL2 VARCHAR2(10)
>
> and wrote a quick and dirty PL/SQL anonymous block:
>
> begin
> declare
> encrypted_str varchar2(10);
> inp_string varchar2(10);
>
>   begin
>  inp_string := '123456';
> dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);
>  insert into test_encrypt values (inp_string,encrypted_str);
>  commit;
>   end;
> end;
> /
>
> when I run this, I get the following error:
>
>  dbms_obfuscation_toolkit.desencrypt
> (inp_string,'lksdjfasljf',encrypted_str);
>  *
> ERROR at line 7:
> ORA-06550: line 7, column 6:
> PLS-00307: too many declarations of 'DESENCRYPT' match this call
> ORA-06550: line 7, column 6:
> PL/SQL: Statement ignored
>
> now, I KNOW that they overload the procedure, they say so in the
> dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin
>
> but what am I doing wrong that it's not recognizing that I'm using varchar
> not raw and accepting what I input???
>
> Not urgent, but annoying
>
> Rachel
> _
> 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: Vadim Gorbounov
>   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:Nagaraj;Vinod
tel;cell:303-332-7223
tel;work:720-962-4355
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Vinod Kumar Nagaraj
end:vcard

RE: dbms_obfuscation package

2001-03-21 Thread Khedr, Waleed


I do not have the package installed but I found this in the DOC which may
help:

If the input data or key given to the PL/SQL DESEncrypt function is empty,
then Oracle raises ORA error 28231 "Invalid input to Obfuscation toolkit". 

If the input data given to the DESEncrypt function is not a multiple of 8
bytes, Oracle raises ORA error 28232 "Invalid input size for Obfuscation
toolkit". 

If the user tries to double encrypt data using the DESEncrypt function, then
Oracle raises ORA error 28233 "Double encryption not supported by DESEncrypt
in
Obfuscation toolkit". 

Encryption Procedure Restriction

The DESEncryption procedure has two restrictions. The first is that the DES
key length for encryption is fixed at 56 bits; you cannot alter this key
length. 

The second is that you cannot execute multiple passes of encryption. That
is, you cannot re-encrypt previously encrypted data by calling the function
twice. 

-Original Message-
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


help!  I am by no means the world's best PL/SQL programmer (heck, I can 
barely program in it, PL/SQL 101 is on my desk at home)

I am trying to see how hard it would be to add encryption to sensitive data 
in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.

I created a table:
SQL> desc test_encrypt
NameNull?Type
---  
COL1 VARCHAR2(10)
COL2 VARCHAR2(10)

and wrote a quick and dirty PL/SQL anonymous block:

begin
declare
encrypted_str varchar2(10);
inp_string varchar2(10);

  begin
 inp_string := '123456';
dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);
 insert into test_encrypt values (inp_string,encrypted_str);
 commit;
  end;
end;
/

when I run this, I get the following error:

 dbms_obfuscation_toolkit.desencrypt 
(inp_string,'lksdjfasljf',encrypted_str);
 *
ERROR at line 7:
ORA-06550: line 7, column 6:
PLS-00307: too many declarations of 'DESENCRYPT' match this call
ORA-06550: line 7, column 6:
PL/SQL: Statement ignored


now, I KNOW that they overload the procedure, they say so in the 
dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin

but what am I doing wrong that it's not recognizing that I'm using varchar 
not raw and accepting what I input???

Not urgent, but annoying

Rachel
_
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: 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).

Single Code Table or Separate Code tables dilemma

2001-03-21 Thread Mandar Ghosalkar


Guys,

We r working on a Datawarehouse solution.

Our Duhvelopers want to merge all code tables into a single table by adding
a codetype column.

with reference to this, i came across this article from Steve's site
http://www.ixora.com.au/tips/design/meta-data.htm

i want to put them into different individual code tables instead of a single
table, for the foll reasons.

1. specific attributes for a particular code type is logically and
physically seperated from other code types.
2. a table lock affects only the concerned code table
3. granular control over the individual code table

i am short of arguments

wld be grateful, if ull can advise me which would be better from performance
perspective.

-Mandar
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Ghosalkar
  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: Easy Doubt in sql/plus

2001-03-21 Thread elkinsl


Eriovaldo,

If you don't want to have to mess around with your SQL adding chr(10), and
since you said in SQL*Plus, you could use column commands:

SQL> column dname newline
SQL> column loc newline

  1* select * from dept
SQL> /

10
ACCOUNTING
NEW YORK

20
RESEARCH
DALLAS

You can also look into using fold_after or fold_before with the col(umn)
command.

Not that I think the column commands approach is any better  or worse, and,
it *is* less typing to do the char(10) approach -- just wanted to bring up
another approach that hadn't been mentioned.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
-Original Message-
Carmo Andrietta
Sent: Wednesday, March 21, 2001 12:03 PM
To: Multiple recipients of list ORACLE-L


Hi Friends :

How can I do for put each column in new line using sql/plus

Example :

Select * from tab;

and the result sould be :

'value of column1'
'value of column2'
'value of column3'
'value of column4'
'value of column5'

and not

'value of column1' 'value of column2' 'value of column3' 'value of column4'
'value of column5'

Thanks

Eriovaldo

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

2001-03-21 Thread Scott Crabtree


Todd,
Sorry, I spoke too soon,

we are patching to 8.1.7.0.2 on NT

MetaBlurb Quote about  8.1.7.1
"No date on Windows NT, it is still listed as delayed 
HP-UX 3/23/01 
AIX 3/23/01 
Compaq 3/16/01 "

Sorry about the disinformation.

Scott


-Original Message-
Sent: Wednesday, March 21, 2001 4:57 PM
To: '[EMAIL PROTECTED]'


Todd,
Your skepticism is healthy, but Metalink is not:-) 8.1.7.1 is the
latest patch AFAIK.

Scott


  Support Status
  ~~
   Release  Comments
8.1.7.0  Oracle8i Release 3 Base Release
  See [NOTE:120801.1] if installing on Unix.
8.1.7.1  Current patch set - see [NOTE:120613.1] for contents.
  Support Status
  ~~
   Release  Comments
8.1.7.0  Oracle8i Release 3 Base Release
  See [NOTE:120801.1] if installing on Unix.
8.1.7.1  Current patch set - see [NOTE:120613.1] for contents.

-Original Message-
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


Metalink shows that there is no patch available for 8.1.7 on NT. Is that
correct or am I needing a vacation? I hate to be cynical, but an Oracle
product with no patch for 3 months? This I find hard to believe.

Todd Carlson
Oracle 8 & 8i Certified DBA
Bunge Corporation

-- 
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: Scott Crabtree
  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: dbms_obfuscation package

2001-03-21 Thread Nelson, Greg


I'm not too good at PL/SQL either and I struggled with using the
dbms_obfuscation package to create functions to encrypt and decrypt data.
We want to encrypt passwords for DBAs in a table. Now that I have the
functions they can be used for other data too.  The best thing I found was a
tip by Tom Kyte in his column the Jan/Feb issue of Oramag.  He says the
trick to using it is to make the key and input data a length divisible by 8.
Using that I finally figured how to do it.  Check out the article for a good
example. Its late in the day and I don't know PL/SQL good enuff to figure
out your exact problem. You're welcome to contact me for my code if you
like.

Greg
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


help!  I am by no means the world's best PL/SQL programmer (heck, I can 
barely program in it, PL/SQL 101 is on my desk at home)

I am trying to see how hard it would be to add encryption to sensitive data 
in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.

I created a table:
SQL> desc test_encrypt
NameNull?Type
---  
COL1 VARCHAR2(10)
COL2 VARCHAR2(10)

and wrote a quick and dirty PL/SQL anonymous block:

begin
declare
encrypted_str varchar2(10);
inp_string varchar2(10);

  begin
 inp_string := '123456';
dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);
 insert into test_encrypt values (inp_string,encrypted_str);
 commit;
  end;
end;
/

when I run this, I get the following error:

 dbms_obfuscation_toolkit.desencrypt 
(inp_string,'lksdjfasljf',encrypted_str);
 *
ERROR at line 7:
ORA-06550: line 7, column 6:
PLS-00307: too many declarations of 'DESENCRYPT' match this call
ORA-06550: line 7, column 6:
PL/SQL: Statement ignored


now, I KNOW that they overload the procedure, they say so in the 
dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin

but what am I doing wrong that it's not recognizing that I'm using varchar 
not raw and accepting what I input???

Not urgent, but annoying

Rachel
_
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: Nelson, Greg
  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: Why is there air?


Jared,

I wholeheartedly agree that this forum is invaluable for its
technical focus and intend to promote and support it as
such.  Perhaps there have been a few too many Off Topic
postings lately.  However, as wonderful and multi-faceted as
the Oracle RDBMS and its inherent  challenges may be,
sometimes a little "horse-play" helps solidify our
"community" as well.

Actually, it seems to me that most everyone who's made OT
postings has more than offset that  with purely technical
ones.  My personal posting ratio is about 4 OT to 13
Technical over the past couple of weeks.

Heck, with our stock portfolios in the tank, reduced Net
Worth, layoffs everywhere, and the most miserable pollen
season in Austin that I can remember, we need a bit of fun!

Anyway, I'll wipe the silly grin off my face, tuck my shirt
back in, sit down, stop passing notes, and get back to work.
But it's been a blast!

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L



Subject line got your attention didn't it?

Some may recognize that line from a Bill Cosby routine.

I thought it might be an attention grabber.

-- the real purpose of this post

Lest we all forget the purpose of the this forum
and others like it, I am posting some comments
that were sent to me.

There is no ulterior motive behind this, i.e. the
recent spate of off-topic posts.

I merely wanted to remind everyone that this list is
an educational resource, and how important this
community is to many folks that run into problems
they don't know how to handle.


Thanks,
Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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.7 Patches

2001-03-21 Thread Scott Crabtree


Todd,
Your skepticism is healthy, but Metalink is not:-) 8.1.7.1 is the
latest patch AFAIK.

Scott


  Support Status
  ~~
   Release  Comments
8.1.7.0  Oracle8i Release 3 Base Release
  See [NOTE:120801.1] if installing on Unix.
8.1.7.1  Current patch set - see [NOTE:120613.1] for contents.
  Support Status
  ~~
   Release  Comments
8.1.7.0  Oracle8i Release 3 Base Release
  See [NOTE:120801.1] if installing on Unix.
8.1.7.1  Current patch set - see [NOTE:120613.1] for contents.

-Original Message-
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


Metalink shows that there is no patch available for 8.1.7 on NT. Is that
correct or am I needing a vacation? I hate to be cynical, but an Oracle
product with no patch for 3 months? This I find hard to believe.

Todd Carlson
Oracle 8 & 8i Certified DBA
Bunge Corporation

-- 
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: Scott Crabtree
  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.7 Patches

2001-03-21 Thread Suhen Pather


Todd,

I think you may need a vacation.
There are 8.1.7 patches on NT 8.1.7.0.1 and 8.1.7.0.2 (SQLNET Patches)

Do a search on Metablink for all NT patches and you will see a few for
Oracle 8.1.7.

Suhen



Metalink shows that there is no patch available for 8.1.7 on NT. Is that
correct or am I needing a vacation? I hate to be cynical, but an Oracle
product with no patch for 3 months? This I find hard to believe.

Todd Carlson
Oracle 8 & 8i Certified DBA
Bunge Corporation

-- 
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: Suhen Pather
  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.7 Patches

2001-03-21 Thread Patrick Housholder


Oracle8 8.1.7.0.2  Patch is on metalink...
it's sql*net patch...
*
i could not find 8.1.7.0.1

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, March 21, 2001 3:37 PM
*>To: Multiple recipients of list ORACLE-L
*>Subject: RE: 8.1.7 Patches
*>
*>
*>I don't believe there is a patch yet.  I am waiting for it so they can fix
*>that wonderful cursor_sharing bug that has been around since 8.1.6.
*>Kev
*>
*>-Original Message-
*>[EMAIL PROTECTED]
*>Sent: Wednesday, March 21, 2001 4:30 PM
*>To: Multiple recipients of list ORACLE-L
*>
*>
*>Metalink shows that there is no patch available for 8.1.7 on NT. Is that
*>correct or am I needing a vacation? I hate to be cynical, but an Oracle
*>product with no patch for 3 months? This I find hard to believe.
*>
*>Todd Carlson
*>Oracle 8 & 8i Certified DBA
*>Bunge Corporation
*>
*>--
*>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: 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).

RE: dbms_obfuscation package

2001-03-21 Thread Vadim Gorbounov


Sorry, important add-in, 
this should work too

   dbms_obfuscation_toolkit.DESencrypt(
   input_string => data,
   key_string => key,
   encrypted_string => ddata);
Vadim

-Original Message-
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


help!  I am by no means the world's best PL/SQL programmer (heck, I can 
barely program in it, PL/SQL 101 is on my desk at home)

I am trying to see how hard it would be to add encryption to sensitive data 
in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.

I created a table:
SQL> desc test_encrypt
NameNull?Type
---  
COL1 VARCHAR2(10)
COL2 VARCHAR2(10)

and wrote a quick and dirty PL/SQL anonymous block:

begin
declare
encrypted_str varchar2(10);
inp_string varchar2(10);

  begin
 inp_string := '123456';
dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);
 insert into test_encrypt values (inp_string,encrypted_str);
 commit;
  end;
end;
/

when I run this, I get the following error:

 dbms_obfuscation_toolkit.desencrypt 
(inp_string,'lksdjfasljf',encrypted_str);
 *
ERROR at line 7:
ORA-06550: line 7, column 6:
PLS-00307: too many declarations of 'DESENCRYPT' match this call
ORA-06550: line 7, column 6:
PL/SQL: Statement ignored


now, I KNOW that they overload the procedure, they say so in the 
dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin

but what am I doing wrong that it's not recognizing that I'm using varchar 
not raw and accepting what I input???

Not urgent, but annoying

Rachel
_
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: Vadim Gorbounov
  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: OFF TOPIC: DBA Job at a Chocolate Factory

2001-03-21 Thread Wolfe, Charles


The Continuing Story of Bungalow Bill, Lennon/McCartney, THE BEATLES (aka
The White Album).

-Original Message-
Sent: Wednesday, March 21, 2001 4:59 PM
To: Multiple recipients of list ORACLE-L


Jacques,
 
You're right.  Preparing for a dance competition IS more challenging than DB
recovery - my wife and I rehearse somewhere between 400 and 600 hours/year
to dance a total of maybe 45 to 90 minutes in each of our four annual
competitions.   However, it's so much more satisfying!  Plus, it helps keep
you sharp and in shape for those times you do have to sit at a workstation,
doing recovery or some such sedentary thing.  Actually, we Jazzercise
(Aerobics) about 300 hours per year just to stay in shape to rehearse!
 
We do American Smooth (Waltz, Tango, Foxtrot, Viennese Waltz) and American
Rhythm (ChaCha, Rumba, Swing, Bolero, Mambo).  The American Style, to us, is
more fun, especially since you can do almost all the dances socially.  Not
so with some of the International Style dances, such as Quick Step, Samba,
and Paso Doble.  Also, IMHO, American Smooth is much harder than
International Standard - the rapid changes from open to closed positions
make it very difficult to do with finesse.
 
No, you wouldn't want to see me shake my 50 year old bootie, though my Cuban
Motion (in Rumba) *is* getting pretty good for a "Bullet-Headed Saxon
Mother's Son" (extra points for whoever can name the song that phrase came
from!)!  My wife's slinky and/or graceful moves keep everyone distracted
from noticing my clumsier moments - she's a treat to watch!
 
Yep, we're "Fred and Ginger".  She's every bit as talented as Ginger Rogers
while I, unfortunately, am closer to Flintstone (or Mertz) than Astaire!
8^)
 
Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Kilchoer
Sent: Wednesday, March 21, 2001 12:59 PM
To: Multiple recipients of list ORACLE-L



> -Original Message- 
> From: Jack C. Applewhite [ mailto:[EMAIL PROTECTED]
 ] 
> 
> Now MY idea of a heavenly DBA gig would be at something like 
> the Fred Astaire or Arthur Murray World Headquarters, where 
>  ...  
 

 Don't listen to him! My wife participates in dance competitions and has
"persuaded" me to join her in taking dance lessons at a local dance studio.
I would prefer having to recover a crashed 24x7 mission critical database
than have to enter a dance competition.

Jack, do you do ballroom or latin/jive? Of course, I happen to prefer
ballroom (where you can get away with looking bored while you're dancing)
and my wife likes latin (our salsa instructor is constantly exhorting us to
"shake our booties" - trust me, you don't want to see a DBA shaking his
booty). 

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wolfe, Charles
  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: dbms_obfuscation package

2001-03-21 Thread Vadim Gorbounov


Hi Rachel,
I believe, this is bug. I had the same problem, workaround is to create
stored procedure wrapper, not use 
dbms_obfuscation_toolkit.desencrypt in anonymous block.
Another important note - both key and data lengths should be
multiples of 8.

hope this helps

Vadim Gorbounov
Oracle DBA

-Original Message-
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


help!  I am by no means the world's best PL/SQL programmer (heck, I can 
barely program in it, PL/SQL 101 is on my desk at home)

I am trying to see how hard it would be to add encryption to sensitive data 
in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.

I created a table:
SQL> desc test_encrypt
NameNull?Type
---  
COL1 VARCHAR2(10)
COL2 VARCHAR2(10)

and wrote a quick and dirty PL/SQL anonymous block:

begin
declare
encrypted_str varchar2(10);
inp_string varchar2(10);

  begin
 inp_string := '123456';
dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);
 insert into test_encrypt values (inp_string,encrypted_str);
 commit;
  end;
end;
/

when I run this, I get the following error:

 dbms_obfuscation_toolkit.desencrypt 
(inp_string,'lksdjfasljf',encrypted_str);
 *
ERROR at line 7:
ORA-06550: line 7, column 6:
PLS-00307: too many declarations of 'DESENCRYPT' match this call
ORA-06550: line 7, column 6:
PL/SQL: Statement ignored


now, I KNOW that they overload the procedure, they say so in the 
dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin

but what am I doing wrong that it's not recognizing that I'm using varchar 
not raw and accepting what I input???

Not urgent, but annoying

Rachel
_
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: Vadim Gorbounov
  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: Find special characters in the database

2001-03-21 Thread Catherine LeBlanc

If you know the character you are looking for, you can paste it into
a script like the one below, to quickly fix specific tables and columns.

update table
set column_name= replace(column_name,'û',null)
where column_name like '%û%'
/

You can use ' ' in place of null if you really want a blank in there.
It may take a while to run on big tables.

Catherine A. LeBlanc, Database Analyst
Bates College

At 01:30 PM 3/20/01 -0800, you wrote:
>Can someone give me a guideline as to how I
>should draw a script to find special characters
>in the database and replace them with blanks.
>
>TIA
>
>Shakeel Qureshi
>[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Catherine LeBlanc
  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]: Re: SUN vs. HP

2001-03-21 Thread dgoulet


I'll try here to answer two posts at the same time thereby saving a little.

HP-UX is the most close to pure Unix I've seen in some time.  My experience with
Solaris is very thin and although it appears very stable I think there are a
number of commands that just don't work like the standard says their suppose to.
 It's a SUN thing and I won't hold it against them.  Linux and HP are very close
although HP provides more short cuts via aliases.  Compaq's old Ultrix (actually
DEC back in those days) was an animal all to itself, there's no comparison as
only the core was there, but not totally.  I've a book of standard Unix commands
as recognized by ANSI and I haven't found one on HP that does not work as
advertised, although HP many times provides a shortcut like 'll' instead of 'ls
-al'.

As far as 32 vs. 64 bit, if your on one of the older machines, before the L
class, then your pretty much stuck with 32 bit.  You can, I understand, load the
64 bit OS, but it recognizes the machine and installs itself in 'emulation' mode
which is "slower than molasses running up hill in Anchorage in mid December". 
But I do notice that the 32 bit version of HP-UX 11.0 does allow some changes
long sought, namely more memory access and large file sizes.

If you've got one of the newer L, N, or best of all V class machines then the 64
bit stuff REALLY cruises.  And yes exp and imp run full 64 bit too here.

MC ServiceGuard is a product that HP touts as their 'fault tolerant' solution. 
Basically you install a second network card into the box dedicated to
ServiceGuard on two or more machines and create a private network with some
Ethernet thin cable.  One machine is designated as the MASTER and the others are
standby slaves.  All of the boxes have to have some shared disk space.  The idea
is that the MASTER puts out a heartbeat via the private network every so many
seconds.  As long as the slaves see the heartbeat they go on about their normal
business, whatever that may be.  If the heartbeat disappears for two or more
time intervals the PRIME slave or the slave if you only have two computers,
immediately shuts down and reboots, assuming the identity, disk drives, and
tasks of the MASTER.  The switch over process takes about 30 minutes.  As an
aside ServiceGuard also provides the facilities of MC Lock Manager which is
required to use Oracle Parallel server.  This utility provides disk file locking
between two or more computers that share disk drives.  It's expensive to say the
least, complicated to setup, and can get temperamental if the environment is not
noise clean.  On the other hand it really does work.

Dick Goulet
-- 
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: 1/2 control file failure - will database halt?

2001-03-21 Thread Koivu, Lisa

Title: RE: 1/2 control file failure - will database halt?



Yea, 
it worked for me...  it was a small database

  -Original Message-From: Kevin Kostyszyn 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, March 21, 2001 4:30 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  1/2 control file failure - will database halt?
  So 
  you don't bring the DB down and then copy the controlfile?  You just copy 
  it?  Just curious
  Kev
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
Wednesday, March 21, 2001 4:02 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: 1/2 control file failure - will database 
halt?
Dana, 
The database will spit errors.  I found as long as you 
are only reading data and not trying any DDL or stuff like that, for the 
most part the database will continue to run.  As the DBA, if you rush 
in and copy one of the control files over to where the missing one was, the 
database will continue running. Remember, no changes will be allowed that 
will write to the control files - this will fail because Oracle wants to 
write to every one of them, and if one is missing, nothing gets 
changed.  
This helps if you can't just bring down your database (like 
me). 
I tested this a couple of weeks ago. 
HTH Lisa 
-Original Message- From: 
dana [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 21, 2001 3:46 PM To: Multiple recipients of list ORACLE-L Subject: 1/2 control file failure - will database halt? 

I've been told a single control file failure will 
halt the database, even if you've got another 
control file on a second device; that the database 
will only come up again after editing the init.ora 
to remove the reference to the faulty control file 
and initiating a fresh startup. 
Is this still true, if it ever was true for any version of 
Oracle, for Oracle 8.X+? The person who warned me 
about the halt has been using Oracle since version 
5. 
Thanks very much. 
 - Dana 
__ 
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: dana   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.7 Patches

2001-03-21 Thread Kevin Kostyszyn


I don't believe there is a patch yet.  I am waiting for it so they can fix
that wonderful cursor_sharing bug that has been around since 8.1.6.
Kev

-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L


Metalink shows that there is no patch available for 8.1.7 on NT. Is that
correct or am I needing a vacation? I hate to be cynical, but an Oracle
product with no patch for 3 months? This I find hard to believe.

Todd Carlson
Oracle 8 & 8i Certified DBA
Bunge Corporation

--
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: 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: OFF TOPIC: DBA Job at a Chocolate Factory

Title: OFF TOPIC: DBA Job at a Chocolate Factory



Jacques,
 
You're 
right.  Preparing for a dance competition IS more challenging than DB 
recovery - my wife and I rehearse somewhere between 400 and 600 hours/year to 
dance a total of maybe 45 to 90 minutes in each of our four annual 
competitions.   However, it's so much more satisfying!  
Plus, it helps keep you sharp and in shape for those times you do have to 
sit at a workstation, doing recovery or some such sedentary thing.  
Actually, we Jazzercise (Aerobics) about 300 hours per year just to stay in 
shape to rehearse!
 
We do 
American Smooth (Waltz, Tango, Foxtrot, Viennese Waltz) and American Rhythm 
(ChaCha, Rumba, Swing, Bolero, Mambo).  The American Style, to us, is more 
fun, especially since you can do almost all the dances socially.  Not so 
with some of the International Style dances, such as Quick Step, Samba, and 
Paso Doble.  Also, IMHO, American Smooth is much harder than 
International Standard - the rapid changes from open to closed positions make it 
very difficult to do with finesse.
 
No, 
you wouldn't want to see me shake my 50 year old bootie, though my Cuban Motion 
(in Rumba) *is* getting pretty good for a "Bullet-Headed Saxon Mother's Son" 
(extra points for whoever can name the song that phrase came from!)!  My 
wife's slinky and/or graceful moves keep everyone distracted from noticing my 
clumsier moments - she's a treat to watch!
 
Yep, 
we're "Fred and Ginger".  She's every bit as talented as Ginger Rogers 
while I, unfortunately, am closer to Flintstone (or Mertz) than Astaire!    
8^)
 
Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques KilchoerSent: 
  Wednesday, March 21, 2001 12:59 PMTo: Multiple recipients of list 
  ORACLE-LSubject: OFF TOPIC: DBA Job at a Chocolate 
  Factory
  > -Original Message- > 
  From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]] 
  > > Now MY idea of a heavenly 
  DBA gig would be at something like > the Fred 
  Astaire or Arthur Murray World Headquarters, where >  ...   
   Don't listen to 
  him! My wife participates in dance competitions and has "persuaded" me to join 
  her in taking dance lessons at a local dance studio. I would prefer having to 
  recover a crashed 24x7 mission critical database than have to enter a dance 
  competition.
  Jack, do you do ballroom or latin/jive? Of course, I happen to 
  prefer ballroom (where you can get away with looking bored while you're 
  dancing) and my wife likes latin (our salsa instructor is constantly exhorting 
  us to "shake our booties" - trust me, you don't want to see a DBA shaking his 
  booty).

Re: 1/2 control file failure - will database halt?

2001-03-21 Thread William Beilstein


If you have a single corrupted database, replace the bad copy with the good one and 
restart the database. You should only have to modify the init.ora if the location of 
the corrupted or missing control file is not reachable. Each control file contains the 
exact same information. You have multiple control files to protect against losing all 
your control information.

>>> [EMAIL PROTECTED] 03/21/01 03:46PM >>>

I've been told a single control file failure will halt
the database, even if you've got another control file on
a second device; that the database will only come up again
after editing the init.ora to remove the reference to the
faulty control file and initiating a fresh startup.

Is this still true, if it ever was true for any version of Oracle, for
Oracle 8.X+? The person who warned me about the halt has been using
Oracle since version 5.


Thanks very much.

 - Dana



__
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: dana
  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: William Beilstein
  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: 1/2 control file failure - will database halt?

2001-03-21 Thread Kevin Kostyszyn

Title: RE: 1/2 control file failure - will database halt?



So you 
don't bring the DB down and then copy the controlfile?  You just copy 
it?  Just curious
Kev

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: 
  Wednesday, March 21, 2001 4:02 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: 1/2 control file failure - will database 
  halt?
  Dana, 
  The database will spit errors.  I found as long as you 
  are only reading data and not trying any DDL or stuff like that, for the most 
  part the database will continue to run.  As the DBA, if you rush in and 
  copy one of the control files over to where the missing one was, the database 
  will continue running. Remember, no changes will be allowed that will write to 
  the control files - this will fail because Oracle wants to write to every one 
  of them, and if one is missing, nothing gets changed.  
  This helps if you can't just bring down your database (like 
  me). 
  I tested this a couple of weeks ago. 
  HTH Lisa 
  -Original Message- From: dana 
  [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, March 21, 2001 3:46 PM To: Multiple recipients of list ORACLE-L Subject: 1/2 control file failure - will database halt? 
  
  I've been told a single control file failure will halt 
  the database, even if you've got another control file 
  on a second device; that the database will only come 
  up again after editing the init.ora to remove the 
  reference to the faulty control file and initiating a 
  fresh startup. 
  Is this still true, if it ever was true for any version of 
  Oracle, for Oracle 8.X+? The person who warned me 
  about the halt has been using Oracle since version 
  5. 
  Thanks very much. 
   - Dana 
  __ 
  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: dana   
  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.7 Patches

2001-03-21 Thread TCarlson


Metalink shows that there is no patch available for 8.1.7 on NT. Is that
correct or am I needing a vacation? I hate to be cynical, but an Oracle
product with no patch for 3 months? This I find hard to believe.

Todd Carlson
Oracle 8 & 8i Certified DBA
Bunge Corporation

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

LONG vs CLOB (Was: LONG fields within triggers.)

2001-03-21 Thread Morten Primdahl



Thanks again Jack.

> It would be better in the long run (maybe even the long raw
> run!) if you used a BLOB.  That way the features of the
> DBMS_LOB package would be available to you, not to mention
> out-of-line storage options galore.

I'm aware that LONG eventually will be discontinued - anyone
know when? We mainly use the large data types for streaming
data, eg. pictures - so far we've not been able to get the
same throughput (bytes/sec) from (even optimized) LOB fields.

In this specific case, I'm indexing text, at most 100k/record I reckon
and the CLOB overhead would probably be negligible - I probably 
spent more time on making the triggers than the entire 
accumulated overhead will be for the next decade! But the learning
experience was great :)

Morten


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Morten Primdahl
  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).

dbms_obfuscation package


help!  I am by no means the world's best PL/SQL programmer (heck, I can 
barely program in it, PL/SQL 101 is on my desk at home)

I am trying to see how hard it would be to add encryption to sensitive data 
in our database, so I'm playing with DBMS_OBFUSCATION_TOOLKIT.

I created a table:
SQL> desc test_encrypt
NameNull?Type
---  
COL1 VARCHAR2(10)
COL2 VARCHAR2(10)

and wrote a quick and dirty PL/SQL anonymous block:

begin
declare
encrypted_str varchar2(10);
inp_string varchar2(10);

  begin
 inp_string := '123456';
dbms_obfuscation_toolkit.desencrypt(inp_string,'lksdjfasljf',encrypted_str);
 insert into test_encrypt values (inp_string,encrypted_str);
 commit;
  end;
end;
/

when I run this, I get the following error:

 dbms_obfuscation_toolkit.desencrypt 
(inp_string,'lksdjfasljf',encrypted_str);
 *
ERROR at line 7:
ORA-06550: line 7, column 6:
PLS-00307: too many declarations of 'DESENCRYPT' match this call
ORA-06550: line 7, column 6:
PL/SQL: Statement ignored


now, I KNOW that they overload the procedure, they say so in the 
dbmsobtk.sql file in $ORACLE_HOME/rdbms/admin

but what am I doing wrong that it's not recognizing that I'm using varchar 
not raw and accepting what I input???

Not urgent, but annoying

Rachel
_
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).

Why is there air?



Subject line got your attention didn't it?

Some may recognize that line from a Bill Cosby routine.

I thought it might be an attention grabber.

-- the real purpose of this post

Lest we all forget the purpose of the this forum
and others like it, I am posting some comments
that were sent to me.

There is no ulterior motive behind this, i.e. the
recent spate of off-topic posts.

I merely wanted to remind everyone that this list is
an educational resource, and how important this
community is to many folks that run into problems
they don't know how to handle.


Thanks,
Jared

( comments slightly edited )

> Jared,
>
> of my collegues (including me) learnt a lot from
> this list rather than from any of the study materials provided by the
> training institutes.  I still remember.  In the beginning a couple of us
> used to read one post or two posts a day from the list and discuss that and
> research it and learn it thoroughly.  It gave us confidence and also saved
> (on a few occassions) our credibility.  On a point of contention, I used to
> print the various responses from the list members and show it to my director
> to drive my point.  And every time I succeeded.
>
> Keep the list alive.



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

Calling a script/other program from a stored procedure

2001-03-21 Thread Bartolo, David


Hi all,

I think this thread was talked about a few days ago, but I missed it.  
Can anyone show me how or where to look to call a unix script or other
program 
from a stored procedure.

Thanks
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bartolo, David
  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: 1/2 control file failure - will database halt?

2001-03-21 Thread Koivu, Lisa

Title: RE: 1/2 control file failure - will database halt?





Dana, 


The database will spit errors.  I found as long as you are only reading data and not trying any DDL or stuff like that, for the most part the database will continue to run.  As the DBA, if you rush in and copy one of the control files over to where the missing one was, the database will continue running. Remember, no changes will be allowed that will write to the control files - this will fail because Oracle wants to write to every one of them, and if one is missing, nothing gets changed.  

This helps if you can't just bring down your database (like me). 


I tested this a couple of weeks ago. 


HTH
Lisa



-Original Message-
From: dana [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 3:46 PM
To: Multiple recipients of list ORACLE-L
Subject: 1/2 control file failure - will database halt?




I've been told a single control file failure will halt
the database, even if you've got another control file on
a second device; that the database will only come up again
after editing the init.ora to remove the reference to the
faulty control file and initiating a fresh startup.


Is this still true, if it ever was true for any version of Oracle, for
Oracle 8.X+? The person who warned me about the halt has been using
Oracle since version 5.



Thanks very much.


 - Dana




__
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: dana
  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: DBA Job at a Chocolate Factory

2001-03-21 Thread Thater, William

Steve Orr wrote:
> 
> Now how did I know you would say that?  :)
> Sometimes we're crazy like a fox... mostly we're just crazy. :)

me, i got the papers to prove it too.;-)

--
Bill Thater  Certifiable ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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: Find special characters in the database


On Wed, 21 Mar 2001, Shakeel Qureshi wrote:

> Hi Jared,
>
> Its Oracle 8i and just need to do this operation on
> a small table, using SQL and PL/SQL.
>
> I would appreciate if you could guide me
>
>  a.  As to how to find out the special characters
>  b.  Change values
>
> Looking forward to your help.
>

Well, I have some time and this sounded kinda fun.

The first script creates 2 tables from the demo
account 'SCOTT'.

The second script is a brute force method to use
dynamic SQL to change all the values.

I suggest you study the script carefully before
running it.

You will need to edit the values in the tabList,
specialChars and replaceChars arrays.

Jared

---

-- script 1

--create test tables and muck up the data


drop table cust;
drop table emp;

create table cust
as
select *
from scott.s_customer
/

create table emp
as
select *
from scott.s_emp
/


-- add goofy characters to the data

begin

for frec in (
select id, name, address, city
from cust
for update
)
loop
update cust
set
name = substr(name,1,5) || chr(10) || substr(name,6)
, address = substr(address,1,7) || chr(185) || 
substr(address,8)
, city = substr(city,1,4) || chr(7) || substr(city,5)
where id = frec.id;
end loop;
commit;

end;
/




-- script 2
--change the special characters to something else


declare

type specialCharType is varray(100) of varchar2(1);
type tabListType is varray(100) of varchar2(30);

-- these are the characters you want to replace
specialChars specialCharType := specialCharType (
chr(10), chr(185), chr(7)
);

-- these are the characters to replace the
-- ones above with
-- there must be a one-to-one correspondence
-- to the above array
-- replace:
-- chr(10) with a blank
-- chr(128) with '^'
-- chr(7) with a '@'
replaceChars specialCharType := specialCharType (
chr(32), chr(94), chr(64)
);

--tables to fix
-- you need to edit this
tabList tabListType := tabListType (
'CUST','EMP'
);

sqlStatement varchar2(1000);

cursor colnameCur( table_name_in user_tables.table_name%type )
is
select column_name
from user_tab_columns
where table_name = upper(table_name_in)
and data_type in ('CHAR','VARCHAR','VARCHAR2');


begin

for chrnum in specialChars.first .. specialChars.last
loop
--dbms_output.put_line( chrnum );

for tabnum in tabList.first .. tabList.last
loop
--dbms_output. put_line(tabList(tabnum));
sqlStatement := 'update ' || tabList(tabnum) || ' set ';
for colrec in colnameCur(tabList(tabnum))
loop
--dbms_output. put_line( colrec.column_name);
sqlStatement := sqlStatement || colrec.column_name
|| ' = translate(' || colrec.column_name || ','
|| 'chr(' || ascii(specialChars(chrnum)) || ')'
|| ',' || 'chr(' || ascii(replaceChars(chrnum))
|| ')),';

end loop;

-- get rid of the last comma
sqlStatement := 
substr(sqlStatement,1,instr(sqlStatement,',',-1)-1);
execute immediate sqlStatement;
commit;

end loop;


end loop;
end;
/




-- 
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: multiple instance

2001-03-21 Thread Mandar Ghosalkar


Nihar,

1. create new entries in the /etc/oratab and listener.ora files for your new
instance, setup environment variables for the new instance : ORACLE_SID
should be set to the new instance name, ORACLE_HOME to your existing Oracle
home dir. 
2. Then just create the new database with these new settings. u can use
$ORACLE_HOME/bin/dbassist to create the shell scripts and then run them
manually

good luck

keep the list posted with ur results

-Mandar

p.s. do u really use biometric access in ur company???

> -Original Message-
> From: Nihar [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 12:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject: multiple instance
> 
> 
> hi folks
> 
>  how to create multiple oracle 8 instances on solaris.
> 
> regards
> 
>
> - NIHAR SANGHVI
> 
> NetMagic Solutions Pvt. Ltd.
> 22,Nirlon Complex,Western Express Highway,
> Goregaon (E), Mumabai 400 063
> 
> Phone: 8723003 extn: 144
> www.netmagicsolutions.com
> 
> 
> 
>  
>   
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nihar
>   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: Mandar Ghosalkar
  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:But all is not gloom and doom for Oracle...

2001-03-21 Thread dgoulet


It's all "accounting" and "Wall street analysts".  Most accountants I know can't
keep their own check books balanced and I've got an old class mate down in a
wallstreet brokerage.  He does petrochemical companies.  What I don't understand
is how he got the job as he flunked chemistry in HS, and I mean REALLY flunked,
like < 40 as a final grade not to mention what happen to the lab bench!!

It just doesn't figure.  If you have a car problem you go looking for a
qualified mechanic.  But when you've got money to invest you listen to an
Analyst?  What about the opinions coming from the company CFO??  Case of the
blind leading the blind & deaf.

Dick Goulet

Reply Separator
Author: "Tim Sawmiller" <[EMAIL PROTECTED]>
Date:   3/21/2001 11:45 AM

But all is not gloom and doom for Oracle.  Excerpts from Chuck Phillips of
Morgan Stanley on the last quarter

It's useful to keep the quarter in perspective.  
It's a miss but not a  financial disaster:

 - Oracle made $900 million in operating profits in the quarter.  This is
 real business.

 - Revenue of $2.67 billion was 5% below our $2.75 billion estimate --
   not 25%  below like some other pre-announcements.

 - The company booked $1.1 billion in license revenue instead of our $1.2
   billion estimate -- so most deals closed.

 - Applications were up 50% in the quarter.  Database was flat to
   slightly  down in the quarter versus a tough compare.  Total licenses 
   increased  6%.

 Oracle was one of the last generals left standing on a brittle
 technology  battlefield, and in the end couldn't avoid the bullets and hand
grenades  that  were showering down from above.  It has become clear that in an 
environment  like this one, there are no bulletproof vests.  Other software
companies  have  to be concerned and will likely see something in March.  Oracle
has a  strong  product line, is well established with customers references and
couldn't  get  quite enough deals done.  Most other software companies are in
far  weaker  positions from a product and positioning perspective.


>>> [EMAIL PROTECTED] 03/21/01 01:52PM >>>

--- Forwarded message follows ---
Date sent:  Mon, 19 Mar 2001 02:04:08 -0500 (EST)

...


***
$1 Billion Savings Gets Even Less Likely For Oracle

Oracle's goal to reach one billion dollars in savings by implementing 
its own financial software just got even more unattainable. Oracle 
Thursday announced financial results for the third quarter, ending 
Feb. 28. As expected, the company failed to meet the margins and 
profits it will need to achieve its savings goals,  

The operating margin for the third quarter was 33 percent. That's up 
2 percent year-over-year, which is good, but it falls far short of 
the 40 percent margin that the company and financial analysts have 
said would be needed to achieve the company's goal of saving 1 
billion in costs this year over last year.  

Combine the disappointing operating margin with flat, rather than 
growing, profits and what you end up with is a cost savings, year-
over-year, significantly less than even the $300 million that it 
seemed was just barely within Oracle's reach two weeks ago. -- Mitch 
Wagner  

Read the entire story: 

http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LxJk 

***

...


Did someone forward this to you? Get your own issue...
http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LsYu 

Still not receiving your own FREE subscription to InternetWeek Magazine?
Subscribe by going to
http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LsZv 

This message powered by FloNetwork
http://www.flonetwork.com 
--- End of forwarded message ---


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Eric D. Pierce
  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 ORAC

Re: DBA Job at a Chocolate Factory

2001-03-21 Thread Thater, William

"Armstead, Michael A" wrote:

> 
> I also had a chance to work for a company that operates music stores. That
> company was probably very much like your chocolate company, but with music.
> Everyone had offices and each office had stereo equipment. Each week, a memo
> would come out listing the most current CDs and other products. All you had
> to do was check the ones you wanted and they'd "magically" appear on your
> desk. I thought that was cool.

found my dream job.;-)  that or a publishing company.;-)

--
Bill Thater  Certifiable ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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: LONG fields within triggers.


Morten,

You're safe.  Since each User Session runs its own
instantiation of each trigger and gets its own instantiation
of the PL/SQL table, they're totally isolated from one
another and don't interfere with each other at all.

That's why a PL/SQL table is better than a DB table for
storing After Row Trigger results, unless you can use an 8i
Global Temporary Table - but that would cause unnecessary
I/O.  The PL/SQL table solution works so much more
efficiently.

It's unfortunate that you're using a LONG column, that
prevents you from using the syntax:
 Insert Into Table2 (LongCol) Select LongCol From Table1
Where ... ;

It would be better in the long run (maybe even the long raw
run!) if you used a BLOB.  That way the features of the
DBMS_LOB package would be available to you, not to mention
out-of-line storage options galore.

Anyway, glad it helped.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Morten
Primdahl
Sent: Wednesday, March 21, 2001 1:45 PM
To: Multiple recipients of list ORACLE-L



Thanks for the prompt tip Jack, it works! :) Are there any
caveats?
How about concurrency? As it is now, I insert into the
PL/SQL table
using

  v_Index := NVL(UpdatePackage.v_IDs.LAST, -1);
  v_Index := v_Index+1;
  UpdatePackage.v_IDs(v_Index) := :new.id;

within the row trigger. In the statement trigger I use

  v_Index := UpdatePackage.v_IDs.FIRST;
  WHILE v_Index IS NOT NULL LOOP

   BEGIN
OPEN  selectCursor; --Selects LONG field from the
updated table
FETCH selectCursor INTO tempContent; --tempContent
is a LONG var
CLOSE selectCursor;

IF tempContent IS NOT NULL THEN --Insert into target
table
  INSERT INTO table_b (id, field)
  VALUES
(UpdatePackage.v_IDs(v_Index),''||tempContent||'');
  tempContent := NULL;
END IF;
   END;
   UpdatePackage.v_IDs.DELETE(v_Index); --Delete from the
PL/SQL table
   v_Index := UpdatePackage.v_IDs.NEXT(v_Index);
  END LOOP;

Any bets on the thread safety on this procedure? What if eg.
4 users
update the PL/SQL table in the row triggers, and all 4 of
the subsequent
statement triggers read the same variable from the PL/SQL
table. Is
this an issue at all? I'm not at all experienced in the more
complex
ways of PL/SQL.

Thanks a ton.

Morten

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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: 32bit vs 64bit (was: Just like Christmas)

2001-03-21 Thread Kimberly Smith

Well hell, the most important one was the 64-bit.  Its the same
on HP.  Its to allow for extra.  In other words things like a
bigger SGA and what not.  I really don't care what export runs
at as long as it runs.  That being said, with the exception of
one database I am keeping them at 32-bit.

-Original Message-
Sent: Wednesday, March 21, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L

HI...

Last year around this time, we were working on
Solaris 2.7 (64-bit) and Oracle 8.1.5 (64-bit)
and were shocked to find that apart from
Oracle executable very few executables (like exp/imp)
were 64 bit!

Because of this we abandoned the idea of 64-bit with digust!!!

Can you please tell me how 64-bit Oracle is
on HP platform?

- Original Message --
[EMAIL PROTECTED] wrote:
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
From:[EMAIL PROTECTED]
Date:Tue, 20 Mar 2001 13:54:39 -0800
Subject:Re:RE: 32bit vs 64bit (was: Just like Christmas)

Kimberley,

The problem is that you loaded the 64 bit kernel in the K class.  It
does
not have the buss required for 64 bit, therefore the kernel does a fake it
64
emulation.  Rebuild the machine with the 32 bit version of HP 11.0 & you'll
be a
lot happier.  Ours stay up for months without problems & reboots are just
fine. 
Personally I'd go kill your SA and/or the Hp zlutz that configured them.

Dick Goulet

Good hardware cannot fix bad software/configurations.

Reply Separator
Author: Kimberly Smith <[EMAIL PROTECTED]>
Date:   3/20/2001 11:05 AM

We are going 64-bit for HP but keeping Oracle at 32-bit.  We really
had no choice for the HP side.  We just need the memory that 32 bit
could not support.  We have 9 K-class servers here that have been running
11-64-bit for quite some time (relatively speaking).  But we are
getting rid of all our K-class servers.  The model we are running have
been nothing but trouble.  We hate to turn one off because it seems
like every time we reboot hardware dies.  Other fabs have been having
the same issue.  So we are going N-class for the database cluster
and A-class for the remaining.  Since your K-class servers are new they
probably don't have the same hardware issues we have.  HP even owned up
to having issues.

-Original Message-
Sent: Tuesday, March 20, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L

Interesting.  We've got a 4-way K570 w/3GB mem that we'll be moving from
HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which
means I can FINALLY get us to 8i!  YAY!

So, why or why not should one go to 64bit?  Here's my perception:

Pros
---
Should be faster (moving 2x as many bits around)

Cons
---
Requires major downtime to go from 32 to 64.
Patches don't seem to come as quickly as 32bit versions on HP.

Unknowns (for me)
-
How much faster, if at all, and in what areas (mem, I/O, disk)?
Possible client problems?  Our clients are all 8.0.5 for now.
Any difference/disadvantage if 3rd party OCI programs are
not recompiled?

TIA,
Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 11:06
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Just like Christmas
> 
> 
> Kimberly,
> 
> Enjoy the N class boxes, especially in 64 bit mode.  They 
> really cook
> compared to a K.

This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 O

RE: multiple instance

Title: RE: multiple instance

> -Original Message-
> From: Nihar [mailto:[EMAIL PROTECTED]]
>
> how to create multiple oracle 8 instances on solaris.

Do you want to test Oracle Parallel Server by having two OPS instances accessing the same database on the same server? Or do you want to have two instances accessing two different datbases on the same server?

I hope that it's the second situation because it's probably easier, and that's what I can tell you how to implement. :)

The current instance is determined by the value of the Oracle environment variable ORACLE_SID. You can set ORACLE_SID to be a new value. Then for a new database, you will need to do the following. (The directories I choose are not necessary but I think follow Oracle's OFA guidelines.)

Let us suppose your new ORACLE_SID will be db_test

a) Create an initdb_test.ora in $ORACLE_BASE/admin/db_test/pfile

b) Create a soft link in $ORACLE_HOME/dbs to the init.ora file
ln -s $ORACLE_BASE/admin/db_test/pfile/initdb_test.ora $ORACLE_HOME/dbs

c) Set your ORACLE_SID to db_test
EXPORT ORACLE_SID=db_test

d) Run svrmgrl. connect internal and startup. Issue your create database statement. for example:
connect internal
startup nomount
CREATE DATABASE db_test
logfile
group 1 ('/u01/oradata/db_test/redo/redo_spcmgr_test01a.log',
'/u02/oradata/db_test/redo/redo_spcmgr_test01b.log') size 5M,
group 2 ('/u03/oradata/db_test/redo/redo_spcmgr_test02a.log',
'/u04/oradata/db_test/redo/redo_spcmgr_test02b.log') size 5M
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE '/u05/oradata/db_test/data/system01.dbf' SIZE 100M
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1 ;

e) Run catalog.sql

f) Create other tablespaces (temp, rollback, data, indexes, users, tools)

g) as user SYS (e.g. after a connect internal in svrmgrl), run catproc.sql, catexp.sql, other procedures you think you might need from $ORACLE_HOME/rdbms/admin

h) Change passwords for user SYS and SYSTEM - change their temporary tablespace to something other than the SYSTEM tablespace

h) If you are planning on using SQL*Plus, run as SYSTEM from inside SQL*Plus
$ORACLE_HOME/sqlplus/admin/pupbld.sql
and if you want to use the HELP feature in SQL*Plus run from the OS
$ORACLE_HOME/bin/helpins

i) Add you database to /var/opt/oracle/oratab (the file used by $ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut)

j) Add your database to listener.ora if you are running a listener

That's all I can think of but I'm sure someone else will remember something I forgot. I usually create the following directories in $ORACLE_BASE/admin/db_test :

directory name - purpose
bdump - for background_dump_dest
cdump - for core_dump_dest
udump - for user_dump_dest
pfile - for initSID.ora and configSID.ora files. I then create a soft link for the initSID.ora file in $ORACLE_HOME/dbs
create - for logs of the create statements

--
any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: DBA Job at a Chocolate Factory

2001-03-21 Thread Steve Orr


Now how did I know you would say that?  :)
Sometimes we're crazy like a fox... mostly we're just crazy. :)


Steve

-Original Message-
Carmichael
Sent: Wednesday, March 21, 2001 11:38 AM
To: Multiple recipients of list ORACLE-L


Steve,

I don't think you're crazy..

I know you are :)

Actually I would turn that job down, if only because it would make me crazy
to be around the chocolate and know that eating it would make me unfit to
work


Rachel


>From: "Steve Orr" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: DBA Job at a Chocolate Factory
>Date: Wed, 21 Mar 2001 08:06:54 -0800
>
>Seven years ago I was offered an Oracle DBA job at a chocolate factory and
>turned it down. (Please don't tell Rachel, she already thinks I'm crazy.) I
>had two simultaneous offers for the same salary and took the one closer to
>home. While on the interview they gave me the full tour of the factory
>starting with the bags of cocoa beans on the docks. The smell was
>intoxicating and even wafted into the office area where I would have
>worked.
>They had unlimited stashes of chocolate in every cubicle. I asked the
>employees if they ever got sick of chocolate and the answer was a
>resounding
>NO. Now my kids will never forgive me for not having taken the job at the
>chocolate factory.
>
>This begs the question... Where and what are some of the most interesting
>Oracle DBA jobs out there? I heard of one deep underground at a mining
>operation in the middle of the Nevada desert. Database is a basic
>technology
>that can be applied to just about any business anywhere. Any interesting
>stories? Personal experiences?
>
>
>Steve Orr
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve Orr
>   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 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: Steve Orr
  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: But all is not gloom and doom for Oracle...

2001-03-21 Thread Dasko, Dan


I also heard (anecdotally), that Oracle had no long term debt and little
short-term debt, so their profits aren't going to service debt, and that
they had a pretty big chunk of cash just lying around.

Dan

-Original Message-
Sent: Wednesday, March 21, 2001 2:45 PM
To: Multiple recipients of list ORACLE-L


But all is not gloom and doom for Oracle.  Excerpts from Chuck Phillips of
Morgan Stanley on the last quarter

It's useful to keep the quarter in perspective.  
It's a miss but not a  financial disaster:

 - Oracle made $900 million in operating profits in the quarter.  This is
 real business.

 - Revenue of $2.67 billion was 5% below our $2.75 billion estimate --
   not 25%  below like some other pre-announcements.

 - The company booked $1.1 billion in license revenue instead of our $1.2
   billion estimate -- so most deals closed.

 - Applications were up 50% in the quarter.  Database was flat to
   slightly  down in the quarter versus a tough compare.  Total licenses 
   increased  6%.

 Oracle was one of the last generals left standing on a brittle
 technology  battlefield, and in the end couldn't avoid the bullets and hand
grenades  that  were showering down from above.  It has become clear that in
an  environment  like this one, there are no bulletproof vests.  Other
software companies  have  to be concerned and will likely see something in
March.  Oracle has a  strong  product line, is well established with
customers references and couldn't  get  quite enough deals done.  Most other
software companies are in far  weaker  positions from a product and
positioning perspective.


>>> [EMAIL PROTECTED] 03/21/01 01:52PM >>>

--- Forwarded message follows ---
Date sent:  Mon, 19 Mar 2001 02:04:08 -0500 (EST)

...


***
$1 Billion Savings Gets Even Less Likely For Oracle

Oracle's goal to reach one billion dollars in savings by implementing 
its own financial software just got even more unattainable. Oracle 
Thursday announced financial results for the third quarter, ending 
Feb. 28. As expected, the company failed to meet the margins and 
profits it will need to achieve its savings goals,  

The operating margin for the third quarter was 33 percent. That's up 
2 percent year-over-year, which is good, but it falls far short of 
the 40 percent margin that the company and financial analysts have 
said would be needed to achieve the company's goal of saving 1 
billion in costs this year over last year.  

Combine the disappointing operating margin with flat, rather than 
growing, profits and what you end up with is a cost savings, year-
over-year, significantly less than even the $300 million that it 
seemed was just barely within Oracle's reach two weeks ago. -- Mitch 
Wagner  

Read the entire story: 

http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LxJk 

***

...


Did someone forward this to you? Get your own issue...
http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LsYu 

Still not receiving your own FREE subscription to InternetWeek Magazine?
Subscribe by going to
http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LsZv 

This message powered by FloNetwork
http://www.flonetwork.com 
--- End of forwarded message ---


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Eric D. Pierce
  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).

_
This e-mail message has been scanned for the presence of all known computer
viruses by the MessageLabs Virus Control Center.  However, it is still
recommended that you use local virus scanning software to monitor for the
presence of viruses.  
-- 
Please see the o

1/2 control file failure - will database halt?

2001-03-21 Thread dana



I've been told a single control file failure will halt
the database, even if you've got another control file on
a second device; that the database will only come up again
after editing the init.ora to remove the reference to the
faulty control file and initiating a fresh startup.

Is this still true, if it ever was true for any version of Oracle, for
Oracle 8.X+? The person who warned me about the halt has been using
Oracle since version 5.


Thanks very much.

 - Dana



__
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: dana
  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 training

2001-03-21 Thread Streeter, Lerone A LBX


aren't there some people from north carolina here?  know any local, in
state, oracle training outfits?

===
Lerone Streeter
System Analyst
Abbott LBG
[EMAIL PROTECTED]
===
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Streeter, Lerone  A LBX
  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: OT -- A humorous reply to the Canada rulz

2001-03-21 Thread Boivin, Patrice J


Here is something a friend of mine sent me today, just to show how
impossible it is to get consensus on history:

Hahahahahahaha. He is so right. I guess our Ministry of
Propaganda will have to do a little research before they create the next
rant. Also, Lacrosse is Canadian by the fact that we declared our natives
wards of the state (Crown, whatever). The British from British North America
- not Canadians - attacked Washington. Upper Canada was a colony of the UK
and the lush who is credited with leading this raid got his *** kicked by a
militia of 20 guys when he tried to take Toronto (he had at least 80 losers
with him at time) and overthrow the British government. As for Lower Canada,
the slave colony, they may have had the copyright on the term 'Canadiens'
but they were also British subjects. They also tried to stop being British
at about that time but they were crushed and their leaders hanged. Not quite
the behavior we acquaint to being Canadian is it? But then again, Louis Riel
and the October crisis, ...yeah, perhaps it is Canadian.

Some people have a slightly cynical view of Canada...

At the time there was a lot of movement across the land, and across borders
anyway, European settlers were few and far between.

Also, most of the British troops were freemasons, just as the Americans were
-- so there was some camaraderie between the two sides, even during the
"war" of 1812.

History is never simple.  Never as simple as presented on TV, anyway!

Regards,

Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada



> -Original Message-
> From: Dasko, Dan 
> Sent: Wednesday, March 21, 2001 12:52 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: OT --  A humorous reply to the Canada rulz
> 
> Hey, at least I knew it wasn't Mr. Spock :P
> 
> Dan
> 
> -Original Message-
> Sent: Tuesday, March 20, 2001 4:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Dan,
> 
> You've made one of the only mortal sins of the Internet, it's not dis'ing
> the Canadians.  It's making an inaccurate Star Trek reference.  The ensign
> of Russian-descent was Pavel Checkov played by . . . joined the cast in
> episode # ...   entitled ...
> 
> Your penance should be long and severe.
> 
> Mike
> 
> -Original Message-
> Sent: Tuesday, March 20, 2001 1:07 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> U, Is this kinda like Mr. Sulu on Star Trek who was sure that the
> Russians invented everything?  I might be wrong (happens all the time),
> but
> I thought Baseball and Basketball were distinctly inventions of the USA.
> You might be able to tell I'm a rabid fan of neither.  Penicillin and the
> telephone??  Other delusions of grandeur?  How about the only country that
> can't decide if they're English or French?  How about the US's biggest
> colony via cultural conquest(ohh, that's a low blow).  How about never
> saw a bikini except in National Geographic?  I could go on, but I'm not
> sure
> my humor translates all that well, and the firewall has Babelfish blocked.
> 
> Dan "not about to give up my day job"
> 
> -Original Message-
> Sent: Tuesday, March 20, 2001 12:37 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Sorry about this, but someone sent me this and I thought it might be
> relevant to the Canada and US discussion that took place last week.
> 
> With all the recipes going around, I thought it wouldn't do any harm.
> 
> Regards,
> 
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
> 
> 
> 
> > -Original Message-
> >  So, what do Canadians have to be proud of? 
> >  
> > *   Smarties 
> >  
> > *   Crispy Crunch & Coffee Crisp 
> > 
> > *   The size of our footballs fields and one less Down 
> > 
> > *   Baseball is Canadian 
> > 
> > *   Lacrosse is Canadian 
> > 
> > *   Hockey is Canadian 
> > 
> > *   Basketball is Canadian 
> > 
> > *   Apple pie is Canadian 
> > 
> > *   Mr. Dress-up kicks Mr. Rogers ass 
> > 
> > *   Tim Hortons kicks Dunkin' Donuts ass 
> > 
> > *   In the war of 1812, started by America, Canadians pushed the
> > Americans back...past their 'White House'.   Then we burned it...  and
> > most
> > of Washington, under the command of William Lyon McKenzie  who was
> insane
> > and hammered all the time.  We got bored because they ran away, so we
> came
> > home and partied ... Go  figure... 
> > 
> > *   Canada has the largest French population that never surrendered to
> > Germany. 
> > 
> > *   We have the largest English population that never ever surrendered
> > or withdrew during any war to anyone, anywhere. 
> > 
> > *   Our civil war was a bar fight that lasted a little over an hour. 
> > 
> > *   The only person who was arrested in our civil war was an American
> > mercenary, who slept in and missed the whole thing...but showed up just
> in
> > time to get caught. 
> > 
> > *

RE: DBA Job at a Chocolate Factory

2001-03-21 Thread Armstead, Michael A


Great question!

I had an opportunity to work at the Longaberger Basket factory. They
hand-make baskets that are sold through multi-level marketing, like Avon and
Mary Kay Cosmetics. The factory is very nostalgic. The company is the only
company in the one-horse town of Dresden, Ohio. They even have a huge
corporate office that's shaped like a basket! 

They gave my family a great wine-and-dine tour and the job would have been
pretty cool for the right person. But I am a city person and living in that
small town would have probably driven me nuts.

I also had a chance to work for a company that operates music stores. That
company was probably very much like your chocolate company, but with music.
Everyone had offices and each office had stereo equipment. Each week, a memo
would come out listing the most current CDs and other products. All you had
to do was check the ones you wanted and they'd "magically" appear on your
desk. I thought that was cool.

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


> -Original Message-
> From: Steve Orr [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 11:07 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  DBA Job at a Chocolate Factory
> 
> Seven years ago I was offered an Oracle DBA job at a chocolate factory and
> turned it down. (Please don't tell Rachel, she already thinks I'm crazy.)
> I
> had two simultaneous offers for the same salary and took the one closer to
> home. While on the interview they gave me the full tour of the factory
> starting with the bags of cocoa beans on the docks. The smell was
> intoxicating and even wafted into the office area where I would have
> worked.
> They had unlimited stashes of chocolate in every cubicle. I asked the
> employees if they ever got sick of chocolate and the answer was a
> resounding
> NO. Now my kids will never forgive me for not having taken the job at the
> chocolate factory.
> 
> This begs the question... Where and what are some of the most interesting
> Oracle DBA jobs out there? I heard of one deep underground at a mining
> operation in the middle of the Nevada desert. Database is a basic
> technology
> that can be applied to just about any business anywhere. Any interesting
> stories? Personal experiences?
> 
> 
> Steve Orr
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Steve Orr
>   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: 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: Easy Doubt in sql/plus


isn't that a bit of overkill?

select column1||chr(10), column2||chr(10),. from table;

should do it


>From: "Trassens, Christian" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Easy Doubt in sql/plus
>Date: Wed, 21 Mar 2001 10:20:43 -0800
>
>With subqueries.
>
>Regards.
>
> > -Mensaje original-
> > De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]]
> > Enviado el: miércoles 21 de marzo de 2001 19:03
> > Para:   Multiple recipients of list ORACLE-L
> > Asunto: Easy Doubt in sql/plus
> >
> > Hi Friends :
> >
> > How can I do for put each column in new line using sql/plus
> >
> > Example :
> >
> > Select * from tab;
> >
> > and the result sould be :
> >
> > 'value of column1'
> > 'value of column2'
> > 'value of column3'
> > 'value of column4'
> > 'value of column5'
> >
> > and not
> >
> > 'value of column1' 'value of column2' 'value of column3' 'value of
> > column4'
> > 'value of column5'
> >
> > Thanks
> >
> > Eriovaldo
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Eriovaldo do Carmo Andrietta
> >   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: Trassens, Christian
>   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 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).

RE: Data into another table

Title: RE: Data into another table





> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 
> How can I  create a select statement from table1 including 
> some division or multiplication , and then include the result 
> into table2.


Dear Mr. Sköldblom,


I see your questions have already been answered. But I anticipate further questions! :)
May I suggest this book (I have glanced through it once and it seemed to me to present a  good introduction)


Oracle SQL : The Essential Reference
author: David C. Kreines
publisher: O'Reilly & Associates


one online bookstore where you could find it would be fatbrain ( http://www.fatbrain.com )


Disclaimer - I do not profit from any book sames made by fatbrain(tm).


--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

Re: Easy Doubt in sql/plus

2001-03-21 Thread Eriovaldo do Carmo Andrietta


No, using only one statment select like

select * from tab,

what can i set before  ?

Eriovaldo do Carmo Andrietta
[EMAIL PROTECTED]
ICQ #102604225



- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 3:20 PM


With subqueries.

Regards.

> -Mensaje original-
> De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]]
> Enviado el: miércoles 21 de marzo de 2001 19:03
> Para: Multiple recipients of list ORACLE-L
> Asunto: Easy Doubt in sql/plus
>
> Hi Friends :
>
> How can I do for put each column in new line using sql/plus
>
> Example :
>
> Select * from tab;
>
> and the result sould be :
>
> 'value of column1'
> 'value of column2'
> 'value of column3'
> 'value of column4'
> 'value of column5'
>
> and not
>
> 'value of column1' 'value of column2' 'value of column3' 'value of
> column4'
> 'value of column5'
>
> Thanks
>
> Eriovaldo
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eriovaldo do Carmo Andrietta
>   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: Trassens, Christian
  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: Eriovaldo do Carmo Andrietta
  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: SGA Parameters ...

2001-03-21 Thread SuzyV



This Metalink doc has what you're looking for
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1008866.6

Harsh Agrawal wrote:
> 
> Hi,
> 
> Can u help me to knoe what are the init.ora parameters contributing
> these ?
> Pl. give one to one or one to many mapping of these with the parameters.
> 
> -
> Total System Global Area   57124108 bytes
> Fixed Size70924 bytes
> Variable Size  40198144 bytes
> Database Buffers   16777216 bytes
> Redo Buffers  77824 bytes
> 
> Thanks,
> - Harsh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harsh Agrawal
>   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: SuzyV
  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: 32bit vs 64bit (was: Just like Christmas)

2001-03-21 Thread Cyril Thankappan

HI...

Last year around this time, we were working on
Solaris 2.7 (64-bit) and Oracle 8.1.5 (64-bit)
and were shocked to find that apart from
Oracle executable very few executables (like exp/imp)
were 64 bit!

Because of this we abandoned the idea of 64-bit with digust!!!

Can you please tell me how 64-bit Oracle is
on HP platform?

- Original Message --
[EMAIL PROTECTED] wrote:
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
From:[EMAIL PROTECTED]
Date:Tue, 20 Mar 2001 13:54:39 -0800
Subject:Re:RE: 32bit vs 64bit (was: Just like Christmas)

Kimberley,

The problem is that you loaded the 64 bit kernel in the K class.  It does
not have the buss required for 64 bit, therefore the kernel does a fake it 64
emulation.  Rebuild the machine with the 32 bit version of HP 11.0 & you'll be a
lot happier.  Ours stay up for months without problems & reboots are just fine. 
Personally I'd go kill your SA and/or the Hp zlutz that configured them.

Dick Goulet

Good hardware cannot fix bad software/configurations.

Reply Separator
Author: Kimberly Smith <[EMAIL PROTECTED]>
Date:   3/20/2001 11:05 AM

We are going 64-bit for HP but keeping Oracle at 32-bit.  We really
had no choice for the HP side.  We just need the memory that 32 bit
could not support.  We have 9 K-class servers here that have been running
11-64-bit for quite some time (relatively speaking).  But we are
getting rid of all our K-class servers.  The model we are running have
been nothing but trouble.  We hate to turn one off because it seems
like every time we reboot hardware dies.  Other fabs have been having
the same issue.  So we are going N-class for the database cluster
and A-class for the remaining.  Since your K-class servers are new they
probably don't have the same hardware issues we have.  HP even owned up
to having issues.

-Original Message-
Sent: Tuesday, March 20, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L

Interesting.  We've got a 4-way K570 w/3GB mem that we'll be moving from
HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which
means I can FINALLY get us to 8i!  YAY!

So, why or why not should one go to 64bit?  Here's my perception:

Pros
---
Should be faster (moving 2x as many bits around)

Cons
---
Requires major downtime to go from 32 to 64.
Patches don't seem to come as quickly as 32bit versions on HP.

Unknowns (for me)
-
How much faster, if at all, and in what areas (mem, I/O, disk)?
Possible client problems?  Our clients are all 8.0.5 for now.
Any difference/disadvantage if 3rd party OCI programs are
not recompiled?

TIA,
Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 20, 2001 11:06
> To: Multiple recipients of list ORACLE-L
> Subject: Re:Just like Christmas
> 
> 
> Kimberly,
> 
> Enjoy the N class boxes, especially in 64 bit mode.  They 
> really cook
> compared to a K.

This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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).
-- 
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
--

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

2001-03-21 Thread Dasko, Dan


WOW, in addition to protesting the sale of indulgences and trying to reform
The Church, and printing a Bible, he had time to bowl too?

Dan

[Henry sent]
Did you know Martin
Luther was an avid bowler?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  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).

But all is not gloom and doom for Oracle...

2001-03-21 Thread Tim Sawmiller


But all is not gloom and doom for Oracle.  Excerpts from Chuck Phillips of Morgan 
Stanley on the last quarter

It's useful to keep the quarter in perspective.  
It's a miss but not a  financial disaster:

 - Oracle made $900 million in operating profits in the quarter.  This is
 real business.

 - Revenue of $2.67 billion was 5% below our $2.75 billion estimate --
   not 25%  below like some other pre-announcements.

 - The company booked $1.1 billion in license revenue instead of our $1.2
   billion estimate -- so most deals closed.

 - Applications were up 50% in the quarter.  Database was flat to
   slightly  down in the quarter versus a tough compare.  Total licenses 
   increased  6%.

 Oracle was one of the last generals left standing on a brittle
 technology  battlefield, and in the end couldn't avoid the bullets and hand grenades  
that  were showering down from above.  It has become clear that in an  environment  
like this one, there are no bulletproof vests.  Other software companies  have  to be 
concerned and will likely see something in March.  Oracle has a  strong  product line, 
is well established with customers references and couldn't  get  quite enough deals 
done.  Most other software companies are in far  weaker  positions from a product and 
positioning perspective.


>>> [EMAIL PROTECTED] 03/21/01 01:52PM >>>

--- Forwarded message follows ---
Date sent:  Mon, 19 Mar 2001 02:04:08 -0500 (EST)

...


***
$1 Billion Savings Gets Even Less Likely For Oracle

Oracle's goal to reach one billion dollars in savings by implementing 
its own financial software just got even more unattainable. Oracle 
Thursday announced financial results for the third quarter, ending 
Feb. 28. As expected, the company failed to meet the margins and 
profits it will need to achieve its savings goals,  

The operating margin for the third quarter was 33 percent. That's up 
2 percent year-over-year, which is good, but it falls far short of 
the 40 percent margin that the company and financial analysts have 
said would be needed to achieve the company's goal of saving 1 
billion in costs this year over last year.  

Combine the disappointing operating margin with flat, rather than 
growing, profits and what you end up with is a cost savings, year-
over-year, significantly less than even the $300 million that it 
seemed was just barely within Oracle's reach two weeks ago. -- Mitch 
Wagner  

Read the entire story: 

http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LxJk 

***

...


Did someone forward this to you? Get your own issue...
http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LsYu 

Still not receiving your own FREE subscription to InternetWeek Magazine?
Subscribe by going to
http://update.internetweek.com/cgi-bin4/flo?y=eC2a0BdpN70V30LsZv 

This message powered by FloNetwork
http://www.flonetwork.com 
--- End of forwarded message ---


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Eric D. Pierce
  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: SUN vs. HP

2001-03-21 Thread Carle, William T (Bill), NLCIO

We use ServiceGuard here as well on HP-UX. We do not use OPS and I think
ServiceGuard works great.

Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Wednesday, March 21, 2001 10:29 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: SUN vs. HP

Why should you use OPS if you are using ServiceGuard?  We are not
here and I have not come up with a single reason to. If you have 
some I should relook at it. 

-Original Message-
Sent: Tuesday, March 20, 2001 8:17 PM
To: Multiple recipients of list ORACLE-L

 I have been working with Oracle under HP, I find HP server with high fault
toulerence and reliable. If we tune the OS and DB then we can get maximum
performance. One word of caution is that, if u use Mc Servicegaurd then u
shud go for OPS. Which works for only on RAW partitions. Administration will
not be a easy job. Instead go for AutoRAID box which HP has got. It converts
itself bet RAID5 and RAID1/0.

My recomendation will be for RAID10, where u have disk mirroring,stripping
and protection for Data and better performance.

I have not worked with SUN. But i have heard that the native
code,compilation and testing of oracle is in the SUN OS.

But HP is also a good OS.

H/w is slightly costlier in HP.

--

On Tue, 20 Mar 2001 10:31:59  
 Alex Apostolopoulos wrote:
>Hi,
>
>we are currently in the process of evaluating a high availiability cluster 
>for our production database. The final two solutions are:
>
>SunCluster 2x420R 2Gig 2x450Mhz 
>Storage 100Gig
>
>Hewlett Packard MC ServiceGuard
>2xL-Class 2x440Mhz 2Gig 
>Storage VA 7100 100Gig
>
>Based on our criterias (scalability, performance, TCO, price, reliability, 
>support, in house experience  ...) it looks like a dead race...
>
>Any suggestions or thoughts would be help full 
>
>cheers alex
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Alex Apostolopoulos
>  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 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: C.S.Venkata Subramanian
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  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: OT -- A humorous reply to the Canada rulz

2001-03-21 Thread Henry Poras


That's the story. They even have a lifesize model. 

-Original Message-
Sent: Wednesday, March 21, 2001 1:52 PM
To: Multiple recipients of list ORACLE-L


WOW, in addition to protesting the sale of indulgences and trying to reform
The Church, and printing a Bible, he had time to bowl too?

Dan

[Henry sent]
Did you know Martin
Luther was an avid bowler?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dasko, Dan
  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: Henry Poras
  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: OFFTOPIC RE: Rachel and Willie Wonka go to the Chocolate Factory.


I've always been a good little girl wouldn't have touched anything... 
and I am definitely NOT that spoiled little bratty girl!


>From: "Mohan, Ross" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OFFTOPIC RE: Rachel and Willie Wonka go to the Chocolate Factory.
>Date: Wed, 21 Mar 2001 08:40:44 -0800
>
>...question is: Is Rachel one of the "good kids" who doesn't
>swipe the yummies, or is she one of the out of control chocolateers
>who gets ejected from the facility?

_
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).

Re: DBA Job at a Chocolate Factory


Steve,

I don't think you're crazy..

I know you are :)

Actually I would turn that job down, if only because it would make me crazy 
to be around the chocolate and know that eating it would make me unfit to 
work


Rachel


>From: "Steve Orr" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: DBA Job at a Chocolate Factory
>Date: Wed, 21 Mar 2001 08:06:54 -0800
>
>Seven years ago I was offered an Oracle DBA job at a chocolate factory and
>turned it down. (Please don't tell Rachel, she already thinks I'm crazy.) I
>had two simultaneous offers for the same salary and took the one closer to
>home. While on the interview they gave me the full tour of the factory
>starting with the bags of cocoa beans on the docks. The smell was
>intoxicating and even wafted into the office area where I would have 
>worked.
>They had unlimited stashes of chocolate in every cubicle. I asked the
>employees if they ever got sick of chocolate and the answer was a 
>resounding
>NO. Now my kids will never forgive me for not having taken the job at the
>chocolate factory.
>
>This begs the question... Where and what are some of the most interesting
>Oracle DBA jobs out there? I heard of one deep underground at a mining
>operation in the middle of the Nevada desert. Database is a basic 
>technology
>that can be applied to just about any business anywhere. Any interesting
>stories? Personal experiences?
>
>
>Steve Orr
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve Orr
>   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 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).

OFF TOPIC: DBA Job at a Chocolate Factory

Title: OFF TOPIC: DBA Job at a Chocolate Factory





> -Original Message-
> From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]]
> 
> Now MY idea of a heavenly DBA gig would be at something like
> the Fred Astaire or Arthur Murray World Headquarters, where
> my wife and I would have access to a nice dance floor for
> our rehearsals, access to the occasional pro for coaching,
> and maybe discounts on dance shoes.  WOW!
> 
> BTW, those of you who will be in Louisville, KY on March
> 30th and 31st might find it amusing to watch this old DBA
> dance with his wife in the "Derby City North-Central
> Regional Amateur Dancesport Championships" at The Galt House
> hotel downtown.  Dancing, like good DBAing, takes a hell of
> a lot of hard work to make it look easy!



Don't listen to him! My wife participates in dance competitions and has "persuaded" me to join her in taking dance lessons at a local dance studio. I would prefer having to recover a crashed 24x7 mission critical database than have to enter a dance competition.

Jack, do you do ballroom or latin/jive? Of course, I happen to prefer ballroom (where you can get away with looking bored while you're dancing) and my wife likes latin (our salsa instructor is constantly exhorting us to "shake our booties" - trust me, you don't want to see a DBA shaking his booty).

RE: identifying shared memory segments

2001-03-21 Thread Riyaj_Shamsudeen



I think, your library path is not set correctly.
(ksh)
In sun
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib
In HP
 export  SHLIB_PATH=$ORACLE_HOME/lib
IN AIX
 export LIBPATH=$ORACLE_HOME/lib
and then try again...

Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies   www.i2.com


   
   
Mandar 
   
GhosalkarTo: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
 Subject: RE: identifying shared memory 
segments  
Sent by:   
   
root@fatcity.  
   
com
   
   
   
   
   
03/21/01   
   
12:28 PM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




David,
this is what i am getting. any ideas?

$ sysresv
ld.so.1: sysresv: fatal: libclntsh.so.8.0: open failed: No such file or
directory
Killed
$

-Mandar
> -Original Message-
> From: Lord David [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 11:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: identifying shared memory segments
>
>
> Under unix (Solaris at least): set your oracle environment and run
> $ORACLE_HOME/bin/sysresv.
> No idea about windoze.
>
> HTH
> David Lord
>
> -Original Message-
> Sent: 21 March 2001 16:02
> To: Multiple recipients of list ORACLE-L
>
>
> Me too!
>
> Thanks,Ruth B. Gramolini
> ORACLE & DB2  DBA
> VT Dept. of Taxes
> ph# 802.828.5708
> fax# 802.828..3754
> [EMAIL PROTECTED]
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 21, 2001 10:00 AM
>
>
> > A while back someone posted a method for determining which
> shared memory
> segments belonged to an instance. Can someone repost that and
> CC me? Thanks.
> >
> >
> > -
> > Do You Yahoo!?
> > Yahoo! Mail Personal Address - Get email at your own domain
> with Yahoo!
> Mail.
>
> --
> 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).
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to
> whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Lord David
>   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 mes

import/export

2001-03-21 Thread Leyden, Joseph


Should I be SYS or SYSTEM user
when exporting the entire database?

Help!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leyden, Joseph
  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: Easy Doubt in sql/plus


Eriovaldo,

Try this...

Select Col1 || Chr(10) || Col2 || Chr(10) || Col3 || Chr(10)
|| Col4 As TheList From Table;

Results...

THELIST
---
Value of Col1
Value of Col2
Value of Col3
Value of Col4

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]


-Original Message-
Eriovaldo do Carmo Andrietta
Sent: Wednesday, March 21, 2001 12:03 PM
To: Multiple recipients of list ORACLE-L


Hi Friends :

How can I do for put each column in new line using sql/plus

Example :

Select * from tab;

and the result sould be :

'value of column1'
'value of column2'
'value of column3'
'value of column4'
'value of column5'

and not

'value of column1' 'value of column2' 'value of column3'
'value of column4'
'value of column5'

Thanks

Eriovaldo

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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: LONG fields within triggers.

2001-03-21 Thread Morten Primdahl



Thanks for the prompt tip Jack, it works! :) Are there any caveats? 
How about concurrency? As it is now, I insert into the PL/SQL table
using

  v_Index := NVL(UpdatePackage.v_IDs.LAST, -1);
  v_Index := v_Index+1;
  UpdatePackage.v_IDs(v_Index) := :new.id;

within the row trigger. In the statement trigger I use

  v_Index := UpdatePackage.v_IDs.FIRST;
  WHILE v_Index IS NOT NULL LOOP

   BEGIN
OPEN  selectCursor; --Selects LONG field from the updated table
FETCH selectCursor INTO tempContent; --tempContent is a LONG var
CLOSE selectCursor;

IF tempContent IS NOT NULL THEN --Insert into target table
  INSERT INTO table_b (id, field) 
  VALUES (UpdatePackage.v_IDs(v_Index),''||tempContent||'');
  tempContent := NULL;
END IF;
   END;
   UpdatePackage.v_IDs.DELETE(v_Index); --Delete from the PL/SQL table
   v_Index := UpdatePackage.v_IDs.NEXT(v_Index);
  END LOOP;

Any bets on the thread safety on this procedure? What if eg. 4 users
update the PL/SQL table in the row triggers, and all 4 of the subsequent
statement triggers read the same variable from the PL/SQL table. Is
this an issue at all? I'm not at all experienced in the more complex
ways of PL/SQL.

Thanks a ton.

Morten


On Wed, 21 Mar 2001, Jack C. Applewhite wrote:

> Morten,
> 
> One solution to this classic "Mutating Table" problem is to
> capture the ID (better yet, RowID) of each inserted row in a
> public PL/SQL table in an After Row Trigger, then loop
> through the PL/SQL table in an After Statement Trigger and
> do your Selects and Inserts.  Works great.
> 
> Jack
> 
> 
> Jack C. Applewhite
> Database Administrator/Developer
> OCP Oracle8 DBA
> iNetProfit, Inc.
> Austin, Texas
> www.iNetProfit.com
> [EMAIL PROTECTED]
> 
> 
> -Original Message-
> Morten
> Primdahl
> Sent: Wednesday, March 21, 2001 9:16 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Hi. I'm indexing the DB with the use of triggers.
> In one table, I have a LONG field, I need to read
> the :new value of this field in the trigger, modify
> it slightly, and insert the value into my context
> indexed table.
> 
> I'm not allowed to query the table in the trigger
> because of mutation, so I cannot do stuff like
> 
>   CREATE TRIGGER ... ON test_table
>   FOR EACH ROW
>   DECLARE
>   tempContent LONG;
> 
>   CURSOR selectCursor IS
> SELECT long_field FROM test_table WHERE id = :new.id;
> 
>   BEGIN
>   OPEN  selectCursor;
> FETCH selectCursor INTO tempContent;
>   CLOSE selectCursor;
> 
> And I cannot reference the LONG field directly, eg.
> :new.long_field,
> what can be done? I need to do the equivalent of
>   BEGIN
> INSERT INTO other_table VALUES
> ('PREFIX'||:new.long_field||'POSTFIX');
>   END;
> In the trigger. Any help greatly appreciated.
> 
> Thanks
> 
> Morten
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Jack C. Applewhite
>   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: Morten Primdahl
  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).

OT: Re: DBA Job at a Chocolate Factory

2001-03-21 Thread Jim Conboy


Yeah, scofflaw seems to be a common ailment among presidential types.  Our current 
prez is no stranger to the handcuffs either and he and the veep total 5 arrests 
between them.  

Jim

>>> [EMAIL PROTECTED] 03/21/01 12:56PM >>>
I had a short gig setting up a database in Tallahassee State prison. They
had the prisoners entering data for underground utility lines. I had to
train the DBA who was in for 10 years for 3 counts of assault and battery.
That was like being on another, very bad, planet.
If anyone has any intrest in commiting crimes (unless you're a certain
recent former President then you can do whatever you want without fear of
justice) I urge you to tour such a facility. You'll never have an intrest
in commiting crime again.

-Rocky

--- Steve Orr <[EMAIL PROTECTED]> wrote:
> Seven years ago I was offered an Oracle DBA job at a chocolate factory
> and
> turned it down. (Please don't tell Rachel, she already thinks I'm
> crazy.) I
> had two simultaneous offers for the same salary and took the one closer
> to
> home. While on the interview they gave me the full tour of the factory
> starting with the bags of cocoa beans on the docks. The smell was
> intoxicating and even wafted into the office area where I would have
> worked.
> They had unlimited stashes of chocolate in every cubicle. I asked the
> employees if they ever got sick of chocolate and the answer was a
> resounding
> NO. Now my kids will never forgive me for not having taken the job at
> the
> chocolate factory.
> 
> This begs the question... Where and what are some of the most
> interesting
> Oracle DBA jobs out there? I heard of one deep underground at a mining
> operation in the middle of the Nevada desert. Database is a basic
> technology
> that can be applied to just about any business anywhere. Any interesting
> stories? Personal experiences?
> 
> 
> Steve Orr
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: Steve Orr
>   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: 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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jim Conboy
  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: identifying shared memory segments

2001-03-21 Thread Ruth Gramolini


I get a 'not found' when I try to run it on AIX. RBG

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 12:02 PM


> Under unix (Solaris at least): set your oracle environment and run
> $ORACLE_HOME/bin/sysresv.
> No idea about windoze.
>
> HTH
> David Lord
>
> -Original Message-
> Sent: 21 March 2001 16:02
> To: Multiple recipients of list ORACLE-L
>
>
> Me too!
>
> Thanks,Ruth B. Gramolini
> ORACLE & DB2  DBA
> VT Dept. of Taxes
> ph# 802.828.5708
> fax# 802.828..3754
> [EMAIL PROTECTED]
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 21, 2001 10:00 AM
>
>
> > A while back someone posted a method for determining which shared memory
> segments belonged to an instance. Can someone repost that and CC me?
Thanks.
> >
> >
> > -
> > Do You Yahoo!?
> > Yahoo! Mail Personal Address - Get email at your own domain with Yahoo!
> Mail.
>
> --
> 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).
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Lord David
>   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: Locking

Title: RE: Locking





> -Original Message-
> From: Richard Lau [mailto:[EMAIL PROTECTED]]
> 
> Recently, one of my users nor I could update a table.  As I 
> dug around, I 
> couldn't find any of the 'lock' tables such as dba_locks.  
> Eventually, I 
> managed to start data gatherer and get OEM's lock manager to 
> kill the hung 
> session.  What do you guys do to find and terminate this 
> deadlock or hung 
> sessions?  Are the 'lock' system tables built with specific 
> options during 
> db build?


To create the "dba_locks" view, run
$ORACLE_HOME/rdbms/admin/catblock.sql



Here is a sample SQL*Plus script to find locks in the database. This originally came from a list member (very possibly Jared Still).

column username format a10 heading "User"
column object format a20 heading "Object"
column type format a4 heading "Type"
column mode_desc format a15 heading "Mode"


/* only non-sys objects */
select
   s.username,
   s.sid,
   o.owner || '.' || o.object_name as object,
   l.type,
   l.request,
   l.lmode,
   decode (l.lmode, 1, '',
    2, 'Row Share',
    3, 'Row exclusive',
    4, 'Share',
    5, 'Share row exclusive',
    6, 'Exclusive',
    'Other')
    as mode_desc
 from
   v$lock l,
   v$session s,
   dba_objects o
 where
   l.sid = s.sid
   and l.id1 = o.object_id
   and o.owner != 'SYS' ;

RE: identifying shared memory segments

2001-03-21 Thread Mohammad Rafiq


How about

ipcs -mb |grep oracle

It will give you more condensed info about usage of shared memory segment.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wed, 21 Mar 2001 09:02:53 -0800

ipcs -b should give you details of shared memory segments

-Original Message-
Sent: Wednesday, March 21, 2001 8:02 AM
To: Multiple recipients of list ORACLE-L


Me too!

Thanks,Ruth B. Gramolini
ORACLE & DB2  DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 10:00 AM


 > A while back someone posted a method for determining which shared memory
segments belonged to an instance. Can someone repost that and CC me? Thanks.
 >
 >
 > -
 > Do You Yahoo!?
 > Yahoo! Mail Personal Address - Get email at your own domain with Yahoo!
Mail.

--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pampati, Kiran
   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 FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  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/export

2001-03-21 Thread Rocky Welch


System is fine.

--- "Leyden, Joseph" <[EMAIL PROTECTED]> wrote:
> Should I be SYS or SYSTEM user
> when exporting the entire database?
> 
> Help!
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Leyden, Joseph
>   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: 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: Data into another table