Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> AW: alter system set user_dump_dest problem [REVISIT]
I looked up my Oracle installations, here are the results:
Oracle 8.1.6, Win 2000
ISSYS_MOD
IMMEDIATE
Oracle 8.1.5, Redhat Linux
ISSYS_MOD
IMMEDIATE
Oracle 8.1.5, NT 4.0
ISSYS_MOD
FALSE
Oracle 7.3.4, NT 4.0
ISSYS_MOD
FALSE
I'm a little bit confused, cause on Linux and Win2000 it is immediate, =
on NT
4.0 it is false. I have no explanation for this behaviour.=20
Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de
=20
-----Urspr=FCngliche Nachricht-----
Von: O'Neill, Sean [mailto:Sean.ONeill_at_organon.ie]
Gesendet: Donnerstag, 31. August 2000 14:53
An: Multiple recipients of list ORACLE-L
Betreff: RE: alter system set user_dump_dest problem [REVISIT]
Like Eduard on 8.1.5.0 I'm getting user_dump_Dest ISSYS_MOD value of =
FALSE.
Linda Wang is getting value of IMMEDIATE.
Are we missing running a script of some description???
>From: "Shevtsov, Eduard" <EShevtsov_at_flagship.ru>
> Date: Thu, 31 Aug 2000 09:49:41 +0400
> Subject: RE: alter system set user_dump_dest problem
>> SQL> col name format a20
>> SQL> select name, issys_modifiable
>> 2 from v$parameter
>> 3 where name like 'user_dump%';
>> =20
>> NAME ISSYS_MOD
>> -------------------- ---------
>> user_dump_dest FALSE
>
>
>How is that? It's puzzle for me...
>
>Ed
Sean :)
###### ###### ###### ######=20 # # # # # # # # Rookie #### # # ###### ###### Data # # # # # # # # Base=20 # # ####### ###### # # Adminstrator -------------------------------- ------------=20Organon (Ireland) Ltd.
The only man who never makes a mistake is the man who never does = anything.
--=20
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 Received on Thu Aug 31 2000 - 07:25:38 CDT