From the course: Oracle Database 12c: Advanced SQL
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Splitting LIST partitions - Oracle Database Tutorial
From the course: Oracle Database 12c: Advanced SQL
Splitting LIST partitions
- [Instructor] We are not constrained by the number of partitions that we initially created along with our table. We can actually add new partitions to our partition table using the alter table command. However, if your partition table already has a default partition specified, you cannot just add the new partition, but instead you need to split the default partition into two new partitions. You split it to a new partition with a user-specified value, as well as the default partition, which remains. But enough talk, let's see a demo. Going to exercise files, you can find an alter table command provided. Let's copy this command, and paste it to our SQL developer window. Basically, what we are running here is an alter table sales_list command. We specify that you want to split the sales other partition, which is our default partition, to two new partitions. The new partition will store values where the state column has NV, which stands for Nevada. Remember, we previously created a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.