Hi all,
What the syntax or script to locate the your archive log destination(full path) if you don't want to check it in the init.ora file?
Thanks
Printable View
Hi all,
What the syntax or script to locate the your archive log destination(full path) if you don't want to check it in the init.ora file?
Thanks
You can either get the information from svrmgrl by issuing the command "archive log list" or you can check v$parameter for 'log_archive_des%'.
select * from V$ARCHIVE_DEST;
MH
Thanks for all the help.