RE: alter system set user_dump_dest problem [SOLUTION]

From: O'Neill, Sean <Sean.ONeill_at_organon.ie>
Date: Thu, 31 Aug 2000 11:25:55 +0200
Message-Id: <10605.115942@fatcity.com>

SQL> select * from v$version;

BANNER

---

Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
CORE Version 4.0.5.0.0 - Production
TNS for 32-bit Windows: Version 8.0.5.0.0 - Production NLSRTL Version 3.3.2.0.0 - Production

SQL> select name, issys_modifiable from v$parameter where name like '%dump%';

NAME                                                             ISSYS_MOD
---------------------------------------------------------------- ---------
background_dump_dest                                             FALSE
user_dump_dest                                                   FALSE
max_dump_file_size                                               FALSE

So despite my interpretation of what manual states I can't change the user_dump_dest with alter system.
INIT.ORA is the only option therefore?

Thanks to Shevtsov and Linda for their input :)

Sean :)

######   ######  ######  ###### 
#    #   #    #  #    #  #    #  Rookie
####     #    #  ######  ######  Data
#   #    #    #  #    #  #    #  Base 
#    #  #######  ######  #    #  Adminstrator
-------------------------------- ------------ 

Organon (Ireland) Ltd.
E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]

The only man who never makes a mistake is the man who never does anything. Received on Thu Aug 31 2000 - 04:25:55 CDT