Alter Table Read Only Examples
ALTER TABLE READ ONLY If you just want NO data of the table can be modified permanently or temporarily, you may change the attribute of… Read More »Alter Table Read Only Examples
ALL_TABLES
How to Resolve ORA-00980: synonym translation is no longer valid
ORA-00980 We usually use synonyms to point to a base object that we don't own it. Let's see a case. SQL> conn oe/oe@orclpdb1 Connected. SQL>… Read More »How to Resolve ORA-00980: synonym translation is no longer valid
How to Check Oracle Table Creation Date
We usually retrieve table information from ALL_TABLES, but it has no table creation date. This is because table is also an object type, so we… Read More »How to Check Oracle Table Creation Date
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 to List All Tables in Oracle
In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Tables that You Own… Read More »How to List All Tables in Oracle