RE: Extrange behavior

From: Ramon Estevez <com.banilejas_at_codetel.net.do>
Date: Thu, 18 Oct 2001 07:52:02 -0700
Message-ID: <F001.003AEC06.20011018080841@fatcity.com>

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 - 09:52:02 CDT