I am importing a database (.dmp) file using the 12c Data Pump import wizard. I created a user for the database and remapped the schema and tablespace. I get the following errors:
- ORA-39071: Value for NAME_EXPR is badly formed.
- ORA-01756: quoted string not properly terminated
- ORA-39012: Client detached before the job started.
The statement begins, "dbms_datapump.metadata_filter(handle => h1, name => 'NAME_EXPR', value => 'IN(''ABSENCE_DURATION'', ... The statement includes a LONG list of tables and the number of characters is 32,659.
I'm thinking that this statement may have exceeded some limit. If that is the case, how would I break this statement into several statements?