Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> can't use "select * from <table_name>" command

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US