|
-
Stop causing self-inflicted wounds because you haven't read any documentation.
Exporting the Server Parameter File
You can use the CREATE PFILE statement to export a server parameter file (SPFILE) 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 spfile server parameter file by first exporting it, editing the resulting text file, and then re-creating it using the CREATE SPFILE statement
The exported file can also be used to start up an instance using the PFILE clause.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|