--删库
drop user username cascade;
--创建表空间
create tablespace DATAWORK datafile 'F:\DATAWORK.dbf' size 500m autoextend on next 50m maxsize unlimited;
--创建用户
create user username identified by password default tablespace DATAWORK;
--赋予操作权限
grant connect to username;
grant dba to username;
grant resource to username;
--导入dmp cmd操作
imp username/password@orcl file=F:\xxx.dmp full=y ignore=y
--空表也导出
--把查出的语句执行一遍然后再导出
select 'alter table '||table_name||' allocate extent;' from user_tables;
--导出dmp cmd操作
exp username/password@orcl file=D:\xxx.dmp