Oracle 8i 数据库导入数据和创建帐户删除帐户

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;