2012-07-27

error in datapump : -bash: syntax error near unexpected token `('

Usually this error appears when you try to export/import with datapump from command line in bash/ksh , and your command  has ( or ) inside .
example:  expdp directory=export__directory dumpfile=expdp_dumpfiles_%U.dmp schemas=(...,....,....) COMPRESSION=ALL parallel=4

Solution : use escape characters  \(  or \) 


example:  expdp directory=export__directory dumpfile=expdp_dumpfiles_%U.dmp schemas=\(...,....,....\) COMPRESSION=ALL parallel=4 

Niciun comentariu:

Trimiteți un comentariu