Partitioning explained
Oracle Partitioned tables
Oracle Partitioned tables
| Table A |
The table is a logical structure, visible to SQL statements as a single whole. |
|
| Partition A |
Partition A contains an exclusive subset of the data in Table A. The data in Partition A is not repeated in other partitions. |
|
| Partition B |
Partition B contains an exclusive subset of the data in Table A. The data in Partition B is not repeated in other partitions. |
|
| Partition C |
Partition C contains an exclusive subset of the data in Table C. The data in Partition C is not repeated in other partitions. |