-----检查flash recovery area的使用情况
select * from V$FLASH_RECOVERY_AREA_USAGE;FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE                 0                        0               0
ONLINELOG                  0                        0               0
ARCHIVELOG                0                       0                 0
BACKUPPIECE                   0                         0               0
IMAGECOPY                      0                         0               0
FLASHBACKLOG                0                         0               0
--计算flash recovery area已经占用的空间
SQL> select sum(percent_space_used)*3/100 from v$flash_recovery_area_usage;SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
                       0
--------查看recovery_file_dest
select name,space_limit/1024/1024 as space_limit,space_used/1024/1024 as space_used from v$recovery_file_dest;NAME
--------------------------------------------------------------------------------SPACE_LIMIT SPACE_USED
----------- ----------
D:\oracle\product/flash_recovery_area
       2048  0我想说的是  都是0  怎么就出现 ORA 00257。麻烦大家帮忙看下。谢啦。急本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/panys/archive/2009/01/20/3838846.aspx