Oracle数据导入常用命令

解锁
alter user scott account unlock;

删掉用户和所属对象
drop user ydjc cascade

新建用户
create user ydjc identified by ydjc;
GRANT Create USER,Drop USER,Alter USER,Create ANY VIEW,
Drop ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,Create SESSION TO ydjc

删掉表空间
drop tablespace tbs_app0;
drop tablespace tbs_app1;
drop tablespace tbs_master

创建表空间
create tablespace tbs_app0
datafile 'D:\oracle\product\10.2.0\oradata\ORCL\tbs_app0.dbf' size 120m;
create tablespace tbs_app1
datafile 'D:\oracle\product\10.2.0\oradata\ORCL\tbs_app1.dbf' size 120m;
create tablespace tbs_master
datafile 'D:\oracle\product\10.2.0\oradata\ORCL\tbs_master.dbf' size 120m;