Information of ORACLE Database

1. A table can have up to 1,000 columns,Tables are most efficient

with far fewer than 1,000 columns.

2. A table can have a virtually unlimited number of rows. Although you will hit other limits that prevent this from happening. For example, a tablespace can have at most
1,022 files typically. Say you have 32 GB files, that is to say 32,704 GB per tablespace.
This would be 2,143,289,344 blocks, each of which are 16 KB in size. You might be able to fit 160 rows of between 80 to 100 bytes per block. This would give you
342,926,295,040 rows. If we partition the table though, we can easily multiply this by ten times or more. There are limits, but you?ll hit other practical limitations
before even coming close to these figures.
3. A table can have as many indexes as there are permutations of columns, taken 32 at a time (and permutations of functions on those columns), although once again
practical restrictions will limit the actual number of indexes you will create and maintain.
4. There is no limit to the number of tables you may have. Yet again, practical limits will keep this number within reasonable bounds. You will not have millions of
tables (impracticable to create and manage), but thousands of tables, yes.