Oracle动态服务器参数文件创建

SQL> create pfile='pfileorac.ora' from spfile;

File created.

SQL> host ls

c-615447911-20101110-000 init.ora orapwmdsp spfilemdsp.ora

hc_DBUA0.dat initorac.ora pfileorac.ora

hc_mdsp.dat lkMDSP snapcf_mdsp.f

SQL> create spfile='initorac.ora' from pfile='pfileorac.ora'

2 ;

File created.

SQL> host ls

c-615447911-20101110-000 init.ora orapwmdsp spfilemdsp.ora

hc_DBUA0.dat initorac.ora pfileorac.ora

hc_mdsp.dat lkMDSP snapcf_mdsp.f