--删除用户
drop user bsphis cascade
--删除表空间
DROP TABLESPACE bsphis INCLUDING CONTENTS AND DATAFILES;
创建表空间
CREATE TABLESPACE bsphis2633 DATAFILE 'G:\bsoftdb\bsphis2633.ora' SIZE 50M AUTOEXTEND ON NEXT 10M;
创建用户 并 加入表空间
create user bsphis2633 identified by bsphis2633
授权
grant connect to bsphis2633;
grant resource to bsphis2633;
grant dba to bsphis2633;
创建目录
create directory myma as 'E:\HisBackup';
创建导入对象
grant read,write on directory myma to bsphis2633;
数据泵导入数据
impdp bsphis2633/bsphis2633@orcl directory = myma dumpfile = 'bsphis2630509.DMP' logfile = 'bsphis2630509.log' full= y;
注意:本文归作者所有,未经作者允许,不得转载