COMMAND IN EDITING THE INIT.ORA

[oracle8]

hi,

Can anybody tell me the command in editing the initialization parameter dynamically. I'm using oracle 8.05 in win2k.

thanks,
rommel

 

[SantaMufasa]

Rommel,

If an initialization parameter is dynamically modifiable, you typically say:

ALTER SYSTEM SET <parameter> = <value>;

Mufasa
(aka Dave of Sandy, Utah, USA @ 05:27 (11Jun04) UTC (aka "GMT" and "Zulu"), 22:27 (10Jun04) Mountain Time)

 

[sem]

Rommel, don't forget that these changes will be discarded after restarting, thus to make persistent changes you still need to edit init.ora.

Regards, Dima

http://seminihin.narod.ru

 

[oracle8]

thanks guys, you're all excellent

always,
rommel