RE: Who Says Oracle does not listen

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------=_NextPartTM-000-5c379ec5-bc52-11d7-985d-0008c79fc2b3
Content-Type: multipart/alternative;

        boundary="----_=_NextPart_001_01C35087.DF6D11A0"

------_=_NextPart_001_01C35087.DF6D11A0

Content-Type: text/plain

Performance.
You do check, and the DBMS does check internally.

Alex.

-----Original Message-----

From: Igor Neyman [mailto:ineyman_at_perceptron.com] Sent: Tuesday, July 22, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Who Says Oracle does not listen

Doing it my way just seems to be "cleaner": why forcing exception, when it could be avoided?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

Alex Feinstein
Sent: Tuesday, July 22, 2003 1:44 AM
To: Multiple recipients of list ORACLE-L

RE: Who Says Oracle does not listenAgree. One can improve EXCEPTION section to ignore only relevant errors.

Alex.

• Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Monday, July 21, 2003 6:19 AM

That's not good enough.
I don't want to discard ANY exception.
When dropping table, I don't want to see error messages only if there is nothing to drop. While if let's say there is a problem with privileges, it will go unnoticed. Or, when adding a table, it's fine not be getting an error, if table already exists. But, if there is no room to create a table, or to add a partition to the table, I want to see this error message.

So, I still prefer my way of doing it (see scripts in my original message)
comparing to Oracle's script, you refer to.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

Alexander.Feinstein_at_mitchell1.com
Sent: Friday, July 18, 2003 6:10 PM Received on Tue Jul 22 2003 - 14:31:39 CDT