impdp导入中断
PL/SQL发现错误提示,请问如何处理
文本:CREATE OR REPLACE TRIGGER tr_tb_287614632 BEFORE INSERT ON TB_877176232 FOR EACH ROW WHEN (new.img_id is null) begin select seq_tb_287614632_id.nextval into:new.img_id from dual;end;
impdp导入中断
PL/SQL发现错误提示,请问如何处理
文本:CREATE OR REPLACE TRIGGER tr_tb_287614632 BEFORE INSERT ON TB_877176232 FOR EACH ROW WHEN (new.img_id is null) begin select seq_tb_287614632_id.nextval into:new.img_id from dual;end;
参考下面例子,生成sql语句。
impdp hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp
SQLFILE=dpump_dir2:expfull.sql
找到seq的语句,先创建seq后再重新导入即可。