1. 删除帐户

  drop user accountName cascade 

?

2.创建表空间

?

create tablespace data_space
logging
datafile 'd:\oracle\oradata\Oracle8i\user_data.dbf'
size 500m
autoextend on
next 50m maxsize 24800m
extent management local;

??

?

3. 创建帐户和指定表空间

?

create user accountName profile default IDENTIFied BY accountPassword
default tablespace "tablespaceName" temporary tablespace "tablespaceName_temp"
account unlock;
grant connect to accountName with admin option;
grant dba to accountName with admin option;
alter user accountName default role all;

?4. imp 命令导入数据OK

?

?

5. Oracle 10g 与8i 创建用户的区别(sql 中不需要监时表空间)

?

create user bbsqyl profile default IDENTIFied BY bbsqyl
default tablespace "tablespaceName" 
account unlock;
grant connect to bbsqyl with admin option;
grant dba to bbsqyl with admin option;
alter user bbsqyl default role all;

?

注意:如果以前有表空间

可以去E:\oracle\oradata\目录下查看*.DBF文件 SQYL_DB.DBF 表空间为 sqyl_db 当然有区分大小写

如果大写不是就是小写

同同理临时表空间也一样

?6.

conn internal/oracle@orcl as sysdba;

?

?