Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    2

    Exclamation Unanswered: Materialized view hangs

    I have a schema in which I have a table ALIGNMENT and a snapshot log:

    CREATE MATERIALIZED VIEW LOG ON ALIGNMENT WITH PRIMARY KEY;

    Materialized view log created.

    Then, in another schema, I try to create the snapshot:

    CREATE MATERIALIZED VIEW ALIGNMENT BUILD IMMEDIATE REFRESH FAST AS SELECT * FROM ALIGNMENT@SYNCH;

    and it hangs (I left it overnight). So, I guess this points to a lock issue, but I didn't see anything in DBA_LOCK referencing either of my schemas. Any idea what I should look at next?

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    Your Alertlog

    I'd start with looking at the alertlogs (but at the site your building and the originating site)

    Good luck!
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

Posting Permissions

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