How to get a list of all tables in Oracle database?

Three ways to get a list of all tables in Oracle Database with code examples
Sergey Siminskiy's picture
Sergey Siminskiy
10 August

We have made a research and found out how to display the names of all tables in Oracle Database. There are 3 ways to do it.

1. If you have access to the DBA_TABLES data dictionary view.

SELECT owner, table_name
  FROM dba_tables

If you do not have those privileges but need them, you can request that the DBA explicitly grants you privileges on that table or that the DBA grants you the SELECT ANY DICTIONARY privilege or the SELECT_CATALOG_ROLE role (either of which would allow you to query any data dictionary table). Of course, you may want to exclude certain schemas like SYS and SYSTEM which have large numbers of Oracle tables that you probably don't care about.

2. Alternatively, if you do not have access to DBA_TABLES, you can see all the tables that your account has access to through the ALL_TABLES view

SELECT owner, table_name
  FROM all_tables

Although that may be a subset of the tables available in the database (ALL_TABLES shows you the information for all the tables that your user has been granted access to).

3. If you are only concerned with the tables that you own, not those that you have access to, you could use USER_TABLES

SELECT table_name FROM user_tables

Since USER_TABLES only has information about the tables that you own, it does not have an OWNER column-- the owner, by definition, is you.

Oracle also has a number of legacy data dictionary views-- TABDICTTABS, and CAT for example-- that could be used. In general, I would not suggest using these legacy views unless you absolutely need to backport your scripts to Oracle 6. Oracle has not changed these views in a long time so they often have problems with newer types of objects. For example, the TAB and CAT views both show information about tables that are in the user's recycle bin while the [DBA|ALL|USER]_TABLES views all filter those out. CAT also shows information about materialized view logs with a TABLE_TYPE of "TABLE" which is unlikely to be what you really want. DICT combines tables and synonyms and doesn't tell you who owns the object.

Oracle will help six start-ups

Start-ups will receive first-class support and individual features
Sergey Siminskiy's picture
Sergey Siminskiy
17 July
Oracle Database

Object-relational database management system produced and marketed by Oracle Corporation.

Recently, Oracle named the first six startups selected for its Paris-based Oracle Startup Cloud Accelerator program. Oracle launched its first accelerator in Bangalore, India, in April 2016 and has now expanded to seven additional accelerators in other parts of the world. This is reported by the Oracle Blog. 

This startup accelerators offer companies access to financial and other resources they wouldn’t otherwise have, while exposing the new companies to the startups’ innovative thinking and energy.

Nowadays, Oracle Startup Cloud Accelerator has a new form: it provides young companies with personalized technical and business mentoring, free access to a range of Oracle Cloud services and helps them to create commercial relationships with Oracle’s large enterprise customers.

We’re trying to develop sustained relationships with startups to give them something that is in line with the specific point in their history.

Dominique van Deth
Accelerator program director, Oracle Startup Cloud Accelerator for France

Oracle provides start-ups with two full-time specialists - technical “mentor in residence” and a program lead who can provide business counsel. These two professionals provide companies with individual, first-class support. 

Paris accelerator focuses on companies already generating $100,000 in monthly recurring revenue. Oracle Startup Cloud Accelerator is adjusted on a market-by-market basis.

"Old" start-ups, for example, Dial-Once, one of the six companies accepted into the Paris program, face a very different set of problems, such as selling into larger businesses or growing internationally. 

Oracle’s vast global resources, technologies, and support ecosystem will be a boost and position us to continue to scale our solution globally.

Charles Dunston
CEO, Dial-Once

The other five startups accepted into the Paris-based accelerator are:

  • 1Check, which digitizes processes for hotels, campsites, resorts, nursing homes, apartment buildings, and school campuses
  • OuiTeam, which helps companies improve workforce efficiency by optimizing internal staff transfers from one site to another
  • Shippeo, whose mobile application helps shippers and freight forwarders monitor their supply chains in real time.
  • Tilkee, whose lead-conversion application, used in email campaigns, helps marketers close deals by analyzing prospects’ reading behaviors to score their interest and prioritize follow-ups.
  • Weblib, whose in-store Wi-Fi and tablet software help retailers and restaurants boost revenue, improve traffic, and build customer loyalty.

Oracle received hundreds of applications, each of which was scored by seven judges criteria. So, as a result, Oracle then conducted follow-up interviews via videoconference, further winnowing the applicant pool to 32 companies.

Participants received access to:

  • coworking space 
  • mentoring 
  • a tailored curriculum 
  • peer-to-peer interaction with Oracle employees worldwide 
  • free Oracle Cloud services
  • go-to-market education from Oracle and industry executives

In addition the accelerator program illustrates that Oracle can be a strong business and technology partner to companies of all sizes.