Hi,
We have database on Oracle 12.2.0.1.0, in the DB design phase.
I have 2 questions:
1. Just saw the documentation that says starting from Oracle 12.2 a non partitooned table into a partioned one online. Is this completely online activity without any impact to the database? Let me know the drawbacks /issues is any with this.
2. If we decide to go with Monthly partitions to start with and later need to change to daily partitions, can this be done online? If yes please provide some useful links with examples.
Thank you.