Hi,

I want to copy a read-only tablespace to another location and the tomorrow to rename it via the database ant remove the old location.

will this work?

Today:
OS>cp all_data_files_tbs_read_only to_another_location

Tomorrow:
SQL> Alter tablespace tbs_read_only offline;
SQL> Alter database rename datafile to to_another_location;
SQL> Alter tablespace read write;
OS>rm old all_data_files_tbs_read_only

Bensmail