C:\Documents and Settings\201910>sqlplus sys/mysecretpassword as sysdba SQL*Plus: Release 10.1.0.2.0 - Production on Wed Nov 12 14:32:28 2008 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- C:\AUG\SYSTEM.DBF C:\AUG\UNDOTBS1.DBF C:\AUG\SYSAUX.DBF C:\AUG\USERS.DBF SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string SQL> create spfile from pfile; File created. SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string...
Comments