Check if any policy is defined against the table.
rgds
amar
-----Original Message-----
From: Ramon Estevez [mailto:[EMAIL PROTECTED]]
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
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
809-565-3121
-----Mensaje original-----
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 <[EMAIL PROTECTED]> 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
> [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
