Can partition DDL scripts be generated dynamically?
We have a requirement to dynamically generate DDL scripts to create new partitions on a table in our data warehouse. In our example, we want to partition our data by COUNTRY_ID. We have a transaction table in which we create partitions based on each COUNTRY_ID.
When a new value for COUNTRY_ID gets created, is there a way we can dynamically create the DDL script so the new partition is automatically created? COUNTRY_ID is not a smart id and we cannot predict the new values.
We are using Oracle 10g database. Thanks in advance. Not a DBA but just looking for guidance on how to approach.