ora

制御ファイルの場所

SQL> select name from v$controlfile;
NAME




























































































































































-













































































C:\APP\XXX\ORADATA\TE01\CONTROL01.CTL

C:\APP\XXX\ORADATA\TE01\CONTROL02.CTL

C:\APP\XXX\ORADATA\TE01\CONTROL03.CTL

SQL> show parameter control_files
NAME                                 TYPE        VALUE




























































































































































-













































































control_files                        string      C:\APP\XXXXXXXXXXXXX\ORADATA\T

                                                 E01\CONTROL01.CTL, C:\APP\XXXX

                                                 XXXXXXXXX\ORADATA\TE01\CONTROL

                                                 02.CTL, C:\APP\XXXXXXXXXXXXX\O

                                                 RADATA\TE01\CONTROL03.CTL

SQL>