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