That is exactly what I want to know. Thanks.

But I have a question on how to manager the partitioned table.

For example EMP is partitioned by range ( START_DATE). There are four partitions:
emp_100101 less than ( to_date('10/01/2001','mm/dd/yyyy')
emp_010102 less than ( to_date('01/01/2002','mm/dd/yyyy')
emp_040102 less than ( to_date('04/01/2002','mm/dd/yyyy')
emp_070102 less than ( to_date('07/01/2002','mm/dd/yyyy')

Then I must keep an eye on this table. If the new partition is not added after 07/01/2002 then I will get a problem. How could we easily do this? If I create a scheduled job the problem is:
Every time when the new partition is added we must specify the default tablespace for the local indexes otherwise they will be created on the same tablespace as table.

So far I did not find a good way to manage the partitioned tables & indexes. Any idea is welcome.

Thanks.