I'm facing an issue trying to assign a dedicated tablespace to a range partitioned table using the NUMTOYMINTERVAL clause. I'm working on Oracle 11g version and I would use the auto partition creation feature in order to create each month a new partition to use in a log table. Using the create statement, all work fine. If I try to use the alter table statement, i got an error. I understand that i cannot add a new partition (Oracle automatic feature) but I need to assign a dedicated tablespace to the new partition Oracle is going to create. Someone could help me?
Thank you in advance.