Hi....
Can anybody help me provide steps to follow to alter the existing daily partitioned table into monthly partitioned table in oracle database 11.2.0.2 version (table should have same name)?
Note : I don't have access to use oracle special packages like dbms_redefinition etc and i also have indexes present on the table. please let me know if any adhoc way to do this.
response would be really appreciated...!!
Thanks..!!