SQL命令行创建用户:
1、DBA登陆
SQL> conn /as sysdba
2、创建表空间:
create tablespace HOUYANHUI
datafile
'D:\oraclexe\app\oracle\HOUYANHUI.dbf'
size 100M
autoextend ON
next 10M
maxsize 500M;
3、创建临时表空间
create temporary tablespace HOUYANHUI_TEMP
tempfile
'D:\oraclexe\app\oracle\HOUYANHUI_TEMP.dbf'
size 50M
autoextend ON
next 10M
maxsize 100M;
4、创建用户
create user HOUYANHUI
identified by HOUYANHUI
default tablespace HOUYANHUI
temporary tablespace HOUYANHUI_TEMP;
5、授权用户
grant CONNECT,RESOURCE,DBA to HOUYANHUI;
6、提交事务
commit;