OraFAQ Forum: Server Administration » maximum rows in a table- oracle 8.1.7

Home » RDBMS Server » Server Administration » maximum rows in a table- oracle 8.1.7

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

maximum rows in a table- oracle 8.1.7 [message #55853]

Thu, 20 February 2003 04:00

anitha
Messages: 1
Registered: February 2003

Junior Member

Hi,
I want to know what is the maximum number of rows that a table can have ?
My application needs around 150 million records. What is the database setup needed for such a requirement ?
Please help. Thanks in advance.

-Anitha

Report message to a moderator

Re: maximum rows in a table- oracle 8.1.7 [message #55872 is a reply to message #55853]

Fri, 21 February 2003 00:25

Maaher
Messages: 7065
Registered: December 2001

Senior Member

In fact, there's no limit to this from the Oracle point of view. I think the first limit you might encounter is the physical limits of the server(s).

Oracle8i Reference Manual

HTH,
MHE

Report message to a moderator

Re: maximum rows in a table- oracle 8.1.7 [message #55875 is a reply to message #55853]

Fri, 21 February 2003 06:27

Mike
Messages: 417
Registered: September 1998

Senior Member

If you are working with big tables have a look at table partitioning. Depending on how you access your data this may imporve a lot your performance.

Mike

Report message to a moderator

Previous Topic:	Re: system doesn't use udump directory
Next Topic:	OEM Console HELP!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 14 07:02:49 CST 2025