1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| [oracle@localhost ZZTEST]$ sqlplus HR@orcl
SQL> set long 1000000
SQL> select dbms_metadata.get_ddl('USER', 'HR') from dual
DBMS_METADATA.GET_DDL('USER','HR')
--------------------------------------------------------------------------------
CREATE USER "HR" IDENTIFIED BY VALUES 'S:DF97122AB3E18E2AA5971E6406A4882BF19A
0EEEBC21CD67CD14DAF685BB;T:EE4FD35C5F70F35912894CF01EC9B09C0B14766A63F33F42A6430
8C963DA36BEF965B2A2E1195A582AC6E62E100A7FA2AE7739DD0D92B9A552106FDF4830C95C9BC2D
70AD3E54092E43AA00F595523B3' DEFAULT COLLATION "USING_NLS_COMP"
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
SQL> connect SYS@orclcdb as sysdba
Enter password:
Connected.
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> set long 1000000
SQL> select dbms_metadata.get_ddl('USER', 'SYSTEM') from dual;
DBMS_METADATA.GET_DDL('USER','SYSTEM')
--------------------------------------------------------------------------------
ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'S:20952CB319B3ACBD779D6C030E8BF8E83
7580B88891AD923CDDC9E276256;T:1CEE907B17984895E24F1515CC14F4303B485B61DD12367641
411C83051D457995D699B34DECE084ECCFD964DD1B3A7AF306757493CF05D69B6737251C3575112B
60D9C07A6DCED95382BEF21EE96C28'
TEMPORARY TABLESPACE "TEMP"
SQL> create user HR02 identified by HR;
User created.
SQL> select dbms_metadata.get_ddl('USER', 'HR') from dual;
DBMS_METADATA.GET_DDL('USER','HR')
--------------------------------------------------------------------------------
CREATE USER "HR" IDENTIFIED BY VALUES 'S:DF97122AB3E18E2AA5971E6406A4882BF19A
0EEEBC21CD67CD14DAF685BB;T:EE4FD35C5F70F35912894CF01EC9B09C0B14766A63F33F42A6430
8C963DA36BEF965B2A2E1195A582AC6E62E100A7FA2AE7739DD0D92B9A552106FDF4830C95C9BC2D
70AD3E54092E43AA00F595523B3' DEFAULT COLLATION "USING_NLS_COMP"
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP" |
Partager