RE: Off topic: Need ideas for 'Take your child to work' day 4/25

2002-04-06 Thread Abdul Aleem

We had once a class visiting us,

We asked the school to give us the names of the students with a little
personal information like class, teacher's name, parent's name, address,
phone, likes and dislikes, and picture.

We created a small application, single database and encouraged the children
to use it and find about their friends, add/edit what they like to.

Not all but most of the students enjoyed it.

Aleem

 -Original Message-
Sent:   Friday, April 05, 2002 7:18 PM
To: Multiple recipients of list ORACLE-L
Subject:        Re: Off topic:  Need ideas for 'Take your child to work' day
4/25

[EMAIL PROTECTED] wrote:

> Our office is doing 'Take your child to work' day and the plan is for an
> older child to shadow me for a little while as we do some simple Oracle
dba
> or development work.
> 
> I'd really like to make this meaningful by having the child do a task
that's
> simpler (than optimizing all our procedures) but realistic (instead of
being
> relegated to the lunchroom to watch tv) with me for an hour or so.
> 
> Has anyone ever done this?  I'd appreciate any lessons learned or
> suggestions.  
> 
> Thanks!
> 
> Barbara
> 

can you create a test db?  if you've got the space on a test server it 
would be ideal.  have them do the typing, and explain what each 
parameter is for and what it does.  then have them sign on and run 
catalog and catproc and watch all the stuff stream by.


-- 
--
Bill "Shrek" Thater  ORACLE DBA
 [EMAIL PROTECTED]

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

Murphy's Third Law: In any field of scientific endeavor, anything that 
  can go wrong will go wrong.




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Abdul Aleem
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Need ideas for 'Take your child to work' day 4/25

2002-04-05 Thread Scott . Shafer

Do not let the kiddo hit  until you've reviewed what is typed on
each line.  Kudos for making the effort, although a DBA's day would probably
create emotional scarring in young children...  

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Dungey, Barbara [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 04, 2002 8:13 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:      Off topic:  Need ideas for 'Take your child to work' day
> 4/25
> 
> Our office is doing 'Take your child to work' day and the plan is for an
> older child to shadow me for a little while as we do some simple Oracle
> dba
> or development work.
> 
> I'd really like to make this meaningful by having the child do a task
> that's
> simpler (than optimizing all our procedures) but realistic (instead of
> being
> relegated to the lunchroom to watch tv) with me for an hour or so.
> 
> Has anyone ever done this?  I'd appreciate any lessons learned or
> suggestions.  
> 
-- 
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: Off topic: Need ideas for 'Take your child to work' day 4/25

2002-04-05 Thread Orr, Steve

> Give them root access and let them have at it!! 
No... Just give them OEM and let them point and click to their hearts desire
so they can be just as dangerous as a real JUNIOR DBA. 



-Original Message-
Sent: Friday, April 05, 2002 5:08 AM
To: Multiple recipients of list ORACLE-L
4/25


Give them root access and let them have at it!!  Remember, it's a learning
experience.  Actually I have done this with my kids and I had then go on a
tour with someone that knows that manufacturing facility, and then had them
spend time in order entry, and the some time in the distribution center.
They also had some time in the IS department but by showing them the whole
facility they can see that what you do effects everything.  They can only
sit and watch you type for so long.  Oh yea, I also let them spend some time
with the PC techs and they got to "fix" some PC's.

Dave

-Original Message-
Sent: Thursday, April 04, 2002 8:13 PM
To: Multiple recipients of list ORACLE-L


Our office is doing 'Take your child to work' day and the plan is for an
older child to shadow me for a little while as we do some simple Oracle dba
or development work.

I'd really like to make this meaningful by having the child do a task that's
simpler (than optimizing all our procedures) but realistic (instead of being
relegated to the lunchroom to watch tv) with me for an hour or so.

Has anyone ever done this?  I'd appreciate any lessons learned or
suggestions.  

Thanks!

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Need ideas for 'Take your child to work' day 4/25

2002-04-05 Thread Mark Leith

Yeah, and create a tablespace, with datafile - then create a table in that
tablespace (with PK etc.) and create an index for the PK and any other
fields that would warrant an index..

-Original Message-
Sent: 05 April 2002 15:18
To: Multiple recipients of list ORACLE-L
4/25


[EMAIL PROTECTED] wrote:

> Our office is doing 'Take your child to work' day and the plan is for an
> older child to shadow me for a little while as we do some simple Oracle
dba
> or development work.
>
> I'd really like to make this meaningful by having the child do a task
that's
> simpler (than optimizing all our procedures) but realistic (instead of
being
> relegated to the lunchroom to watch tv) with me for an hour or so.
>
> Has anyone ever done this?  I'd appreciate any lessons learned or
> suggestions.
>
> Thanks!
>
> Barbara
>

can you create a test db?  if you've got the space on a test server it
would be ideal.  have them do the typing, and explain what each
parameter is for and what it does.  then have them sign on and run
catalog and catproc and watch all the stuff stream by.


--
--
Bill "Shrek" Thater  ORACLE DBA
 [EMAIL PROTECTED]

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

Murphy's Third Law: In any field of scientific endeavor, anything that
  can go wrong will go wrong.




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

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

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

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

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

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



Re: Off topic: Need ideas for 'Take your child to work' day 4/25

2002-04-05 Thread bill thater

[EMAIL PROTECTED] wrote:

> Our office is doing 'Take your child to work' day and the plan is for an
> older child to shadow me for a little while as we do some simple Oracle dba
> or development work.
> 
> I'd really like to make this meaningful by having the child do a task that's
> simpler (than optimizing all our procedures) but realistic (instead of being
> relegated to the lunchroom to watch tv) with me for an hour or so.
> 
> Has anyone ever done this?  I'd appreciate any lessons learned or
> suggestions.  
> 
> Thanks!
> 
> Barbara
> 

can you create a test db?  if you've got the space on a test server it 
would be ideal.  have them do the typing, and explain what each 
parameter is for and what it does.  then have them sign on and run 
catalog and catproc and watch all the stuff stream by.


-- 
--
Bill "Shrek" Thater  ORACLE DBA
 [EMAIL PROTECTED]

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

Murphy's Third Law: In any field of scientific endeavor, anything that 
  can go wrong will go wrong.




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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Need ideas for 'Take your child to work' day 4/25

2002-04-05 Thread Farnsworth, Dave

Give them root access and let them have at it!!  Remember, it's a learning experience. 
 Actually I have done this with my kids and I had then go on a tour with someone that 
knows that manufacturing facility, and then had them spend time in order entry, and 
the some time in the distribution center.  They also had some time in the IS 
department but by showing them the whole facility they can see that what you do 
effects everything.  They can only sit and watch you type for so long.  Oh yea, I also 
let them spend some time with the PC techs and they got to "fix" some PC's.

Dave

-Original Message-
Sent: Thursday, April 04, 2002 8:13 PM
To: Multiple recipients of list ORACLE-L


Our office is doing 'Take your child to work' day and the plan is for an
older child to shadow me for a little while as we do some simple Oracle dba
or development work.

I'd really like to make this meaningful by having the child do a task that's
simpler (than optimizing all our procedures) but realistic (instead of being
relegated to the lunchroom to watch tv) with me for an hour or so.

Has anyone ever done this?  I'd appreciate any lessons learned or
suggestions.  

Thanks!

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Off topic: Need ideas for 'Take your child to work' day 4/25

2002-04-04 Thread Reardon, Bruce (CALBBAY)

What about blocking locks
use utllockt to show a "graphical" output of the waiters building up
And you get to show the fun of alter system kill session to get rid of the
blockers !

And get a demo of spotlight and show how much data goes back and forth or in
the database for 2 different queries that bring back the same answer
ie demonstrate efficient SQL

Bruce Reardon

-Original Message-
Sent: Friday, 5 April 2002 14:58
To: Multiple recipients of list ORACLE-L
4/25


What about some simple SQL statements?  That might be fun.  Especially if
you create a table "family" and enter in names, birthdates, etc.

--JoJo


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 6:13 PM


Our office is doing 'Take your child to work' day and the plan is for an
older child to shadow me for a little while as we do some simple Oracle dba
or development work.

I'd really like to make this meaningful by having the child do a task that's
simpler (than optimizing all our procedures) but realistic (instead of being
relegated to the lunchroom to watch tv) with me for an hour or so.

Has anyone ever done this?  I'd appreciate any lessons learned or
suggestions.

Thanks!

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: JoJo Zawawi
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Need ideas for 'Take your child to work' day 4/25

2002-04-04 Thread JoJo Zawawi

What about some simple SQL statements?  That might be fun.  Especially if
you create a table "family" and enter in names, birthdates, etc.

--JoJo


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 6:13 PM


Our office is doing 'Take your child to work' day and the plan is for an
older child to shadow me for a little while as we do some simple Oracle dba
or development work.

I'd really like to make this meaningful by having the child do a task that's
simpler (than optimizing all our procedures) but realistic (instead of being
relegated to the lunchroom to watch tv) with me for an hour or so.

Has anyone ever done this?  I'd appreciate any lessons learned or
suggestions.

Thanks!

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: JoJo Zawawi
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Need ideas for 'Take your child to work' day 4/25

2002-04-04 Thread hemantchitale


"Point-and-Click" GUI tools (like OEM) would be attractive but dangerous.
How about showing  them OEM on a Test Server (and ensure that OEM CANNOT
connect
to any other database) ?  Show them the Tablespace Layout and draw an
analogy
with their cupboards/shelves at home.  Show them the Instance Startup and
Shutdown
"traffic signal".

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


"Dungey, Barbara" <[EMAIL PROTECTED]>05/04/2002 10:13 AM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L
   

 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>   

 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) 
            
         Subject: Off topic:  Need ideas for 'Take your child to work' day 4/25

   

   

   






Our office is doing 'Take your child to work' day and the plan is for an
older child to shadow me for a little while as we do some simple Oracle dba
or development work.

I'd really like to make this meaningful by having the child do a task
that's
simpler (than optimizing all our procedures) but realistic (instead of
being
relegated to the lunchroom to watch tv) with me for an hour or so.

Has anyone ever done this?  I'd appreciate any lessons learned or
suggestions.

Thanks!

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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).



Off topic: Need ideas for 'Take your child to work' day 4/25

2002-04-04 Thread Dungey, Barbara

Our office is doing 'Take your child to work' day and the plan is for an
older child to shadow me for a little while as we do some simple Oracle dba
or development work.

I'd really like to make this meaningful by having the child do a task that's
simpler (than optimizing all our procedures) but realistic (instead of being
relegated to the lunchroom to watch tv) with me for an hour or so.

Has anyone ever done this?  I'd appreciate any lessons learned or
suggestions.  

Thanks!

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

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

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