Table

How Big a Table Can Be

Posted on
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 space, so theoretically, there’s no space limit on a table. But not so fast, we should consider other factors. Since one ordinary table can only be stored in one tablespace, […]
Table

How to Check Oracle Table Size

Posted on
Although we have listed the top 10 biggest tables in our Oracle database, we also can check single table size by similar ways. Theoretical Table Size We used NUM_ROWS and AVG_ROW_LEN (in byte) in DBA_TABLES to calculate how many bytes that active rows of the table are used. The result can not be very accurate […]
SQL

How to Resolve ORA-00903: invalid table name

Posted on
In this post, I will introduce 3 main error patterns about ORA-00903, they are: Violating Naming Rules Missing Quotes Incorrect Syntax ORA-00903 due to Violating Naming Rules Without complying with database object naming rules, we can’t create a table with unusual strings in normal way. Let’s see some cases that throw ORA-00903. First of all, […]