Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a way to put comments in a data pump export parameter file?

share|improve this question

1 Answer 1

up vote 6 down vote accepted

Yes, by using # at the start of a line.

Actually everything after the # sign will be ignored, so this can be used after a parameter as well.

This is a bit hidden in the manual:

Table names specified on the command line cannot include a pound sign (#), unless the table name is enclosed in quotation marks. Similarly, in the parameter file, if a table name includes a pound sign (#), then the Export utility interprets the rest of the line as a comment, unless the table name is enclosed in quotation marks

Quoted from: http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#sthref137

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.