Generate DDL to create user – reverse engineer

 

Query

SQL> SET long 200000000 SQL> SELECT dbms_metadata.get_ddl('USER','SIVA') from dual;

Output

DBMS_METADATA.GET_DDL('USER','SIVA') --------------------------------------------------------------------------------    CREATE USER "SIVA" IDENTIFIED BY VALUES 'S:1A6727A1D45324587FCFCFEAD63BBD96B 8DBBE0C6D1754259FE954EB9459;0FE66EDD5C4FF3D5'       DEFAULT TABLESPACE "DATA01"       TEMPORARY TABLESPACE "TEMP"