can't use "select * from <table_name>" command

From: Shwe Yee Than <shweyeesyt_at_yahoo.com>
Date: Mon, 5 Nov 2007 20:51:37 -0800 (PST)
Message-ID: <929408.35307.qm@web33202.mail.mud.yahoo.com>

Hi,  

 I managed to see all the tables in a database by using the following commands:  

 ALL_ALL_TABLES;
 DBA_ALL_TABLES;
 USER_ALL_TABLES;    But I can't use "Select * from <table_name>;" command to view the contents of the tables except the tables listed by "USER_ALL_TABLES".  

 I'm not able to view the contents of the tables listed by "ALL_ALL_TABLES" and "DBA_ALL_TABLES".  

 What should I do?? Anyone can help me??  Thanks.  

 Regards,
 Shwe  

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 05 2007 - 22:51:37 CST