-
Consequence of Deleting Initialization file
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
---------------
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|