expdp/impdp

查看是否有中断的expdp job:
select * from dba_datapump_jobs where state = 'NOT RUNNING' and owner_name=’NC65’;
select a.sid,a.event,a.blocking_session,a.wait_class from v$session a where a.module like 'Data Pump%';

pdb需要进入容器里面创建目录：
show pdbs
alter session set container=orclpdb;

expdp NCC10/NCC10@172.20.17.29:1521/orclpdb schemas=NCC10 DIRECTORY=ncdb DUMPFILE=NCC1020240318.dmp LOGFILE=NCC1020240318.log

D:>expdp nc633/nc633 schemas=nc633 directory=CTSW dumpfile=nc6330408.dmp logfil
e=nc6330408.log exclude=table:"in('SM_FILESTOREVIEW')"

impdp导入：
create directory qyldir as '/oracle/expdata1';
grant read on directory qyldir to system;
grant write on directory qyldir to system;
impdp nnc/nnc directory=mydir dumpfile=biphnst2022_20231109021001.dmp logfile=20231116_impdp.log remap_schema=biphnst2022:nnc

create tablespace nnc_data01 datafile 'E:\data\nnc_data01.dbf' size 30G autoextend on next 500m extent management local uniform size 1m;
alter tablespace nnc_data01 add datafile 'E:\data\nnc_data02.dbf' size 10g autoextend on next 500m maxsize unlimited;
alter tablespace nnc_data01 add datafile 'E:\data\nnc_data03.dbf' size 10g autoextend on next 500m maxsize unlimited;
create tablespace nnc_index01 datafile 'E:\data\nnc_index01.dbf' size 5g autoextend on next 500m extent management local uniform size 128k;
create user nnc identified by nnc default tablespace nnc_data01 temporary tablespace temp;
grant dba,connect,resource to nnc;

alter tablespace SYSTEM add datafile '+DATA/ORCL/DATAFILE/system001.dbf' size 1G AUTOEXTEND ON;

oracle怎么删除directory 语法如下：drop directory dirname;
创建或者修改directory目录：create or replace directory dum_date_dir as '/home/oracle/datatmp';