Get user dump and background dump : Dump « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Dump

Get user dump and background dump

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;
           
       

Related examples in the same category