Hi people,

I have tables that are making use of the Range Partition. We have 5 range partitions 1 - 5 representing each work day (Mon - Fri)

Now the load process after each day, should would by truncating the relevant partition and then inserting the fresh data. So Monday's load should truncate partition 1 and reload the fresh Mondays sales data.

I am unclear on how the truncate would work - i cannot see a command on the Internet - all I can see is the attach/detach partitions which does not seem to work with the above truncate/load approach. Anyone have any suggestions?

Thanks in advance

detach - load replace - attach

Does each partition needs to be in its own separate tablespace ? or can they be in the same one ? What are the pro's/con's of each ??

thanks :-)