868591 wrote:place query in control file
We are importing data from one DB to other.Schema contains 200 tables and each table contains 1million rows. We are using query option to subset the data using different conditions instead of loading full table data .
We want to subset from different tables. But query option in expdp only taking 1800 characters only.
why it is taking upto 1800 characters only. Any restriction imposed on query option.
Anyone suggest me how to increase query clause length?