First page Back Continue Last page Graphics
SPFILE – Exporting
Export binary contents to a text file
- Performed with the CREATE PFILE command
Reasons for exporting
- Documentation purposes
- Backup and recovery purposes
- Use as a template for a new database
Notes:
The contents of a SPFILE can be dumped or exported to a text file using the CREATE PFILE command.
You might want a copy of your initialization parameters as they are defined in your SPFILE for documentation purposes, backup and recovery purposes, or to use as a template when you want to create a new database.
The CREATE PFILE command can be run as long as a SPFILE has been created. The instance does not need to have been started with the SPFILE in order for the CREATE PFILE to run successfully.
Another example:
SQL> CREATE pfile = 'c:\oracle\admin\ora91\pfile\init_copy.ora'
2 FROM SPFILE = 'c:\oracle\admin\ora91\pfile\spfileora91.ora';
File created.