1.查询用户对应的profile
SQL> col username for a30
SQL> col account_status for a20
SQL> col profile for a30
SQL> set pages 100 lines 400
SQL> select username,account_status,profile from dba_users where username='SCOTT';
USERNAME ACCOUNT_STATUS PROFILE
------------------------------ -------------------- ------------------------------
SCOTT OPEN MONITORING_PROFILE
2.获取创建profile的SQL语句
SQL> set long 99999
SQL> select dbms_metadata.get_ddl('PROFILE','MONITORING_PROFILE') from dual;
DBMS_METADATA.GET_DDL('PROFILE','MONITORING_PROFILE')
--------------------------------------------------------------------------------
CREATE PROFILE "MONITORING_PROFILE"
LIMIT
COMPOSITE_LIMIT DEFAULT
SESSIONS_PER_USER DEFAULT
CPU_PER_SESSION DEFAULT
CPU_PER_CALL DEFAULT
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT
IDLE_TIME DEFAULT
CONNECT_TIME DEFAULT
PRIVATE_SGA DEFAULT
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME DEFAULT
PASSWORD_REUSE_TIME DEFAULT
PASSWORD_REUSE_MAX DEFAULT
PASSWORD_VERIFY_FUNCTION DEFAULT
PASSWORD_LOCK_TIME DEFAULT
PASSWORD_GRACE_TIME DEFAULT
SQL>
3.将以上查询结果复制，直接执行即可
