| List of tables [message #103187] |
Thu, 27 February 2003 10:06  |
sandeep
Messages: 110
Registered: October 2000
|
Senior Member |
|
|
How can I find out a list of tables which I do not own. This DB was created by someone else and all I have is the username, pw and db name. Is there a way to find out the list of tables.
I tried select * from tab, 0 rows selected. I do not have admin access to the DB. I know there are tables cause I know the name of one table and when I do a describe on it, I get results back, but select * from tab does not. If anyone knows please let me know.
Sandeep.
|
|
|
|
| Re: List of tables [message #103188 is a reply to message #103187] |
Thu, 27 February 2003 10:39  |
sandeep
Messages: 110
Registered: October 2000
|
Senior Member |
|
|
I think I answered my own question.
Select * from all_tables
If you want the list of views, then select * from all_views.
Please feel free to correct me if I am wrong and keep in mind this is for a uers without DBA access to the table.
Sandeep.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
