替换请求输出文件和日志文件

来源:这里教程网 时间:2026-03-03 12:43:33 作者:

--需要迁移应以服务器文件夹: / u02 / prod / inst / apps / PROD_ebsapp / logs / appl / conc / log   = 》  / u01 / PROD / app / fs_ne / inst / PROD_ebsapp1 / logs / appl / conc / log / u02 / prod / inst / apps / PROD_ebsapp / logs / appl / conc / out   = 》  / u01 / PROD / app / fs_ne / inst / PROD_ebsapp1 / logs / appl / conc / out --替换请求中请求输出和日志文件的路径 --运行脚本: UPDATE  fnd_conc_req_outputs t SET  t.file_name  =   REPLACE ( t.file_name ,                                    '/u02/prod/inst/apps/PROD_ebsapp/logs/appl/conc/out' ,                                    '/u01/PROD/app/fs_ne/inst/PROD_ebsapp1/logs/appl/conc/out' )        , t.file_node_name  =   'EBSAPP1' WHERE  concurrent_request_id  =   77373527 ; UPDATE  fnd_concurrent_requests fcr    SET  fcr.logfile_name  =   REPLACE ( fcr.logfile_name ,                                           '/u02/prod/inst/apps/PROD_ebsapp/logs/appl/conc/log' ,                                           '/u01/PROD/app/fs_ne/inst/PROD_ebsapp1/logs/appl/conc/log' )          , fcr.logfile_node_name  =   'EBSAPP1'          , fcr.outfile_name  =   REPLACE ( fcr.outfile_name ,                                           '/u02/prod/inst/apps/PROD_ebsapp/logs/appl/conc/out' ,                                           '/u01/PROD/app/fs_ne/inst/PROD_ebsapp1/logs/appl/conc/out' )          , fcr.outfile_node_name  =   'EBSAPP1'          , fcr.edition_name  =   'ORA$BASE'    WHERE  fcr.request_id  =   77373527 ;

相关推荐