ABSTRACT
The data storage structures within Oracle are plentiful and range from simple to complex. During your physical design, you have a choice between standard relational tables and one of the many table extensions offered within the Oracle software. This chapter will address the following table design issues:
Design with replicated tables Design with external tables Design with materialized views Design with Oracle object tables Design with ADTs Design with Oracle OIDs Design with pointer-based tables Design with nested tables Design with Oracle member methods
Let’s begin with a review of the Oracle replicated table structure and see how it can be incorporated into a physical design.
