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