move a read only Tablespace

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

what?

what what?

rest everything right but issue alter tablespace online before alter tablespace read write...
but y did u not try it at ur end??

Rest assured it will work.

Code:

---

SQL> alter tablespace example offline;

Tablespace altered.

SQL> !cp /u01/data/ORCL/example01.dbf /u01/data/ORCL/example01a.dbf

SQL> alter database rename file '/u01/data/ORCL/example01.dbf'
  2    to '/u01/data/ORCL/example01a.dbf';

Database altered.

SQL> alter tablespace  example online;

Tablespace altered.

SQL> select tablespace_name, file_name, online_status from dba_data_files;

TABLESPACE_NAME    FILE_NAME                        ONLINE_
------------------  -------------------------------  -------
USERS              /u01/data/ORCL/users01.dbf      ONLINE
UNDOTBS1            /u01/data/ORCL/undotbs01.dbf    ONLINE
SYSAUX              /u01/data/ORCL/sysaux01.dbf      ONLINE
SYSTEM              /u01/data/ORCL/system01.dbf      SYSTEM
EXAMPLE            /u01/data/ORCL/example01a.dbf    ONLINE

SQL>

---

:p