Are you calling the catrep8m script directly ? Or is it being
called
from some other script [eg catproc.sql ?].
Are you using Advanced Replication ?
Hemant
At 02:28 PM 20-01-03 -0800, you wrote:
Hi everyone!
Has anyone seen this and know a solution? I am upgrading a base from 7.3.4 to 8.0.6. Everything appears to go fine until the catrep8m script. In that script I get several errors:
Statement processed.
(P.delivery_order < C.cscn)))))
*
ORA-00904: invalid column name
grant select on defcalldest to select_catalog_role
*
ORA-00942: table or view does not exist
comment on table DEFCALLDEST is
*
ORA-00942: table or view does not exist
comment on column DEFCALLDEST.CALLNO is
*
ORA-00942: table or view does not exist
comment on column DEFCALLDEST.DEFERRED_TRAN_ID is
*
ORA-00942: table or view does not exist
comment on column DEFCALLDEST.DBLINK is
*
ORA-00942: table or view does not exist
DROP PUBLIC SYNONYM defcalldest
*
ORA-01432: public synonym to be dropped does not exist
Statement processed.
OR (P.delivery_order < C.cscn))))
*
ORA-00904: invalid column name
Statement processed.
Statement processed.
Statement processed.
This then forces several dictionary packages invalid and they wont' recompile.
I have tried rebuilding the dictionary before I upgrade and rebuilding after I upgrade. Neither one seems to work. When I rebuild, the catrep script gives that same error.
So far Oracle hasn't been able to find it. Has anyone seen this and know the fix?
Thanks in advance.
--Chris
Chris.Bowes@Kosa.Com
Hemant K Chitale
My web site page is :
http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: hkchital@singnet.com.sg
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: ListGuru@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 Tue Jan 21 2003 - 07:54:46 CST
