SQL> alter tablespace temp add tempfile'/u01/app/oracle/oradata/dave/temp01.dbf' size 51M reuse;
Tablespace altered.
SQL> select tablespace_name,file_namefrom dba_temp_files;
TABLESPACE_NAME FILE_NAME
------------------------ ------------------------------
TEMP /u01/app/oracle/oradata/dave/temp01.dbf
再次导入AWR 快照：
这次成功：
... Creating AWR_STAGE user
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Loading the AWR data from the following
| directory/file:
| /u01/backup
| awrdat_160_192.dmp
|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| *** AWR Load Started ...
|
| This operation will take a few moments. The
| progress of the AWR load operation can be
| monitored in the following directory/file:
| /u01/backup
| awrdat_160_192.log
|
... Dropping AWR_STAGE user
End of AWR Load
SQL> select dbid, retention fromdba_hist_wr_control;
DBID RETENTION
---------- ---------------------------------------------------------------------
877621333 +40150 00:00:00.0
879543530 +00008 00:00:00.0