ora-01001 when creating a simple snapshot

Hi, all,

I have an ora-01001 error when trying to create a simple snapshot.

For example:
Create Snapshot
...

as
select * from table_A_at_dblink;

Then oracle gives out the ora-01001: invalid cursor.

However, if I change it to:
Create Snapshot
...

as
select * from table_A_at_dblink where rownum < 9999999;

Then it works.

I have no idea what went wrong.

BTW, I have already increased the shared_pool_size and open_cursors(from 50 to 200). But it still doesn't work.

Any suggestion is appreciated.

Thanks in advance.

From: Pat Received on Sat Feb 09 2002 - 19:27:22 CST