ora-01001 when creating snapshot
From: s pat <szeshanpat_at_yahoo.com>
Date: 9 Feb 2002 17:26:14 -0800
Message-ID: <16e3b656.0202091726.755d1b34_at_posting.google.com>
Date: 9 Feb 2002 17:26:14 -0800
Message-ID: <16e3b656.0202091726.755d1b34_at_posting.google.com>
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 Sun Feb 10 2002 - 02:26:14 CET