-
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
-
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|