How to get current time in Oracle, and use in interval partition?
You can not do that. You need to specify the date yourself, as that clause accepts only literals or MAXVALUE, and not expressions.



So you could just use:

(PARTITION p_first VALUES LESS THAN (DATE'2015-12-12'));

If you really want to calculate it dynamically, you need to use dynamic SQL.