Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the udump directory (SQL)

Re: How to find the udump directory (SQL)

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 06 Mar 2003 21:29:00 +0100
Message-ID: <krbf6vgqnp5vovaa18cjmsklrjb8rmrbj3@4ax.com>


On Thu, 6 Mar 2003 12:10:34 -0800, "Gabriel Gonzalez" <no-spam_at_no-spam.com> wrote:

>select value from v$system_parameter where name='user_dump_dest';
>
>I think you need to be logged in as sys or system... Or with DBA privs,
>something like that
>

The SELECT_CATALOG_ROLE is sufficient.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 06 2003 - 14:29:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US