??? object visibility
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: [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).
Re: ??? object visibility
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: [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). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]
Re: ??? object visibility
Actually thinking about it, I should have said ... "The table name that the synonym (or view) is referencing is probably not called associate or is not in your current schema, hence the non-existence error..." Glen Mitchell wrote: 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: [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). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED] -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: [EMAIL PROTECTED]