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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
oracle
- Thread starter pram
- Start date
- Thread starter
- #3
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.
your only limit is the amount of disk you have.
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
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
- Status
Similar threads
- Locked
- Question