Since the create a table partitioning syntax is hard to keep in mind, we'd better use GUI tools to facilitate us to create. Here we introduce the way to create a new partitioned table by SQL developer.
Right click on Tables, it shows a function menu.
We enable "Advanced" option.
Add some columns.
We partition the table by range.
Select the partition key.
Click on + sign to add a new partition.
Add the first partition segment with values less than TO_DATE('2000-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS').
The rest of rows go to the second partition segment, so we choose MAXVALUE.
We review DDL for making sure that everything is ready.
Then click OK to confirm.
After we have created the new partitioned table, we can try to load some data.
SQL> insert into hr.sales select * from sh.sales;
918843 rows created.
We made it.