question about sequences.

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 5 Mar 2003 11:11:25 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70361C607@lnewton.leeds.lfs.co.uk>

Just checked under 920, insert into dual fails with 'insuffient privs'. That should sort things out !

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Pete Sharman [mailto:peter.sharman_at_oracle.com] Posted At: Wednesday, March 05, 2003 5:21 AM Posted To: server
Conversation: question about sequences.
Subject: Re: question about sequences.

<SNIP>

In later editions, we put the smarts into the kernel to ensure you CAN'T screw
up like this, so it must have happened fairly frequently. :) Now I think you
can do inserts, deletes and all sorts of things, get no errors, but still only
end up with one row in DUAL, becaue it's no longer really a table (IMSMC it's a
synonym on X$DUAL?) Received on Wed Mar 05 2003 - 05:11:25 CST