This error is caused because of a malformed command line impdp / expdp. Also it depends on your oracle server version, in recent oracle servers you will probably have less problem with the pattern combination.
For instance you have several times the pattern exclude=TRIGGER: or serveral times the pattern exclude=TABLE:
For instance :
impdp system/password directory=MYDIR dumpfile=thedump.dmp logfile=thedump.log exclude=TRIGGER:"IN ('MYTRIG1','MYTRIG2')" exclude=TRIGGER:"LIKE '%_MYTRIG_%'" schemas=MYSCHEMA
This will cause a segmentation fault because
How to solve it?
Rewrite your filter clause in order to have only one exclude=TRIGGER:…
OR
Use a parfile, Oracle server is more tolerant with parfile (and also it is a good practice if you have a lot filter).
impdp system/password directory=MYDIR dumpfile=thedump.dmp logfile=thedump.log
parfile=./sql/myparameter_file.txt schemas=MYSCHEMA
Leave a Reply