ex: I've a table called sales which is having 1250 rows. And it's increases day by day at average of 20 rows per day. So, for performance I've done table partition.
by
alter table sales partition 5, 5 partition is done.

I want to no when I insert a data into a table, on which partition the data is inserted, and how to check the data in which partition it's inserted.

thanks & regards
jaya