How to Check Schema Size in Oracle
Schema Size Calculation After knowing the whole database size, we may drill down a little bit to calculate schema size for every user in database.… Read More »How to Check Schema Size in Oracle
Schema Objects
Segments vs Schema Objects
Segments vs Schema Objects Not only showing all tables in Oracle, for better understanding the nature of table, you also need to know the definitions… Read More »Segments vs Schema Objects
How to Resolve ORA-00942: table or view does not exist
ORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »How to Resolve ORA-00942: table or view does not exist
How Many Schema Object Types Can You Have
It seems that Oracle does not list all the schema object types exhaustively in the documentation: Schema Object Types So, if you'd like to know… Read More »How Many Schema Object Types Can You Have