Ramon, have you checked for outstanding locks?
Lisa Koivu
Oracle Datasnore Administrator
Fairfield Resorts, Inc.
954-935-4117
-----Original Message-----
From: Ramon Estevez [SMTP:[EMAIL PROTECTED]]
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
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Dominican Republic
809-565-3121
�
