本文介绍如何使用CREATE PFILE语句从Oracle实例中导出服务器参数文件为文本初始化参数文件，便于诊断及修改。这种方法类似于SQL*Plus的SHOW PARAMETERS命令，可以查看实例当前使用的全部参数值。
You can use the CREATE PFILE statement to export a server parameter file to a text
initialization parameter file. Doing so might be necessary for several reasons:
■ For diagnostic purposes, listing all of the parameter values currently used by an
instance. This is analogous to the SQL*Plus SHOW PARAMETERS command or
selecting from the V$PARAMETER or V$PARAMETER2 views.
■ To modify the server parameter file by first exporting it, editing the resulting text
file, and then re-creating it using the CREATE SPFILE statement[@more@]
initialization parameter file. Doing so might be necessary for several reasons:
■ For diagnostic purposes, listing all of the parameter values currently used by an
instance. This is analogous to the SQL*Plus SHOW PARAMETERS command or
selecting from the V$PARAMETER or V$PARAMETER2 views.
■ To modify the server parameter file by first exporting it, editing the resulting text
file, and then re-creating it using the CREATE SPFILE statement[@more@]
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1002611/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-1002611/
扫一扫
4939
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
