RE: Who Says Oracle does not listen

Igor Neyman Tue, 22 Jul 2003 13:26:17 -0700

Title: RE: Who Says Oracle does not listen

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

[EMAIL PROTECTED]

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
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
[EMAIL PROTECTED]

-----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
[EMAIL PROTECTED]

-----Original Message-----
[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 6:10 PM
To: Multiple recipients of list ORACLE-L

From ORACLE own script:
Rem
Rem Drop tables without raising errors if they do not exist
Rem
declare
   PROCEDURE drop_force(tab varchar2) IS
   BEGIN
      EXECUTE IMMEDIATE 'DROP TABLE ' || tab;
   EXCEPTION WHEN OTHERS THEN
      NULL;
   END;
begin
   drop_force('utl_recomp_invalid');
   drop_force('utl_recomp_sorted');
   drop_force('utl_recomp_compiled');
   drop_force('utl_recomp_backup_jobs');
   drop_force('utl_recomp_log');
end;
/
Alex.
-----Original Message-----
Sent: Friday, July 18, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L

Sure, I would.
But I can't wait till Oracle "turns around".
My scripts are executed by our "field" engineers, who know next to nothing about Oracle, and the only thing they can do is to check log files for error messages (and even this is done automatically). Igor Neyman, OCP DBA [EMAIL PROTECTED]

-----Original Message-----
Goulet, Dick
Sent: Friday, July 18, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Igor,
True enough, but wouldn't you like it as part and parcel of the command? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message-----

Sent: Friday, July 18, 2003 4:35 PM
To: Multiple recipients of list ORACLE-L

To avoid those errors in my scripts I'm checking data dictionary for the "existence" of the object (fortunately, dynamic sql helps here): REM Dropping synonym DECLARE lCounter integer; begin SELECT COUNT(*) INTO lSyn

        FROM dba_synonyms WHERE synonym_name = 'PRCPV_REPORT_INFO' AND OWNER = 'PUBLIC'; IF (lSyn = 1) THEN
        EXECUTE IMMEDIATE 'drop PUBLIC SYNONYM PRCPV_Report_Info'; END IF; end; /
or:
REM Adding column
DECLARE lCounter integer;
begin
SELECT count(*) INTO lCounter
        FROM DBA_TAB_COLUMNS
        WHERE table_name = 'PRCP_MENU'
          AND column_name = 'MENU_NAME'
          AND owner = 'IPN_DBA';
IF (lCounter = 0) THEN
        EXECUTE IMMEDIATE 'ALTER TABLE prcp_menu ADD menu_name
VARCHAR2(50) NULL';
END IF;
end;
/
Igor Neyman, OCP DBA
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex Feinstein
INET: [EMAIL PROTECTED]

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: [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.net
--
Author: Igor Neyman
INET: [EMAIL PROTECTED]

RE: Who Says Oracle does not listen

Reply via email to