Hi
Perhaps someone can tell me if I am doing something wrong or if these actions are not available in oracle express edition.
I am trying to modify my utl_file_dir destination in order to test data_pump but am getting the following error message.
alter system set utl_file_dir='C:\feeder' scope=spfile
Error report -
SQL Error: ORA-32000: write to SPFILE requested but SPFILE is not modifiable
Is this due to me using oracle Express? are some features not available?
Oracle version. 11.2.0 express edition
OS: Windows 7 64 bit
Hardware: Samsung RV411 laptop
Show parameter spfile
-------------------------------------------------- ----------- ----------------------------------------------------------------------------------------------------
| spfile | string | C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\SPFILEXE.ORA |
Show parameter utl_file_dir:
-------------------------------------------------- ----------- ----------------------------------------------------------------------------------------------------
Create pfile='temp_pfile.ora' from spfile;
The SOLE contents of temp_pfile.ora:
*.SPFILE='C:\oraclexe\app\oracle\product\11.2.0\server\dbs/spfileXE.ora'
I was expecting more in there!!
Many thanks
J