Re: ??? object visibility

From: Glen Mitchell <glen.mitchell_at_peace.com>
Date: Tue, 08 May 2001 18:20:06 -0700
Message-ID: <F001.002FD568.20010508181029@fatcity.com>

My guess would be that you are actually looking at a synonym (or view) called associate.
The table name that the synonym (or view) is referencing is probably not called associate, hence the non-existence error when trying to truncate the table called associate.  Run the following query to verify ... select synonym_name, table_name from user_synonyms where synonym_name like 'ASSOCIATE';
Glen
Janet Linsy wrote:
Hi all,
I got a table, when I do desc, delete, it works, but when I do truncate, I got error "table or view does not exist".  Any idea?
SQL> desc associate --> can see the table SQL> select count(*) from associate;  --> works          1
SQL> truncate table associate; --> got error below truncate table associate
              
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> SQL> delete associate;  --> works
SQL>
Thanks
Janet

---

Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Janet Linsy
  INET: janetlinsy_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).

-- 

Glen Mitchell                   NZ Phone: +64 9 3730400

Energy Research Lab             URL: http://www.peace.com

Peace Software                  Email: glen.mitchell_at_peace.com

  Received on Tue May 08 2001 - 20:20:06 CDT