oracle 导入数据及表空间用户的创建

航仔 1月前 ⋅ 93 阅读

--删除用户

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;


全部评论: 0

    我有话说: