Oracle PL/SQL/PL SQL/Dump

Get user dump and background dump

   <source lang="sql">

SQL> SQL> drop user myUser; SQL> SQL> set serverout on; SQL> SQL> create user myUser identified by myPass; SQL> SQL> grant create session to myUser; SQL> SQL> connect myUser/myPass; SQL> SQL> declare

 2    myString varchar2(255);
 3    myNumber  number;
 4  begin
 5     myNumber := dbms_utility.get_parameter_value ( "background_dump_dest", myNumber, myString );
 6
 7     dbms_output.put_line( "background: " || myString );
 8
 9     myNumber := dbms_utility.get_parameter_value ( "user_dump_dest", myNumber, myString );
10
11     dbms_output.put_line( "user:       " || myString );
12  end;
13  /

background: C:\ORACLE\APP\ORACLE\ADMIN\XE\BDUMP user: C:\ORACLE\APP\ORACLE\ADMIN\XE\UDUMP SQL> SQL> SQL> drop user myUser;

      </source>