Oracle 8i 数据库导入数据和创建帐户删除帐户
1. 删除帐户
drop user accountName cascade
?
2.创建表空间
?
create tablespace data_spaceloggingdatafile 'd:\oracle\oradata\Oracle8i\user_data.dbf'size 500mautoextend onnext 50m maxsize 24800mextent management local;
??
?
3. 创建帐户和指定表空间
?
create user accountName profile default IDENTIFied BY accountPassworddefault 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 bbsqyldefault 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;
?
?
