RE: Extrange behavior

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Thu, 18 Oct 2001 06:51:14 -0700
Message-ID: <F001.003AEA29.20011018065021@fatcity.com>

Ramon, have you checked for outstanding locks?

Lisa Koivu
Oracle Datasnore Administrator
Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----

From:   Ramon Estevez [SMTP:com.banilejas_at_codetel.net.do]
Sent:   Thursday, October 18, 2001 10:00 AM
To:     Multiple recipients of list ORACLE-L

Subject:        RE: Extrange behavior

Hi List,
 

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.
 

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.

 

SQL> SELECT COUNT(*) FROM ACTS;
 
 COUNT(*)

---

     3320
 

SELECT IOT_TYPE, IOT_NAME, TABLESPACE_NAME FROM USER_TABLES
WHERE
TABLE_NAME = 'ACTS'
 
 

SQL> /
 

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
 
 

select index_name, INDEX_TYPE, TABLESPACE_NAME from user_indexes where
table_name = 'ACTS'
 

INDEX_NAME             INDEX_TYPE              TABLESPACE_NAME

------------------------- --------------------------- --------------------
ACTS_PK                  IOT - TOP                   CONT

 
 

I can see all the records, insert records, but cant update.
 

Scenario 8.1.7 Windows 2000
 

Any suggestions will be apreciated
 

Thanks
 

Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do> Dominican Republic
809-565-3121
 
Received on Thu Oct 18 2001 - 08:51:14 CDT