I created some materialized views and Oracle SQL Developer puts a little red 'x' next to each of them. At the moment they are returning the correct information when I query them and running the following query in SQL Plus suggests that there are no errors:

```
SELECT * FROM USER_SNAPSHOTS

```

The `ERROR` column in this returns 0 for the materialized views in question.

Does anyone know why SQL Developer thinks there is an error? Is there anywhere else I can check?

UPDATE
======

Taking Patrick's advice I ran the following query:

```
SELECT * FROM ALL_MVIEWS

```

The COMPILE\_STATE is 'NEEDS\_COMPILE' for each view in question. What does this mean? Why would it need to be recompiled? None of the underlying tables have been changed.