Oracle Database Discussions

Hi,

We have 2 schemas:
1> user - current_data, tablespace - current_data
2> user - archive_data, tablespae - archive_data

Both schemas have range (by batch_id - number) partitioned tables. I want to archive the older partitions from current_data to archive_data so I have created a temp table (non partitioned) in archive data and I first exchange partition (say P1) between current_data and the temp table and later between temp and archive_data. However the first exchange (between current_data and the temp table) leaves the partition P1 in archive_data table space and table temp in current_data tablespace and the second exchange (between temp and archive_data) leaves partition P1 in current_data for the table in archive_data.

This is stopping us from maintaining a clean cut of schemas and table spaces. Is there a way around this?

Thanks,
Kirti