All,
I am running a large expdp job using a .bat file. An example of one of the lines is this:
expdp "'/ as sysdba'" directory=IMPORT_DB dumpfile=vismag_brightness%%U.dmp logfile=vismag_brightness.log compression=ALL TABLES=sat_cat_owner.vismag_brightness QUERY=sat_cat_owner.vismag_brightness:'\"where exists (select visual_magnitude_uuid from sat_cat_owner.visual_magnitude where sat_cat_owner.visual_magnitude.visual_magnitude_uuid=sat_cat_owner.vismag_brightness.visual_magnitude_uuid)\"'
Running the .bat results in this:
I then tried to put it into a parameter file. As you can still see in the above picture, it previously gave me an error, but I fixed that and it still gave me the same error. The query was the same as above, only did not have the escape backslashes.
Now because of this, I am certain I am escaping right. Now I just need to find the reason for the identifier being too long.
Below is an image showing other wierd behavior, when trying to simplify the query to see if its because the query is too long. AND if it is because its too long...how to I can the config so it can handle it?
The difference in the above picture, is that the first try has only \"....while the second has what was working for me before above (if I try without the single quotes, it fails on quoting issue for the large query). So the second cmd, like I said, has '\" instead of just \"...and it doesnt work! When it does above for the larger query, but that gives that separate error.
Please help! Thank you