# Determining which tables are available (oracle)

**URL:** <https://www.ruby-forum.com/t/determining-which-tables-are-available-oracle/171748>\
**Category:** Rails\
**Created:** [July 8, 2009, 4:24pm UTC](https://www.ruby-forum.com/t/determining-which-tables-are-available-oracle/171748 "2009-07-08T16:24:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrodgers](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/6a8cbe/32.png) [@mrodgers](https://www.ruby-forum.com/u/mrodgers)\
**Post date:** [July 8, 2009, 4:24pm UTC](https://www.ruby-forum.com/t/determining-which-tables-are-available-oracle/171748/1 "2009-07-08T16:24:36Z")

</div>

I am trying to connect to an oracle database using the OCI8 tools and  
everything appears to be working fine (rake db:migrate pulls no  
errors). The only issue is, I’m not sure how to determine which tables  
are available. I know the table names for running queries, but they do  
not appear in the localhost.

e.g. select \* from [tablename] would return results in Oracle, but  
[http://localhost:3000/[tablename]](http://localhost:3000/%5Btablename%5D) can not be found. Is there a way to  
determine how to properly display the table names?

If I am trying to reference a table that already exists in my  
database.yml file, will rake db:migrate pull in the data that is  
already there?

Thanks