Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ORA-00904 revisited, found something

ORA-00904 revisited, found something

From: Vladimir Barac <vladob_at_aster.si>
Date: Wed, 17 Jul 2002 06:53:25 -0800
Message-ID: <F001.00499F89.20020717065325@fatcity.com>


After doing some tracing

alter system set events '904 trace name errorstack forever';

on database which is being exported (8.1.7.0) with exp8.1.7.2, trace file said to me that there is problem with SYS.EXU8JBQ...

Then, I have compared catexp.sql from both versions and found... gues what?????

Views EXU8BJQ are pretty different on 8.1.7.0 and 8.1.7.2 !!! Isn't that weird? After database versions difference is at fourth digit!!!

So, is it safe to run catexp from 8.1.7.2 on 8.1.7.0?

Here is part of catexp 8.1.7.2

REM
REM Job Queues
REM
CREATE OR REPLACE VIEW exu8jbq

                (job, ownerid, owner, lowner, cowner, next_date, flag,
                 interval#, what, nlsenv, env, instance) AS
                SELECT j$.job, u$.user#, j$.powner, j$.lowner, j$.cowner,
                       to_char(j$.next_date, 'YYYY-MM-DD:HH24:MI:SS'),
                       decode(j$.flag,1,'TRUE',0,'FALSE'),
                       replace(j$.interval#,'''',''''''),
                       replace(j$.what,'''',''''''),
                       replace(j$.nlsenv,'''',''''''),
                       j$.env, j$.field1
                FROM sys.job$ j$, sys.user$ u$
                WHERE j$.powner = u$.name

Here is catexp from 8.1.7.0

REM
REM Job Queues
REM
CREATE OR REPLACE view exu8jbq

         (job, ownerid, owner) as
  SELECT j$.job, u$.user#, j$.powner
  FROM sys.job$ j$, sys.user$ u$
  WHERE j$.powner = u$.name

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vladimir Barac
  INET: vladob_at_aster.si

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). Received on Wed Jul 17 2002 - 09:53:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US