1、首先备份test用户的所有表和视图等
exp test/123456@192.168.108.70/orcl file=etms20170818_70.dmp log=0818_70.log
2、删除test用户的所有表和视图等
sql>drop user test cascade;
3、重新创建test用户，并指定默认表空间
create user test identified by 123456 defaulttablespace tets quota unlimited on test
4、赋予相应的权限
grant dba to test;
5、导入刚才备份的dmp
imp test/123456@192.168.108.70/orcl file=etms20170818_70.dmp ignore=y full=y log=0818_imp.log