一 oracle 导入数据泵
create tablespace NNC_DATA01 datafile
'C:\oracle\oradata\nnc_data01.dbf'
size 500M autoextend on next 50M extent management local uniform size 512k;
create tablespace NNC_INDEX01 datafile
'C:\oracle\oradata\nnc_index01.dbf'
size 500M autoextend on next 50M extent management local uniform size 256k;
Create user ncc identified by 1 default tablespace NNC_DATA01
temporary tablespace temp;
Grant connect,dba to ncc;
create DIRECTORY dump_ncc as 'D:\dump';
grant read,write on directory dump_ncc to ncc;
impdp ncc/1 directory=dump_ncc dumpfile=NCC20210701.DMP remap_schema=NCC2111:NCC
ALTER TABLESPACE NNC_DATA01 ADD DATAFILE
'F:\oracle\oradata\nnc_data04.dbf' SIZE 500M
AUTOEXTEND ON NEXT 50M;
二 oracle 导出数据泵
create DIRECTORY dump_NCC2105TEST_0708 as 'D:\dump';
grant read,write on directory dump_NCC2105TEST_0708 to NCC2105TEST_0708;
expdp ncc2105/1 (要导出的数据在那个用户下这里就是那个) directory=dump_NCC2105TEST_0708