:

ORA-39041: Filter “INCLUDE” either identifies all object types or no object types

Data Pump is a very powerful tool and a great improvement over the original export and import utilities in early versions of Oracle.

With the 10g version of data pump, you can filter objects to very specific levels, stating what you want to include and exclude within your export and import.

For example, you can have VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT in an EXCLUDE or INCLUDE command which will result in the object grants for views being either included or excluded when using data pump export or import. To give you a real life example the import might be trying to do something like this:

GRANT SELECT ON VIEWA TO USERA;

When I was using data pump to import a schema into a new database I got the error below because I had a forward slash in front of the include statement, like this: /VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT

ORA-39001: invalid argument value
ORA-39041: Filter “INCLUDE” either identifies all object types or no object types.

All I needed to do was remove the forward slash at the beginning for it to work, so it looked like this in the end:

VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT

Like it, share it...

Category: Data Pump


Related Posts

Leave a Reply

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