Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best Approach to store 1.2 billion records

772262Mar 8 2011 — edited Mar 8 2011

Hello All,
In our OLTP database there will be few tables with 1.2 billion records. The row length is approximate 50 bytes.
Please can I know what are best options to store this historical data.

Would it be advisable to store all this records go in one partitioned table, or create a separate schema in the same database for storage.

Would it impact performance of the database?

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2011

Added on Mar 8 2011

#11g, #database, #dba, #general-database-discussions, #oracle, #performance

6 comments

1,403 views