2014-06-23-orcl2.sql

botang

select  * from v$backup_piece_details;

create tablespace tbs05205_a datafile '+mygroup' size 10M ;

select  * from dba_data_files;


drop tablespace tbs05205_a;

create tablespace tbs05205_c datafile '+data/orcl/datafile/tbs05205_c.dbf' size 10M ;
select  * from dba_data_files;

create tablespace tbs05205_d datafile '+data'  size 10M ;

alter tablespace tbs05205_d  offline;

alter database rename file  '+DATA/orcl/datafile/tbs05205_d.dbf'      to  '+DATA/orcl/datafile/tbs05205_d.268.851028831'  ;

alter tablespace tbs05205_d  online;

select  * from dba_data_files;

alter tablespace tbs05205_c  offline;

alter tablespace tbs05205_c  online;
alter tablespace tbs05205_d  online;


alter tablespace tbs05205_d  offline;

alter tablespace tbs05205_c  online;

alter tablespace tbs05205_d  online;

alter database rename file   '+DATA/orcl/datafile/tbs05205_d.268.851028831'  to '+DATA/orcl/datafile/TBS05205_D.267.851029729';

select  * from dba_data_files;


--------------------------------
create tablespace tbs05205_e  datafile '+data(mytemplate1)'  size 10M ;

create tablespace tbs05205_f  datafile '+data(mytemplate2)'  size 10M ;