oracle impbd导入,Oracle impdp导入.dmp文件

oracle impbd导入,Oracle impdp导入.dmp文件

首先你要导入.dmp文件。那就必须要有一个.dmp文件才能够进行。(自己去找)[root@www ~]# mkdir /backup

[root@www ~]# chmod -R 777 /backup

[root@www ~]# mv filename.dmp /backup/

[root@www ~]# chown oracle.oinstall /backup/

[root@www ~]# chown oracle.oinstall /backup/*

[root@www ~]# ll

[root@www ~]# ll /backup/

总用量 53360

-rwxrw-rw- 1 oracle oinstall 54640640 12月 30 2016 20161228.dmp

登录oracle[root@www /]# su - oracle

[oracle@www ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 24 23:57:22 2018

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

创建用户

SQL> create user ami identified by ami;

User created.

赋予权限

SQL> grant connect,resource,dba to ami;

Grant succeeded.

查询用户表空间文件的绝对路径：

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/prod/system01.dbf

/u01/app/oracle/oradata/prod/sysaux01.dbf

/u01/app/oracle/oradata/prod/undotbs01.dbf

/u01/app/oracle/oradata/prod/users01.dbf

/u01/app/oracle/oradata/prod/example01.db

创建表空间

SQL> create tablespace BPAS datafile '/u01/app/oracle/oradata/prod/db1.dbf' size 100M autoextend on;

Tablespace created.

查询临时表空间文件的绝对路径。如果需要的话，可以通过查询来写定绝对路径。一般用${ORACLE_HOME}就可以了

SQL> select name from v$tempfile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/prod/temp01.dbf

创建临时表空间

SQL> create temporary tablespace GROUP1 tempfile '/u01/app/oracle/oradata/prod/db2.dbf' size 500M autoextend on;

Tablespace created.

将/backup目录转化成oracle数据库能够识别的目录。

SQL> create directory dump_dir as '/backup';

Directory created.

授权

SQL> grant read,write on directory dump_dir to system;

Grant succeeded.

退出

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

进行导入.dmp文件

[oracle@www ~]$ cd /backup/

[oracle@www backup]$ ls

filename.dmp

[oracle@www backup]$ impdp system/oracle directory=dump_dir dumpfile=filename.dmp logfile=impdp.log schemas=ami

登录oracle

[oracle@www backup]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 25 00:31:19 2018

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

查看对象

SQL> select count (*) from dba_objects where owner='AMI';

COUNT(*)

----------

16730