Oracle composite partitioning

Source: Internet
Author: User

Create Table wzw_sales
(
Acct_no number (5 ),
Person varchar2 (30 ),
Sales_amount number (8 ),
Week_no number (2)
)
Partition by range (week_no)
Subpartition by list (acct_no)
(
Partition part9 values less than (9)
Tablespace dw_cdr_data
Pctfree 10
Pctused 40
Initrans 1
Maxtrans 255
(
Subpartition part9 values (1001) tablespace dw_cdr_data,
Subpartition sub2_part9 values (1002) tablespace dw_cdr_data
),
Partition part11 values less than (11)
Tablespace dw_cdr_data
Pctfree 10
Pctused 40
Initrans 1
Maxtrans 255
(
Subpartition part11 values (2001) tablespace dw_cdr_data,
Subpartition sub2_part11 values (2002) tablespace dw_cdr_data
)
);

Select * From wzw_sales partition (part9 );
Select * From wzw_sales subpartition (subpartition part9 );

Insert into wzw_sales values (1001, 'person1', 8 );
Insert into wzw_sales values (1002, 'person2', 2845,7 );
Insert into wzw_sales values (2001, 'person3', 3645,9 );
Insert into wzw_sales values (2002, 'person4', 4945,10 );

Grant create any table to dw;

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.