Re: ora-01001 when creating a simple snapshot

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 10 Feb 2002 10:51:18 +0100
Message-ID: <u6cmm0ephodo28@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

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Sun Feb 10 2002 - 03:51:18 CST