--创建临时表空间
create temporary tablespace icer
tempfile 'D:\oracle\icer.dbf'
size 50m
autoextend on
next 50m maxsize 1024m
extent management local;
--创建数据表空间
create tablespace icer_data
logging
datafile 'D:\oracle\icer_data.dbf'
size 50m
autoextend on
next 50m maxsize 1024m
extent management local;
--创建用户并指定表空间
create user icer_user identified by icer_user
default tablespace icer_data
temporary tablespace icer;
错误是:
在行 19 上开始执行命令时出错:
create user icer_user identified by icer_user
default tablespace icer_data
temporary tablespace icer
命令出错, 行: 19 列: 13
错误报告:
SQL 错误: ORA-65096: 公用用户名或角色名无效
到底哪里出错了???