RE: Who Says Oracle does not listen

This is a multi-part message in MIME format.

------=_NextPart_000_0068_01C3506C.B763FFE0
Content-Type: text/plain;

        charset="US-ASCII"
Content-Transfer-Encoding: 7bit

In this case performance is not an issue.

I don't drop/create/modify tables/columns/synonyms every minute. The script runs, when we install new release of our product, happens once in a few months.  

Igor Neyman, OCP DBA

ineyman_at_perceptron.com    

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

From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On Behalf Of Alexander.Feinstein_at_mitchell1.com
Sent: Tuesday, July 22, 2003 3:30 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Who Says Oracle does not listen  

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 Received on Tue Jul 22 2003 - 15:17:15 CDT