shall I use multiple separete tables or one table with multiple partition on oracle I have an entity lets call it Response, and another entity called ResponseType, Response entity contains the ResponseType; so when I am building the physical model I confused with how to implement it; I have two option ; 1. I can create a Response table for each of ResponseType. 2. I can create a Global Response table with a ResponseType Column and create a partition for each ResponseType; Note that; Response Entity is same for each of ResponseType. Each ResponseType is equivalent.

What is your idea?
This depends on two things: the number of (expected) rows that you'll be dealing with, and the number of different fields between each ResponseType.

How many rows are you going to be dealing with?  And about how many of each ResponseType?  If you're talking about a solution that involves millions of rows, then partitioning the tables makes sense.  However, if you're only talking about hundreds or even thousands of rows then I wouldn't worry about it.

If the fields between each ResponseType aren't very different, the you probably won't need as many individual ResponseType tables.  However, if the data for each ResponseType is significantly different, then I can see the reasons behind creating (many?) multiple ResponseType tables, with one global Response table.  If it were me, I would try to create as few ResponseType tables as possible.