Sunday, 15 December 2013

How to create pfile from spfile and vice versa


SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 23 21:57:58 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba;
Connected.
SQL> create pfile='e:\oracle\ora92\database\initinku.ora'
  2  from spfile='e:\oracle\ora92\database\spfileiacm.ora';

File created.

SQL>

SQL> create spfile='e:\oracle\ora92\database\spfileiacm1.ora'
  2  from pfile='e:\oracle\admin\iacm\pfile\init.ora';

File created.

SQL>

No comments:

Post a Comment