Oralce horizontal score: Table sharding

Source: Internet
Author: User
In this article, Oralce horizontal table sharding finds that tables are stored in each partition table by year based on the above horizontal table sharding. Since the data volume is still large by year after the business promotion. That

In this article, Oralce horizontal table sharding finds that tables are stored in each partition table by year based on the above horizontal table sharding. Since the data volume is still large by year after the business promotion. That

In this article, Oralce horizontal table sharding, we found that tables are stored in each partition table by year according to the above horizontal table sharding. Since the data volume is still large by year after the business promotion. So we can consider whether we can split it in the year table.

The following describes the splitting procedure.

Original table structure (only for partitions ):

From the figure above, we can see that the WLKP_FP_DATA_2012 partition is stored in the tablespace WLKP_FP_DATA_2012.

So after half the time, we had statistical data for half a year and found that WLKP_FP_DATA_2012 had a lot of partition table data.

We consider splitting WLKP_FP_DATA_2012 by quarter.

  • Run the preceding statement to split WLKP_FP_DATA_2012 into four sub-partitions: WLKP_FP_DATA_2012_1, WLKP_FP_DATA_2012_2, WLKP_FP_DATA_2012_3, and WLKP_FP_DATA_2012_4

    Note: Why is the last partition time? Because the end time for splitting WLKP_FP_DATA_2012 is.

    If the time is, an error will be reported.

    The split partition is as follows:

    Compared with the above, we can see that we split the WLKP_FP_DATA_2012 sub-partition table by quarter. Note that the above is still split under the current WLKP_FP_DATA_2012 tablespace.

    We can see that the partition table is only extended to. What should we do in?

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.