Using LIST partitions - Oracle Database Tutorial

- [Instructor] Now it's time to roll up our sleeves and see Oracle table partitioning in action. For our first demo we will create a list partitioned table. This type of table method allows you the most granular level of control by explicitly defining how rows map to individual table partitions. We accomplish this by specifying a list of discreet values as the partitioning key mapping to each table partition but enough talk, it's time for a demo. Going to our exercise file you can find a create table command which create a list partition table called very creatively sales_list. Let's copy this command and paste it to our SQL Developer window. This table contains various columns that pertain to our company's sales history presumably such as the ID and name of the sales representative as well as the date and value of the sale. In addition, we have a column aptly named sales_state which is the column we will use to partition our table. Note that we mention a partition by list clause in…