How Oracle Disable NOT NULL Constraint
After you add a NOT NULL constraint to a column, you might want it stop temporarily. In such moment, you should consider to disable NOT… Read More »How Oracle Disable NOT NULL Constraint
Table
How Oracle Add NOT NULL Constraint
Add NOT NULL Constraint As I mentioned in resolving ORA-00904 for adding a constraint, NOT NULL is a constraint, but it's more like an attribute… Read More »How Oracle Add NOT NULL Constraint
How Oracle Remove NOT NULL Constraint
Before we talk about how to remove NOT NULL constraint, I assume that you have already know how to add a NOT NULL constraint to… Read More »How Oracle Remove NOT NULL Constraint
How to Resolve ORA-12899: value too large for column
ORA-12899 ORA-12899 means that the value of being inserted or updated data is larger than column's allowable length that is defined in the table. What… Read More »How to Resolve ORA-12899: value too large for column
How Max a Table Can Be
Maximum Size Limit of a Table According to Oracle Logical Database Limits, tables can have at most 1000 columns and no limit on rows and… Read More »How Max a Table Can Be
How to Check Oracle Table Size
The size of an Oracle table can be calculated by different ways. In this post, I will introduce 3 approaches, theoretical table sizing, logical table… Read More »How to Check Oracle Table Size
How to Resolve ORA-00903: invalid table name
ORA-00903 In this post, I will introduce 3 main error patterns about ORA-00903, they are: Create Table Select Table Insert, Update and Delete Table Alter… Read More »How to Resolve ORA-00903: invalid table name
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
Oracle Find LOB Segment Table
Sometimes, you may see segment type like LOBSEGMENT in the top 10 segments list. They are Large Object (LOB) which may be Binary Large Object… Read More »Oracle Find LOB Segment Table
How to Find Biggest Tables in Oracle
Top 10 Biggest Tables in Whole Database When the disk space is running out, you might want to calculate Oracle table size and list the… Read More »How to Find Biggest Tables in Oracle