oracle dmp文件导入导出实例

-创建临时表空间
create temporary tablespace temp
tempfile ‘E:\oracle\product\10.2.0\oradata\orcl\temp.dbf’ --数据库文件存储路径
size 500m
autoextend on
extent management local;

–创建数据表空间

create tablespace MOF datafile ‘E:\app\Administrator\oradata\orcl\MOF.dbf’ size 30720m ;

create user v65test
identified by “1”
default tablespace MOF
temporary tablespace TEMP
profile DEFAULT;

grant connect to v65test with admin option;
grant dba to v65test with admin option;
– Grant/Revoke system privileges
grant alter any index to v65test with admin option;
grant alter any table to v65test with admin option;
grant create any procedure to v65test with admin option;
grant create any table to v65test with admin option;
grant create any view to v65test with admin option;
grant drop any index to v65test with admin option;
grant execute any procedure to v65test with admin option;
grant unlimited tablespace to v65test with admin option;

imp v65test/1@orcl file=E:\资料\20181122.dmp full=y

njgl_1101 10.10.65.174

ALTER SYSTEM SET OPEN_CURSORS = 5500;
ALTER SYSTEM SET SORT_AREA_SIZE=3276800 SCOPE=SPFILE;
ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE;
ALTER SYSTEM SET SESSIONS=335 SCOPE=SPFILE;
ALTER SYSTEM SET SGA_MAX_SIZE=780140544 SCOPE=SPFILE;

create user yth1110
identified by “1”
default tablespace MOF
temporary tablespace TEMP
profile DEFAULT;

grant connect to yth1110 with admin option;

grant dba to yth1110 with admin option;
– Grant/Revoke system privileges
grant alter any index to yth1110 with admin option;
grant alter any table to yth1110 with admin option;
grant create any procedure to yth1110 with admin option;
grant create any table to yth1110 with admin option;
grant create any view to yth1110 with admin option;
grant drop any index to yth1110 with admin option;
grant execute any procedure to yth1110 with admin option;
grant unlimited tablespace to yth1110 with admin option;

create directory pump_dir as ‘E:\app\Administrator\admin\orcl\dpdump’;

grant read on directory pump_dir to dba;

impdp yth1110/1 directory=pump_dir dumpfile=QX201911.DMP logfile=yth11101111.log remap_schema=qx201911:yth1110