Table processing for Oracle Big data tables

1. First create the RowNum serial number for the Big data table

-- Add serial Number field Alter Table Add  Number ; -- Populating serial numbers Update Set = rownum;

2. Data is divided into different tables by XLH fields (processed in a table-based manner)

Create Tablehik_1001 as SelectClm1 asHik_clm1,clm2 asHik_clm2,clm3 asHik_clm3 fromTESTwhereXlh>=1  andXlh<=5000000;Create Tablehik_1002 as SelectClm1 asHik_clm1,clm2 asHik_clm2,clm3 asHik_clm3 fromTESTwhereXlh>=5000001  andXlh<=10000000;Create Tablehik_1003 as SelectClm1 asHik_clm1,clm2 asHik_clm2,clm3 asHik_clm3 fromTESTwhereXlh>=10000001  andXlh<=15000000;Create Tablehik_1004 as SelectClm1 asHik_clm1,clm2 asHik_clm2,clm3 asHik_clm3 fromTESTwhereXlh>=15000001;

3. Establish a primary key or index for the created table, respectively

Create Index  on hik_1001  (HIK_CLM2) Alter Table hik_1001  addconstraintprimarykey (HIK_CLM1)

If the data is duplicated, you just need to build an index.

4. Then the data after the sub-table processing

Table processing for Oracle Big data tables