hali

SQL> create tablespace ts1 datafile '/tmp/ts1.dbf' size 8M;Tablespace created.SQL> create table ts1_t1 (id number) tablespace ts1;Table created.SQL> alter tablespace ts1 offline;Tablespace altered.SQL> !cp /tmp/ts1.dbf /u02/oradata/ts1.dbfSQL> alter database rename file  '/tmp/ts1.dbf' to '/u02/oradata/ts1.dbf';Database altered.SQL> recover datafile '/u02/oradata/ts1.dbf';ORA-00283: recovery session canceled due to errorsORA-00264: no recovery requiredSQL> alter tablespace ts1 online;Tablespace altered.SQL>