DATA_LENGTH reports the maximum length that a column can have (e.g. VARCHAR columns), it does not show the actual size of the data but we can put unlimited number of rows in a table
To get a row size you can analyze tables and get the average row size from user_tables column: AVG_ROW_LEN
There is no specific LIMIT on how long the row can be in an Oracle table however there is a limit on number of columns.
| Oracle RDBMS release | MAX. no of columns/tables |
| 7 8 9 10 | 254 1000 1000 1000 |
0 comments:
Post a Comment