I have a un-partitioned database with around 35 tables.
Some of the tables are around 30Gb. I want to set-up partitioning on these tables in an efficient manner.
I have some questions-
1) Can I alter my table structure to add partioning?
2) If no , then is what is the procedure for adding partitioning?
3) Do I have to periodically add new partitions?
4) Do I have to re-build my indexes after a partition is dropped?

I am looking for ways to achieve this with least manual labour( due to 35 tables).
Any help would be appreciated.

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.