Listing of tables with schema

[Norse]

Hello experts !

I am unknown about some rich and unique concept of oracle database.My question is that can I view my tables with respective owner or from which schema it belong to.Can I find out this term.If you have any idea about this concept then please tell me how it would be possible to see my changes in schema.

Thanks

[Reegan]

Listing of tables with schema :

You can view list of the tables which is used in the schema with the respective name. The oracle database provide some view which is created from the base table of database dictionary.

One of the table that you can refer to view the list of tables and their respective schema named "ALL_TABLES".

[opaper]

ALL_TABLES in oracle :

The ALL_TABLES provide you the information regarding the owner and tablespace and many more according to number of columns exist in the table.

When you fire the description command on this table you get so many columns which is produces very useful information about database tables from every schema