Are those tables partitioned on the Oracle implementation?

If the answer is yes... how are they partitioned?

If the answer is no... why are you thinking on partitioning?

---Yes these table are partitioned in oracle. In Oracle all tables have date column and they are partitioned on that column. But in SQL Server we removed those columns.

--------------------------------------------------------

My Question is can I partition parent table with date column and child tables with Primary key column ?

Short answer is: Yes... followed by a question: Why? What are you trying to accomplish?

I am worried because it might cause performance issues.

-----------------------------------------------------

If i have data from 2010 to present. How should i plan partitioning with maxval and minval partition please advise.

Thanks for your time and reply.