RE: Extrange behavior

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Thu, 18 Oct 2001 07:13:40 -0700
Message-ID: <F001.003AEAC2.20011018072229@fatcity.com>

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).

Received on Thu Oct 18 2001 - 09:13:40 CDT