The INVJHISTORY table is created using the command:
SQL>CREATE TABLE INV_HISTORY
(inv_no NUMBER(3),
inv_date DATE,
inv_amtNUMBER(10,2))
partition by range (inv_date)
interval (numtoyminterval(1 ,'month'))
(partition pO values less than (to_date(l01-01-2005llldd-mm-yyyy1)),
partition p1 values less than (to_date('01-01-2006','dd-mm-yyyy')));
The following data has been inserted into the INVJHISTORY table :
INV_NO INV_DATE INV_AMT
1 30-dec-2004 1000
2 30-dec-2005 2000
3 1-feb-2006 3000
4 1-mar-2006 4000
5 1-apr-2006 5000
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE(l15-feb-2006l,ldd-mon-yyyy,)),FOR(TO_DATE(l15-apr-20061))
INTO PARTITION sys_py;
What would be the outcome of this command?