oracle 11g 如何打开dmp文件

Question

oracle 11g 如何打开dmp文件

Answer 1

1、先安装好11g,创建表空间再创建用户。CREATE TABLESPACE TS1 DATAFILE '/data1/oracle/ts1.dbf' SIZE 512M AUTOEXTEND ON NEXT 256M MAXSIZE UNLIMITED;create user user01 identified by 123456 default tablespace TS1;grant dba,resource,connect to user01;2、dmp是备份文件，一般会包含用户和表空间信息3、dmp文件是如果用exp导出的，就用imp导入imp user01/123456 file=a.dmp FULL=y4、dmp文件是如果用expdp导出的，就用impdp导入create or replace directory expdp_dir1 as '/data1/backup';grant read,write on directory expdp_dir1 to user01;或者grant read,write on directory expdp_dir1 to public;例如：impdp user01/123456 directory=expdp_dir1 dumpfile=a.dmp logfile=impdp.log5、查询sqlplus /nologconn user01/123456select * from tab;