UDE-00014: invalid value for parameter, ‘schemas’

When using the data pump utility with the QUERY parameter to export only a subset of the data, I ran into the error:

UDE-00014: invalid value for parameter, ‘schemas’

As it turns out, you cannot fully qualify the table names within your QUERY statement. The reason for this seems to be because you can only export from the one schema with the combination of parameters that I had. It still seems a little strange to not be able to fully qualify the schema name.

It’s a shame that the utility doesn’t recognise that the schema is the same one and continue. The error message isn’t that great either, because you don’t actually specify a “schemas” parameter.

Like it, share it...

Category: Data Pump

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *