Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle

Status
Not open for further replies.
pram

pram

Technical User
Jan 23, 2001
12
US
how much records i can store in oracle?
 
Sort by date Sort by votes
I have seen until 3.000.000 working properly,
but the theorical limit must be higher.
 
Upvote 0 Downvote
thanks
one of my friend said me its unlimited is it true?
 
Upvote 0 Downvote
Pretty much, Now that you can partion a table you can just keep adding partions so I don't think any O/S limits would apply. I've implemented a system with such a table, across all partions we had 11 million records it's probably more now...

your only limit is the amount of disk you have.
 
Upvote 0 Downvote
Pram:
I just found it.
The Oracle8i Datatbase has a limit of 512petabytes. You can create up to 64,000 partitions!

Ref: Oracle8 DBA Certification Exam Guide, Oracle Press/Osborne, J. Couchman, Chapter 28: Oracle8i Object Administration II
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
149
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
182
Andrzejek
Andrzejek
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
127
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
How to list all the CPU (EBS) patches applied - Oracle 11.2.0.4.
Replies
3
Views
123
Livia8
Livia8
Aung Thurein Tun
  • Locked
  • Question
opera_mail.AuthenticateCredential error ORA-20001 in Oracle Database
Replies
0
Views
152
Aung Thurein Tun
Aung Thurein Tun

Part and Inventory Search

Sponsor

Back
Top