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

Home -> Community -> Usenet -> c.d.o.server -> Re: replication questions, part duex

Re: replication questions, part duex

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 27 Apr 2006 19:38:30 +0200
Message-ID: <e2qvg6$d69$1@news4.zwoll1.ov.home.nl>


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

Original text of this message

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