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
