replication questions, part duex

This is a consolidation and refocus of a prior thead ...

Replication environment ..
  Master site: Oracle 8.1.7 on Solaris 9   MV site: Oracle 10.2 on Win2k3

I have 10 scripts, each to define an individual MV. General form is:

DROP MATERIALIZED VIEW ....
/
CREATE MATERIALIZED VIEW ...
/

And an overall script called build_mv.sql, like this:

@mv_REP_HOST_TXLOG.sql
@mv_REP_LA_TXLOG.sql
@mv_REP_MERCHANT.sql

-- etc.

Two very odd observations.
First, If I run this as SYSTEM, I get "ORA-01031: insufficient privileges" on the CREATE statement, but not the DROP. SYSTEM has the default DBA role. If I run it as the owning schema, everything works as far as authorization and privileges.

Second, when running as the owning username, I get inconsistent results. *Sometimes*, *some* of the CREATE statements return

 62  	 "DC_TXLOG"."AVSRESULTCODE" "AVSRESULTCODE",
 63  	 "DC_TXLOG"."ID" "ID"
 64  	 FROM "DC_TXLOG"@EPS_LINK.US.ORACLE.COM "DC_TXLOG"

    "DC_TXLOG"."ID" "ID"
    *
ERROR at line 63:
ORA-00904: "DC_TXLOG"."ID": invalid identifier

Without touching anything I can run this several times, and get failures on different CREATE scripts. On the failures, the offending column is always the last in the list. When I try to break it down by removing that column from the list, the failure will occur on the new last column in the list. Received on Wed Apr 26 2006 - 13:10:30 CDT