1、oracle 账户登录linux
2、使用dba登录oracle
[oracle@localhost ~]$ sqlplus /nolog
SQL> conn /as sysdba
3、创建表空间
CREATE TABLESPACE DEMO DATAFILE '/home/oracle/app/oracle/oradata/orcl/DEMO01.DBF' SIZE 1024M AUTOEXTEND ON NE0XT 10M;
ALTER TABLESPACE DEMO ADD DATAFILE '/home/oracle/app/oracle/oradata/orcl/DEMO 02.DBF' SIZE 1024M AUTOEXTEND ON NEXT 10M;
ALTER TABLESPACE DEMO ADD DATAFILE '/home/oracle/app/oracle/oradata/orcl/DEMO03.DBF' SIZE 1024M AUTOEXTEND ON NEXT 10M;
CREATE temporary TABLESPACE DEMO_TEMP tempfile '/home/oracle/app/oracle/oradata/orcl/DEMO_TEMP .DBF' SIZE 1024M AUTOEXTEND ON NEXT 10M;
4、创建用户
--创建的用户最好与要导入库的用户一致
create user demo identified by demo default tablespace DEMO Temporary tablespace DEMO _TEMP;
5、赋权限
grant dba to demo;
grant connect to demo;
6、创建 directory 用于impdp expdp
create or replace directory dump_dir as '/home/oracle/app/oracle/oradata/orcl/dump_dir';
grant read,write on directory dump_dir to public;
select * from all_directories ; --可以查看是否创建成功 需要查看具体目录是否有改文件加,没有需要手动创建
7、导入数据库
-- 需退出到oracle sql 再执行
impdp demo/demo@ORCL REMAP_SCHEMA=demo:demo directory=dump_dir file=xxxxx.dmp log=xxx.log
--创建的用户最好与要导入的用户一致 避免出现问题