SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need Help in Mat View Creation

SID3Mar 3 2008 — edited Mar 3 2008

I have the following query to create a mat view

CREATE MATERIALIZED VIEW IB_CONT1
REFRESH FAST ON DEMAND WITH ROWID
AS
  SELECT
        CUST,
        CONSEQ,
        STD,
        ENDD,
        ADD      
 FROM
     ADMIN.CONTACT@IB_DBLINK;

But it displays an error as

        ADMIN.CONTACT@IB_DBLINK
                  *
ERROR at line 11:
ORA-12018: following error encountered during code generation for
"OWNER"."IB_CONT1"
ORA-00942: table or view does not exist

But when i query the table i displays data.

SQL> select count(*) from admin.contact@ib_dblink;

  COUNT(*)
----------
      100

what could be the reason?

Any help will be highly appreciated.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2008

Added on Mar 3 2008

1 comment

252 views