Hi Parag,

The problem here is that these tablespaces contain partitions of a table. Hence i tried this after what i did below:

Code:
SQL> select tablespace_name from dba_data_files where file_name='/oracle/product/10.2.0/dbs/MISSING00310';

TABLESPACE_NAME
------------------------------
HLMUR_2008_03_03


SQL> select partition_name,table_name from dba_tab_partitions where tablespace_name='HLMUR_2008_03_03';

PARTITION_NAME                 TABLE_NAME
------------------------------ ------------------------------
HLMUR_2008_03_09               HOTLISTMATCHEDUSERRESPONSE
HLMUR_2008_03_08               HOTLISTMATCHEDUSERRESPONSE
HLMUR_2008_03_07               HOTLISTMATCHEDUSERRESPONSE
HLMUR_2008_03_06               HOTLISTMATCHEDUSERRESPONSE
HLMUR_2008_03_05               HOTLISTMATCHEDUSERRESPONSE
HLMUR_2008_03_04               HOTLISTMATCHEDUSERRESPONSE
HLMUR_2008_03_03               HOTLISTMATCHEDUSERRESPONSE

7 rows selected.

SQL> alter table BOF2.HOTLISTMATCHEDUSERRESPONSE drop partition HLMUR_2008_03_09;
alter table BOF2.HOTLISTMATCHEDUSERRESPONSE drop partition HLMUR_2008_03_09
*
ERROR at line 1:
ORA-00376: file 310 cannot be read at this time
ORA-01111: name for data file 310 is unknown - rename to correct file
ORA-01110: data file 310: '/oracle/product/10.2.0/dbs/MISSING00310'
This will obviously not work due the error above as its a missing file.
I hope i dont have to restart the whole duplicate process as its going to take a long time!

Thanks in advance