RE: Can't update table

Dear

If U can drop the table and recreate ! (Very crude method NT needs)

Rao

--

On Fri, 01 Dec 2000 10:27:26  
 Hannah.M.Doran wrote:


>

>

>Hi,

>

>     Think I wrote this before, but check out your temp tablespace too.  I had a

>similar problem (but doing mass updates), and it turned out, it was using some

>temp space.

>

>

>

>

>

>

>Chuck Hamilton <chuck_hamilton_at_yahoo.com> on 12/01/2000 11:18:38 AM

>

>Please respond to ORACLE-L_at_fatcity.com

>

>To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

>cc:

>

>

>

>

>

>I can think of two things off the top of my head. If there are a lot of people

>trying to update the table simultaneously you could be getting freelist

>contention. The solution would be to create addtitional freelists. Another

>thought is that if you've only got one rollback segment online you could be

>getting contention for the transaction table in the rollback segment. Solution

>here is to bring more rollback segments online.

>

>

>  "Bond, Mike" <CEMAB_at_cews.okc.disa.mil> wrote:

>

>

>yes.

>

>I noticed that this table was the only one with 'CACHE' turned on so I

>turned it off. Now I am able to update a row, but there is such a

>perfomance problem that to update 1000 rows will take an hour.

>

>There were no locks, no dba_waits or dba_blockers entries.

>

>I bounced the db and nothing has changed.

>

>Selects work fine.

>

>I'm now looking at performance issues specific to this table.

>

>thanks,

>

>mike

>

>

>

>-----Original Message-----

>Sent: Wednesday, November 29, 2000 1:41 PM

>To: Multiple recipients of list ORACLE-L

>

>

>Is the UPDATE privilege for "BOB's" table given to the person trying to

>update the table???

>

>ROR ma?am

>

>>>> 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'.

>

>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.

>

>No errors are returned and no alert log entries are generated. SQL PLus

>simply hangs.

>

>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

>--

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>--

>Author: Bond, Mike

>INET: CEMAB_at_cews.okc.disa.mil

>

>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).

>--

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>--

>Author: Jeffery Stevenson

>INET: jeff_at_mpv.com

>

>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).

>

>--

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>--

>Author: Ron Rogers

>INET: RROGERS_at_galottery.org

>

>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).

>--

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>--

>Author: Bond, Mike

>INET: CEMAB_at_cews.okc.disa.mil

>

>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).

>

>

>---------------------------------