My table has 2 partitions, one active partition(holds current day data) and other is an inactive partition which holds yesterday's data.
Before current day data is inserted into the active partition, the existing data in active partition is copied into inactive partition as follows:
INSERT INTO test PARTITION part_inactive (
col1,
col2,
col3,
col4
)
select
col1,
col2,
col3
from test partition (part_active);
when I run the above insert, I am getting
ORA-00926: missing VALUES keyword
I couldn't find in Oracle docs the correct syntax for insert using PARTITION keyword?. Anyone know the proper syntax for this?.