Sql Help Pls

[spidereddy]

I think the way you are approaching is not correct man.. when you create table today with a name, a table is created.. how can you create the same table tomorrow if it exists in the database even though they have different partition scheme names.. think of that.. I will post a link related to partitioning in Oracle in a bit.. good luck

 

I am not creating the same table tomorrow.. I am inserting tomorrow's data into same table but to the different partition..

like that it continues for 60 days.. on 61st day I will drop the first partition..and insert 61st day data into new partition..