Move from unpartitioned database to partitioned database

[Piyush Maheshwari]

Hi

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.

Thanks,
Piyush