RE: Can't update table

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 29 Nov 2000 14:36:04 -0500
Message-Id: <10695.123241@fatcity.com>

Is the UPDATE privilege for "BOB's" table given to the person trying to = update the table???

ROR m=AA=BF=AAm

>>> jeff_at_mpv.com 11/29/00 02:01PM >>>

Sounds like it might be a locking issue...check to see if anyone else has that table/row locked. (v$locked_object, v$lock, etc.).

Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
Sent: Wednesday, November 29, 2000 10:31 AM To: Multiple recipients of list ORACLE-L

Hi,

I am having a problem updating a table. Using 8.1.6.1 on NT.

I can update other tables owned by user 'BOB'. =20

All tables were created via IMPORT. Table X 'should' be the same as the rest.

But no one can update table X, owned by BOB. =20

No errors are returned and no alert log entries are generated. SQL PLus simply hangs. =20

It doesn't matter if it is 1 record to be updated or 30,000, the same = result
- nothing.

BOB can select from this and other tables just fine.

BOB can update other tables just fine.

Ideas?

Thanks,

Mike
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Bond, Mike
  INET: CEMAB_at_cews.okc.disa.mil=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Jeffery Stevenson
  INET: jeff_at_mpv.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Nov 29 2000 - 13:36:04 CST