RE: Extrange behavior

From: Ramon Estevez <com.banilejas_at_codetel.net.do>
Date: Thu, 18 Oct 2001 06:02:22 -0700
Message-ID: <F001.003AE89F.20011018060024@fatcity.com>

  Hi
  List,
<SPAN

  class=890035815-17102001> 
  I have a strange
  problem, I have a table and I can see the data of it, but can't update the   records of it.
<SPAN

  class=890035815-17102001> 
  In forms it gives me an
  error and in SQL plus the process hang, the table is IOT, and either can't see   in what tablespace the table is.
<SPAN

  class=890035815-17102001> 
  SQL> SELECT COUNT(*)
  FROM ACTS;
   
<SPAN

  class=890035815-17102001> COUNT(*)---------       3320
<SPAN

  class=890035815-17102001> 
  SELECT IOT_TYPE,
  IOT_NAME, TABLESPACE_NAMEFROM USER_TABLESWHERETABLE_NAME =   'ACTS'
<SPAN

  class=890035815-17102001> 
<SPAN

  class=890035815-17102001> 
  SQL>
  /
   
<SPAN

  class=890035815-17102001>IOT_TYPE    

  IOT_NAME                       
  TABLESPACE_NAME------------ ------------------------------ 
  ------------------------------IOT
  

  *-----* It
  hangs
  UPDATE ACTS 
  SET SERIE = SERIE||'---'WHERE  GR = 01 AND  CO = 01   AND  CAT = 10 AND  LOC = 01 AND  ACT=   01
  *-----* It
  hangs
<SPAN

  class=890035815-17102001> 
<SPAN

  class=890035815-17102001> 
  select index_name,
  INDEX_TYPE, TABLESPACE_NAME from user_indexeswheretable_name =   'ACTS'
<SPAN

  class=890035815-17102001> 
<SPAN

  class=890035815-17102001>INDEX_NAME             INDEX_TYPE              
  TABLESPACE_NAME------------------------- --------------------------- 
  --------------------ACTS_PK                  

  IOT -

  TOP                   CONT

<SPAN

  class=890035815-17102001> 
<SPAN

  class=890035815-17102001> 
  I can see all the
  records, insert records, but cant update.
<SPAN

  class=890035815-17102001> 
  Scenario 8.1.7 Windows
  2000
<SPAN

  class=890035815-17102001> 
  Any suggestions will be
  apreciated
<SPAN

  class=890035815-17102001> 
<SPAN

  class=890035815-17102001>Thanks
   
  Ramon E.
  Estevez
<A

  href="">com.banilejas_at_codetel.net.do
  Dominican Republic
  809-565-3121
    Received on Thu Oct 18 2001 - 08:02:22 CDT