From com.banilejas@codetel.net.do Thu, 18 Oct 2001 06:02:22 -0700
From: "Ramon Estevez" <com.banilejas@codetel.net.do>
Date: Thu, 18 Oct 2001 06:02:22 -0700
Subject: RE: Extrange behavior
Message-ID: <F001.003AE89F.20011018060024@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain




  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@codetel.net.do
  Dominican Republic
  809-565-3121