SYS>> select dbms_metadata.get_ddl('USER','DBSNMP') from dual;
DBMS_METADATA.GET_DDL('USER','DBSNMP')
--------------------------------------------------------------------------------
CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'S:DDFDBFCD2DE1B4C1BEF25EA7E30A2F7C
558313D07013DE468963223CF2EC;E066D214D5421CCC'
DEFAULT TABLESPACE "SYSAUX"
TEMPORARY TABLESPACE "TEMP"
PASSWORD EXPIRE
SYS>>alter user DBSNMP identified by values 'S:DDFDBFCD2DE1B4C1BEF25EA7E30A2F7C558313D07013DE468963223CF2EC;E066D214D5421CCC';
User altered.
SYS>>select dbms_metadata.get_ddl('USER','DBSNMP') from dual;
DBMS_METADATA.GET_DDL('USER','DBSNMP')
--------------------------------------------------------------------------------
CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'S:DDFDBFCD2DE1B4C1BEF25EA7E30A2F7C
558313D07013DE468963223CF2EC;E066D214D5421CCC'
DEFAULT TABLESPACE "SYSAUX"
TEMPORARY TABLESPACE "TEMP"
DBMS_METADATA.GET_DDL('USER','DBSNMP')
--------------------------------------------------------------------------------
CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'S:DDFDBFCD2DE1B4C1BEF25EA7E30A2F7C
558313D07013DE468963223CF2EC;E066D214D5421CCC'
DEFAULT TABLESPACE "SYSAUX"
TEMPORARY TABLESPACE "TEMP"
PASSWORD EXPIRE
SYS>>alter user DBSNMP identified by values 'S:DDFDBFCD2DE1B4C1BEF25EA7E30A2F7C558313D07013DE468963223CF2EC;E066D214D5421CCC';
User altered.
SYS>>select dbms_metadata.get_ddl('USER','DBSNMP') from dual;
DBMS_METADATA.GET_DDL('USER','DBSNMP')
--------------------------------------------------------------------------------
CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'S:DDFDBFCD2DE1B4C1BEF25EA7E30A2F7C
558313D07013DE468963223CF2EC;E066D214D5421CCC'
DEFAULT TABLESPACE "SYSAUX"
TEMPORARY TABLESPACE "TEMP"
Online Slots - The M Resort at Borgata Hotel Casino & Spa
ReplyDeleteBorgata Hotel Casino 남원 출장안마 & Spa · 제천 출장안마 Play. 전라남도 출장샵 Sign up 안동 출장안마 at the official website. Borgata Hotel Casino & Spa - Atlantic City. 서귀포 출장마사지