Database Administration (MOSC)

MOSC Banner

Mview creation PLS-00352: Unable to access another database 'PASS.COM'

edited Aug 8, 2016 5:00AM in Database Administration (MOSC) 1 commentAnswered

I'm trying to fast refresh a mview in 12c , the source is 9i

From 9i , I have connected to intermediate db to 10g, I'm able to fast refresh the mview in 10g.

I'm trying to fast refresh mview in 12c, pointing to the one in 10g.

CREATE MATERIALIZED VIEW TAPER.SUMM

TABLESPACE SRO_DATA_T01

PCTUSED    0

PCTFREE    10

INITRANS   2

MAXTRANS   255

STORAGE    (

            INITIAL          80K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

BUILD IMMEDIATE

USING INDEX

            TABLESPACE SRO_DATA_T01

            PCTFREE    10

            INITRANS   2

            MAXTRANS   255

            STORAGE    (

                        INITIAL          64K

                        MINEXTENTS       1

                        MAXEXTENTS       UNLIMITED

                        PCTINCREASE      0

                        BUFFER_POOL      DEFAULT

                       )

REFRESH FAST

START WITH TO_DATE('17-07-2016 02:48:00','dd-mm-yyyy hh24:mi:ss')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center