오라클 기동시 아래와 같은 오류가 날 때 ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory 터미널로 접속해서 기동해 보면..... SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 8 16:56:11 2022 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> connect /as sysdba Connected to an idle instance. SQL> startup ORA-01261: Parameter db_r..

Oracle SELECT a.tablespace_name AS TablespaceName , a.file_name FileName , (a.bytes - b.free) AS Used , b.free AS Free , a.bytes Total FROM ( SELECT file_id , tablespace_name , file_name , SUM(bytes) bytes FROM dba_data_files GROUP BY file_id, tablespace_name, file_name) a, ( SELECT tablespace_name , file_id , SUM(NVL(bytes,0)) FREE FROM dba_free_space GROUP BY tablespace_name, file_id ) B WHERE..