CODEWITHSUNDEEP
sqloracle-database
Brandon - Free Palestine
Brandon - Free Palestine

Reputation: 16676

Getting all tables from an oracle database

I'm trying to retrieve a list of tables from an Oracle connection. I'm not very familiar with Oracle terminology and thus, having hard time finding the information I need.

Right now I can use Microsoft Access to connect via ODBC and it pops up with a "Link Tables" dialog that lists all tables, not just the ones I "own". None of the queries I've tried so far, give me this data.

I'm trying "SELECT * FROM all_tables" but that doesn't show me the right data.

Upvotes: 1

Views: 17783

Answers (6)

Vasin Yuriy
Vasin Yuriy

Reputation: 535

SELECT owner, table_name
  FROM all_tables

Upvotes: 1

simplePerson43
simplePerson43

Reputation: 3873

SELECT * FROM TAB; that will show you all the table and views

Upvotes: 0

denied
denied

Reputation: 608

You can also try 

SELECT * FROM USER_TABLES

It will return list of tables owned by your user.

Upvotes: 0

hkutluay
hkutluay

Reputation: 6944

It can be.. (If user has dba role)

select * from dba_tables

Upvotes: 1

Justin Cave
Justin Cave

Reputation: 231801

ALL_TABLES will show you all the tables that you have access to SELECT from. DBA_TABLES will show you all the tables that exist in the database though you'll need an additional privilege grant to be able to query the DBA* data dictionary objects.

Upvotes: 3

DoctorMick
DoctorMick

Reputation: 6793

Try select * from all_tables, that should do what you want.

Upvotes: 1

Related Questions