创建Oracle表空间及用户

create tablespace TABLESPACE_YKCD datafile 'E:\app\Administrator\oradata\orcl\tablespace_ykcd.dbf' size 500M autoextend on next 5m maxsize unlimited;

create user yk_chengdu identified by letmein default tablespace TABLESPACE_YKCD temporary tablespace TEMP profile default;

grant connect,resource,dba to yk_chengdu;

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;