select * from dba_users;
select DBMS_METADATA.GET_DDL('USER','SCOTT') from DUAL;
OUTPUT
------------
create user "SANDEEP"
IDENTIFIED BY VALUES 'S:E678BE8A02044521B5C8E4E9074A9ECAD807503963EBBAB7BE596334C57E;157E94BEA7ED4A10'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
select DBMS_METADATA.GET_DDL('USER','SCOTT') from DUAL;
OUTPUT
------------
create user "SANDEEP"
IDENTIFIED BY VALUES 'S:E678BE8A02044521B5C8E4E9074A9ECAD807503963EBBAB7BE596334C57E;157E94BEA7ED4A10'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
No comments:
Post a Comment