2021-10-13

1. alter tablespace users add datafile’D:\app\86136\oradata\booksales\user02.dbf’ size 10M;
   

2. alter tablespace temp add tempfile’D:\app\86136\oradata\booksales\temp02.dbf’ size 10M;
   

3.alter tablespaceusers add datafile’D:\app\86136\oradata\booksales\user03.dbf’ size 5M autoextend on next 1M maxsize 100M;

4. alter database datafile’D:\app\86136\oradata\booksales\user03.dbf’autoextend off;
   

5. alter tablespace users rename datafile’D:\app\86136\oradata\booksales\user02.dbf’ to ‘D:\app\86136\oradata\booksales\user002.dbf’;
   注意：重命名要有两个文件，一个原文件，另一个是已经命名的目标文件。
   

6. select tablespace_name,autoextensible,file_name from dba_data_files;
   

7Alter system set control_files=‘D:\app\86136\oradata\booksales\control01.ctl’,'D:\app\86136\oradata\booksales\control03.ctl’scope=spfile;

8. ALTER DATABASE BACKUP CONTROLFILE TO ‘D:\app\86136\oradata\booksales\contro.bkp’;
   

9. alter database backup controlfile to trace;