Qn on user_dump_dest
I have my user_dump_dest/udump destined to /home/oracle.
We are tracing lots of things and space is not enough in there. Our operations department is not finding space to add in /home/oracle. So temporarily of I have to change the destination to some other filesystems what are the implications I would have. What are the adjustments need to be made in pfile or init_SID.ora, coz, I don't want the system to hang around for overlooking anything.
just change the user_dump_dest to whatever location you want to write to. make sure that filesystem/directory exists. Also. there are no implications...
"High Salaries = Happiness = Project Success."
No problema, just do:
ALTER SYSTEM SET USER_DUMP_DEST='/new_fs';
and then edit the init.ora file to set the same directory.
That's all it takes.
Click Here to Expand Forum to Full Width