RE: Small help (To Lee)

Eh ???

I don't think there is any call for that. I told you whereabouts in the doc set the manuals were and suggested that you look there.

I am certainly not a "Great and full of experience DBA" as you suggest but was merely passing on what experience I do have whilst coming across a similar problem myself a couple of years ago.

FYI, I have been an Oracle DBA for some 4-5 years now. Please bear this in mind when you next need help/advice because it certainly won't be forthcoming from this direction.

Not the best way to kick of your "list career" is it ?

Lee

-----Original Message-----
Sent: 29 March 2001 09:05
To: Multiple recipients of list ORACLE-L

Lee,

Thanks for your advise, for me this question is just kick off to the world of ORACLE PL/SQL scripting,
I don't know why you think that I would like to ask from a Great and full of experiance DBA like you Mr. Lee to spoon feeding me.

Again Thank You so much for your advise

Xing,

-----Original Message-----
Lee Robertson
Sent: Thursday, 29 March 2001 3:16 PM
To: Multiple recipients of list ORACLE-L

Xing,

Have a look at the documentation, specifically, Application Developers Guide, section dealing with "Using Procedures and Packages".

No disrespect intended but sometimes, certainly for questions such as this, you will learn a heck of a lot more by digging around in the docs, and reading (and working out) the answer for yourself. That is certainly my experience. You will also fell encouraged to delve further and learn more about other packages etc. Hope my pointer will help you.

To the rest of you - I know it would have been quicker to write down the answer to Xings question, but what will he have learned about the general syntax ??

Regards

Lee

-----Original Message-----
Sent: 29 March 2001 07:05
To: Multiple recipients of list ORACLE-L

Hi DBAs and SAs,

Can someone tell me what is this ORACLE PL/SQL Script all about,.. Ya... I know I have to read alot, my OCP course will start next month.

BEGIN
   dbms_utility.analyze_schema ( '&OWNER', 'ESTIMATE', NULL, 5 ) ; END ;
/

Thank you

Xing

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
  INET: sinardyxing_at_bcsis.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: lerobe - Lee Robertson
  INET: LEROBE_at_acxiom.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: Sinardy Xing
  INET: sinardyxing_at_bcsis.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: lerobe - Lee Robertson
  INET: LEROBE_at_acxiom.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).