From com.banilejas@codetel.net.do Fri, 19 Oct 2001 06:55:29 -0700 From: "Ramon Estevez" Date: Fri, 19 Oct 2001 06:55:29 -0700 Subject: RE: Extrange behavior Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Extrange behavior The application has more than 1 year working properly, this happen when I migrated from 8.0.5 to 8.1.7.0.0 a month ago, repeat, the users can insert data, make reports, etc, but cant make update of the data.   This is another IOT table. In this one I can make an update, this is the detail table of the previous one, ACT     SQL> EDWrote file afiedt.buf     1  select tablespace_name, IOT_NAME, iot_type  2  from user_tables  3  where  4* table_name = 'DAT_ACTS'SQL> /   TABLESPACE_NAME                IOT_NAME                IOT_TYPE------------------------------ ------------------------------ ------------                                                                         IOT This is the error thru the forms, it is a master/detail form and I am trying to modify a field on the master record   ORA-02292: integrity constraint (RAMON.DAT_ACT_ACTIVOS_FK) violated - child record found   **** In SqlPlus the session hangs.     And I dont see any errors in the trace file.     Ramon E. Estevez com.banilejas@codetel.net.do Dominican Republic 809-565-3121 -----Mensaje original-----De: root@fatcity.com [mailto:root@fatcity.com]En nombre de Amar Kumar PadhiEnviado el: Thursday, 18 October, 2001 11:46 AMPara: Multiple recipients of list ORACLE-LAsunto: RE: Extrange behavior Check if any policy is defined against the table. rgds amar -----Original Message----- From: Ramon Estevez [mailto:com.banilejas@codetel.net.do] Sent: Thursday, October 18, 2001 8:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Extrange behavior Hi Rachel, This is the user owner of the object and has DBA privilege. I made the select and this is the result OWNER                          OBJECT_NAME                    OBJECT_TYPE ------------------------------ ------------------------------ -------------- ---- PUBLIC                         ACT                            SYNONYM RAMON                          ACT                            TABLE SQL> ED Wrote file afiedt.buf   1  select Segment_name, tablespace_name from dba_segments   2* where segment_name ='ACTS' SQL> / no rows selected The users can see data, make reports of it, but cant update it.  I am logged as the user owner of the table and either can't make the update, the session hangs. Is an IOT table. Thanks, Ramon E. Estevez com.banilejas@codetel.net.do <mailto:com.banilejas@codetel.net.do> 809-565-3121 -----Mensaje original----- De: root@fatcity.com [mailto:root@fatcity.com]En nombre de Rachel Carmichael Enviado el: Thursday, 18 October, 2001 10:22 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: Extrange behavior Log in as SYSTEM (or any other DBA account you have) and do select owner, object_name, object_type from dba_objects where object_name = 'ACTS'; it's possible that the user you log into is looking at a synonym, and has not been granted update by the true owner. Also, under a DBA account, you should be able to tell what tablespace it's in. select segment_owner, segment_name, tablespace_name from dba_segments where segment_name ='ACTS'; --- Ramon Estevez wrote: > 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@codetel.net.do > Dominican Republic > 809-565-3121 > > > __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael   INET: wisernet100@yahoo.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@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: Ramon Estevez   INET: com.banilejas@codetel.net.do 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@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).