DBMS_METADATA

First i would thank my friend Xavier Picamal for remind me in this way, another way to crack oracle password yo could consider it the fastest way to crack oracle password.

SQL> SELECT dbms_metadata.get_ddl(‘USER’,’TEST’) from dual ;

DBMS_METADATA.GET_DDL(‘USER’,’TEST’)
——————————————————————————–

CREATE USER “TEST” IDENTIFIED BY VALUES ‘1E1A7CDA2ED2730E’
DEFAULT TA

SQL> conn / as sysdba
Connected.

SQL> alter user Test identified by Test_123 ;
User altered.

SQL> conn test/test_123
Connected.

SQL> alter user Test identified by VALUES ‘1E1A7CDA2ED2730E’
2 ;

User altered.

SQL>
SQL>
SQL> conn Test/test;
Connected.
SQL>

Or you could use Hash Value and use another software to cracks Such as : soonerorlater , Online Crack Website.

Thank you
Osama Mustafa

The DBMS_METADATA package provides a way for you to retrieve metadata from the database dictionary as XML or creation DDL and to submit the XML to re-create the object.

TableSpace

select dbms_metadata.get_ddl(‘TABLESPACE’,tablespace_name) from dba_tablespaces;

Get All Tablespace Script :

set head off echo off
select ‘select dbms_metadata.get_ddl(”TABLESPACE”,”’
|| tablespace_name || ”’) from dual;’ from dba_tablespaces

Table

select dbms_metadata.get_ddl(‘TABLE’,’DEPT’,’SCOTT’) from dual;

User

SELECT dbms_metadata.get_ddl(‘USER’,’SCOTT’) FROM dual;

Role

SELECT DBMS_METADATA.GET_GRANTED_DDL(‘ROLE_GRANT’,’SCOTT’) from dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL(‘OBJECT_GRANT’,’SCOTT’) from dual;
SELECT DBMS_METADATA.GET_GRANTED_DDL(‘SYSTEM_GRANT’,’SCOTT’) from dual;
SELECT dbms_metadata.get_ddl(‘ROLE’,’RESOURCE’) from dual;

This is the Most common Usage for this package more information read Oracle Documentation

Thank you
Osama mustafa

Tag: DBMS_METADATA

Crack Oracle Password using DBMS_METADATA