Updating two tables in oracle
Oracle has continued to evolve and refine its partitioning capabilities since its first implementation of range partitioning in Oracle 8.
In Oracle 8i and 9i, Oracle has continued to add both functionality and new partitioning methods.
The only thing that may outpace the demands of the work place is the size of the databases themselves.
Database size has grown to a point where they are now measured in the hundreds of gigabytes, and in some cases, several terabytes.
They are listed in the table below with a brief description.
For partitioning of indexes, there are global and local indexes.
Partitioning Defined The concept of divide and conquer has been around since the times of Sun Tzu (500 B. Recognizing the wisdom of this concept, Oracle applied it to the management of large tables and indexes.Global indexes provide greater flexibility by allowing indexes to be independent of the partition method used on the table.This allows for the global index to reference different partitions of a single table.In addition to the basic privileges listed above, the creation of five small tablespaces (TS01, TS02, TS03, TS04, TS05) or changes to the tablespace clause will need to be done to use the examples provided in this article.Ideally, you should try each of the scripts in this article under a DBA role.