what happens if init.ora gets deleted when database is running(ORacle 9i)???
Printable View
what happens if init.ora gets deleted when database is running(ORacle 9i)???
nothing, it is only read at startup
If you are using a SPFILE then it won't even impact startup, although it would be a good idea to keep the plaintext version around for backup / reference.
set pages 0
set feed off
set lines 200
spool initSID.ora
select name, value
from v$parameter
where isdefault = 'FALSE'
/
spool off
--this might be missing