Must be on a Unix box !
> ----------
> From: Shevtsov, Eduard[SMTP:EShevtsov_at_flagship.ru]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, August 31, 2000 09:02
> To: Multiple recipients of list ORACLE-L
> Subject: RE: alter system set user_dump_dest problem
>
>
> How is that? It's puzzle for me...
>
> Ed
>
>
> >
> >
> > Connected to:
> > Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
> > With the Partitioning and Java options
> > PL/SQL Release 8.1.5.0.0 - Production
> >
> > SQL> select name, issys_modifiable from v$parameter where name like
> > '%dump%';
> >
> > NAME
> > ISSYS_MOD
> > -------------------------------------------------------------
> > --- ---------
> > shadow_core_dump
> > FALSE
> > background_core_dump
> > FALSE
> > background_dump_dest
> > IMMEDIATE
> > user_dump_dest
> > IMMEDIATE
> > max_dump_file_size
> > IMMEDIATE
> > core_dump_dest
> > IMMEDIATE
> >
> > SQL> alter system set user_dump_dest='C:\temp';
> >
> > System altered.
> >
> > -----Original Message-----
> > Eduard
> > Sent: Wednesday, August 30, 2000 1:18 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Sean and List
> >
> > SQL> select * from v$version;
> >
> > BANNER
> > -------------------------------------------------------------
> > Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
> > PL/SQL Release 8.1.5.0.0 - Production
> > CORE Version 8.1.5.0.0 - Production
> > TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
> > NLSRTL Version 3.4.0.0.0 - Production
> >
> > SQL> col name format a20
> > SQL> select name, issys_modifiable
> > 2 from v$parameter
> > 3 where name like 'user_dump%';
> >
> > NAME ISSYS_MOD
> > -------------------- ---------
> > user_dump_dest FALSE
> >
> >
> > I don't think that behavior of the user_dump_dest was changed.
> > Can anyone check this?
> >
> > Ed
> >
> >
> > > SQL>alter system set user_dump_dest = 'e:\oradba\admin\tst';
> > > *
> > > ERROR at line 1:
> > > ORA-02095: specified initialization parameter cannot be modified
> > >
> > > This is Oracle 8.0.5 on NT4-SP4. According to
> > > Oracle8 Reference
> > > Release 8.0
> > > A58242-01
> > > ALTER SYSTEM SET can be used to change this initilization
> > parameter.
> > > Pulling my hair (what's left of it that is) out on this
> > one. Bethca' it's
> > > something simple. What am I doing wrong??? Aaaarrggggghhhhh.
> > >
> > >
> > > 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.
> > > - Theodore Roosevelt
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > Author: O'Neill, Sean
> > > INET: Sean.ONeill_at_organon.ie
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access /
> > Mailing Lists
> > >
> > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like
> > subscribing).
> > >
> >
> > --
> > Author: Shevtsov Eduard
> > INET: eshevtsov_at_flagship.ru
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> > Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> > --
> > Author: Linda Wang
> > INET: lwang_at_messagemedia.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> > Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Author: Shevtsov, Eduard
> INET: EShevtsov_at_flagship.ru
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Thu Aug 31 2000 - 05:13:09 CDT
