1、登录数据库
sqlplus / as sysdba
2、创建表空间
CREATE TABLESPACE YCYL LOGGING DATAFILE 'C:\app\oracle\YCYL.dbf'
SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;
3、创建临时表空间
create temporary tablespace YCYLTEMP tempfile 'C:\app\oracle\YCYLTEMP.dbf'
size 100m autoextend on next 32m maxsize 500m extent management local;
4、创建用户
CREATE USER ycyl IDENTIFIED BY ycyl120 DEFAULT TABLESPACE YCYL TEMPORARY TABLESPACE YCYLTEMP;
5、用户授权
grant connect,resource,dba to ycyl;
grant create session to ycyl;