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.
<SPAN
class=626005813-19102001>
This is
another IOT table.
In this one
I can make an update, this is the detail table of the previous one,
ACT
<SPAN
class=626005813-19102001>
<SPAN
class=626005813-19102001>
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> /
<SPAN
class=626005813-19102001>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
<SPAN
class=626005813-19102001>
ORA-02292: integrity constraint
(RAMON.DAT_ACT_ACTIVOS_FK) violated - child record found
<SPAN
class=626005813-19102001>****
In SqlPlus
the session hangs.
<SPAN
class=626005813-19102001>
<SPAN
class=626005813-19102001>
And I dont
see any errors in the trace file.
<SPAN
class=626005813-19102001>
Ramon E.
Estevez
<A
href="">com.banilejas_at_codetel.net.do
Dominican Republic
809-565-3121
<FONT face=Tahoma
size=2>-----Mensaje original-----De: root_at_fatcity.com
[mailto:root_at_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 [<A
href="">mailto:com.banilejas_at_codetel.net.do]
Sent: Thursday, October 18, 2001 8:09 PM <FONT
size=2>To: Multiple recipients of list ORACLE-L <FONT
size=2>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
<FONT
size=2>OWNER
OBJECT_NAME
OBJECT_TYPE ------------------------------
------------------------------ -------------- <FONT
size=2>---- <FONT
size=2>PUBLIC
ACT
SYNONYM <FONT
size=2>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 <FONT
size=2>hangs.
Is an IOT table.
Thanks,
Ramon E. Estevez <FONT
size=2>com.banilejas_at_codetel.net.do <<A
href="">mailto:com.banilejas_at_codetel.net.do>
809-565-3121
-----Mensaje original----- De:
root_at_fatcity.com [<A
href="">mailto:root_at_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 <com.banilejas_at_codetel.net.do>
wrote: > Hi List, <FONT
size=2>> > 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. <FONT
size=2>> > 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; > <FONT
size=2>> COUNT(*) > ---------
> 3320 <FONT
size=2>> > SELECT IOT_TYPE, IOT_NAME,
TABLESPACE_NAME > FROM USER_TABLES <FONT
size=2>> WHERE > TABLE_NAME = 'ACTS'
> > <FONT
size=2>> SQL> / > <FONT
size=2>> IOT_TYPE
IOT_NAME
TABLESPACE_NAME > ------------
- >
- > IOT
> > <FONT
size=2>> *-----* It hangs > UPDATE ACTS
> SET SERIE = SERIE||'---' <FONT
size=2>> WHERE > GR = 01 AND
> CO = 01 AND <FONT
size=2>> CAT = 10 AND >
LOC = 01 AND > ACT= 01 <FONT
size=2>> *-----* It hangs > <FONT
size=2>> > 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 > <FONT
size=2>> Ramon E. Estevez >
com.banilejas_at_codetel.net.do > Dominican
Republic > 809-565-3121 <FONT
size=2>> > >
Do You Yahoo!? Make a great
connection at Yahoo! Personals. <A
href=""
target=_blank>
http://personals.yahoo.com --
Please see the official ORACLE-L FAQ: <A
href="" target=_blank>
http://www.orafaq.com
- Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051 San Diego,
California -- Public Internet access
/ Mailing Lists <FONT
size=2>--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message to: ListGuru_at_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: <A href=""
target=_blank>http://www.orafaq.com --
Author: Ramon Estevez
INET: com.banilejas_at_codetel.net.do
Fat City Network Services -- (858)
538-5051 FAX: (858) 538-5051 San Diego,
California -- Public Internet access
/ Mailing Lists <FONT
size=2>--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message to: ListGuru_at_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).
Received on Fri Oct 19 2001 - 08:55:29 CDT