RE: What is the result of this

Mark,

        I know an HP consultant who did just that at the end of a grueling 12 hour install of Service Guard. Did not realize what he had done, until after he hit the return key??? DOH, long day followed by longer night!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Wednesday, April 16, 2003 11:29 AM To: Multiple recipients of list ORACLE-L

"And ask about the usefulness of the command rm -rf *

(especially when run in the / directory)"

I know a software developer that did this once! That was pretty.. :P

-----Original Message-----
Sent: 16 April 2003 15:44
To: Multiple recipients of list ORACLE-L

> -----Original Message-----
>
> It will stack the call and use more and more resources, check
> the size of
> the session PGA.
> You can do recursivity with SQL.

I'm fiddling with it. The thing I originally sent was just a skeleton idea. After putting a little meat on the bones, it doesn't seem to be problem in the test database (of course, everything always works in the test database). One thing I discovered is that I can't run it as system to drop the index from bubba's schema. It always says the index does not exist. It doesn't like the BUBBA.INDEX_NAME. I have to run it as bubba and drop INDEX_NAME. I've not checked the PGA size while it was running; I'll see about doing that.

>
> Jared, you should ask about recursivity with SQL in your interviews.
>

And ask about the usefulness of the command rm -rf *

(especially when run in the / directory)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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.net
-- 
Author: Goulet, Dick
  INET: DGoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).