Re: ora-01001 when creating a simple snapshot

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<u6cmm0ephodo28_at_corp.supernews.com>...
> "s pat" <szeshanpat_at_yahoo.com> wrote in message
> news:16e3b656.0202091730.7abccbc8_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
>
>
> Invalid cursor usually means
> - your statement didn't parse
> - you didn't trap the error
> - Oracle tries to open the cursor but can't
> It has nothing to do with the number of cursors nor with the
> shared_pool_size
> As you obviously didn't post the exact statement and also didn't include
> platform and version (most people here seem to think they don't need to do
> that) it is very difficult to help you out.
>
> Regards

Hi, Bakker,

Thanks for the advice.

I am running Oracle Enterprise Edition 8.0.5 on NT 4.00.1381.

Any idea?

From: Pat Received on Mon Feb 11 2002 - 08:43:13 CST