Oracle Table size

pms_reddy1
pms_reddy1 used Ask the Experts™
on
Hi,

In Oracle10g database is there any limit for the number of records in a table?
or
Table size limit?
If so,what is the limit?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
johnsoneSenior Oracle DBA
Commented:
There is no limit on the number of rows.  The limits are on total size of the table.

They are detailed here:

http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits002.htm#i287915

A table can get pretty big before it hits any of the limits.
Commented:
unlimited number of records which are limited by the size of disk space.

Author

Commented:
Hi jonsone,

The link provided by you is not giving any details about the table size,
johnsoneSenior Oracle DBA

Commented:
Correct.  The size of the table is limited by the limits on that page.  Basically, the number of blocks per file, and the number of files per tablespace.  Those are the only things that are going to limit the size of a table.

Be sure to read the notes on that page, as there are OS restrictions noted that may be smaller than the restrictions that Oracle imposes.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial