Qn on user_dump_dest

Hello:

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.

Thanks, ST2000

~

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...

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.
:rolleyes: