删除用户
drop user dj cascade;
第零步:连接数据库
进入sqlplus 以系统管理员的身份
命令: sqlplus
sys/system as sysdba
第零步:连接数据库
进入sqlplus 以系统管理员的身份
命令: sqlplus
sys/system as sysdba
第一步:创建表空间,注意:要跟备份的数据的表空间一致
create tablespace TB_POMS datafile 'D:\app\Administrator\oradata\orcl1\TB_POMS_data.dbf' size 50m autoextend on next 50m maxsize 4000m extent management local;
第二步:创建临时表空间
create temporary tablespace TB_POMS_temp tempfile 'D:\app\Administrator\oradata\orcl1\TB_POMS_temp_data.dbf ' size 50m autoextend on next 50m maxsize 4000m extent management local;
第三步:创建用户,并赋表空间,注意:要跟要备份数据的用户一致
create user omsuser identified by hugewinforever default tablespace TB_POMS temporary tablespace TB_POMS_temp;
第四步:授权用户为dba;
grant dba to omsuser;
create or replace directory dump_dir as 'F:\dfiles\bak';
grant read, write on directory dump_dir to omsuser;
第五步:导入数据,不能在sqlplus下导入,先退出sqlplus,在cmd下执行
Impdp omsuser/hugewinforever directory=dump_dir dumpfile=OMS20151113.dmp logfile=oms.log
create tablespace TB_POMS datafile 'D:\app\Administrator\oradata\orcl1\TB_POMS_data.dbf' size 50m autoextend on next 50m maxsize 4000m extent management local;
第二步:创建临时表空间
create temporary tablespace TB_POMS_temp tempfile 'D:\app\Administrator\oradata\orcl1\TB_POMS_temp_data.dbf ' size 50m autoextend on next 50m maxsize 4000m extent management local;
第三步:创建用户,并赋表空间,注意:要跟要备份数据的用户一致
create user omsuser identified by hugewinforever default tablespace TB_POMS temporary tablespace TB_POMS_temp;
第四步:授权用户为dba;
grant dba to omsuser;
create or replace directory dump_dir as 'F:\dfiles\bak';
grant read, write on directory dump_dir to omsuser;
第五步:导入数据,不能在sqlplus下导入,先退出sqlplus,在cmd下执行
Impdp omsuser/hugewinforever directory=dump_dir dumpfile=OMS20151113.dmp logfile=oms.log