RE: Extrange behavior

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Thu, 18 Oct 2001 08:53:26 -0700
Message-ID: <F001.003AEDE7.20011018084554@fatcity.com>

Check if any policy is defined against the table.

rgds
amar

-----Original Message-----
From: Ramon Estevez [mailto:com.banilejas_at_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_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do> 809-565-3121

-----Mensaje original-----
De: root_at_fatcity.com [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

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,
>
> 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
> 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_at_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_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: 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
--------------------------------------------------------------------
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 Thu Oct 18 2001 - 10:53:26 CDT