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

--需要迁移应以服务器文件夹：

/ 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 ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31560958/viewspace-2284701/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31560958/viewspace-2284701/