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.
If you have access to the data dictionary view.
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 privilege or the role (either of which would allow you to query any data dictionary table).
Of course, you may want to exclude certain schemas like and which have large numbers of Oracle tables that you probably don't care about.
2. Alternatively, if you do not have access to , you can see all the tables that your account has access to through the view
Although that may be a subset of the tables available in the database ( shows you the information for all the tables that your user has been granted access to).
What Are The Different Types Of CryptoCurrency? 45+ Crypto Sectors Explained! Part 1
If you are only concerned with the tables that you own, not those that you have access to, you could use
Since only has information about the tables that you own, it does not have an column-- the owner, by definition, is you.
Oracle also has a number of legacy data dictionary views-- , , , and 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 and views both show information about tables that are in the user's recycle bin while the views all filter those out. also shows information about materialized view logs with a of "TABLE" which is unlikely to be what you really want.
combines tables and synonyms and doesn't tell you who owns the object.