Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE EXPRESS EDITON(EX) ORA-32000: write to SPFILE requested but SPFILE is not modifiable

2642171Apr 17 2014 — edited Apr 21 2014

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

NAME                                           TYPE    VALUE                                                                                          

-------------------------------------------------- ----------- ----------------------------------------------------------------------------------------------------

spfile                                         string  C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\SPFILEXE.ORA 

Show parameter utl_file_dir:

NAME                                           TYPE    VALUE                                                                                          

-------------------------------------------------- ----------- ----------------------------------------------------------------------------------------------------

utl_file_dir                                   string                                                                                                     

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2014
Added on Apr 17 2014
5 comments
2,827 views