Materialsed View error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Materialsed View error

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Materialsed View error

    Hi trying to create an MView through a db link.
    Getting weird errors, anyone come across these before?

    thanks




    SQL> desc ifc_ib.ifc_ib_system_v@LINK.world
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    ISV_SYSTEM_ID NOT NULL NUMBER(38)
    ISV_SYSTEM_NAME NOT NULL VARCHAR2(64)
    ISV_BUILDING_ID VARCHAR2(10)
    ISV_CRE_CODE VARCHAR2(10)
    ISV_BUILDING_NAME VARCHAR2(4000)
    ISV_TIMEZONE VARCHAR2(3997)
    ISV_SLP_ID VARCHAR2(132)
    ISV_SLP_VALUE VARCHAR2(4000)

    SQL> CREATE MATERIALIZED VIEW SYSTEM
    2 NOCACHE
    3 NOLOGGING
    4 NOPARALLEL
    5 REFRESH complete
    6 START WITH TO_DATE('05-Dec-2006','dd-mon-yyyy')
    7 AS
    8 select ISV_SYSTEM_ID,ISV_SYSTEM_NAME,ISV_BUILDING_ID,ISV_CRE_CODE,
    9 ISV_BUILDING_NAME,ISV_TIMEZONE,ISV_SLP_id,ISV_SLP_VALUE
    10 from ifc_ib.ifc_ib_system_v@LINK.world
    11 /
    ISV_BUILDING_NAME,ISV_TIMEZONE,ISV_SLP_id,ISV_SLP_VALUE
    *
    ERROR at line 9:
    ORA-02068: following severe error from LINK
    ORA-00600: internal error code, arguments: [16608], [2], [4], [0x390F67A20],
    [], [], [], []
    ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 919
    ORA-06512: at line 1

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Bug 1409835
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    hi davey....i search this bug number on metalink but there is no hits
    found...How to I search it pls

    I click the folder Bug Search and enter the bug number.... is it
    right?


    Thanks
    Behind The Success And Failure Of A Man Is A Woman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width