EdStevens wrote:
> 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"
> 65 /
> "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.
>
Just a shot in the dark: what if you rework the scripts to clear text,
that is, not double quotes?
A long shot, pointing nowhere...
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Thu Apr 27 2006 - 12:38:30 CDT
