Hi,
I am trying to attach to a impdp session, but for some reason I can't access. (Oracle 12c: Release 12.2.0.1.0 )
First of all, the job_name is: Import Schema 00 and its owner is imp_admin
It is running, by using dba_datapump_jobs:
| OWNER_NAME | JOB_NAME | OPERATION | JOB_MODE | STATE | DEGREE | ATTACHED_SESSIONS | DATAPUMP_SESSIONS |
|---|
| IMP_ADMIN | Import Schema 00 | IMPORT | FULL | EXECUTING | 1 | 0 | 2 |
When I try to do:
impdp imp_admin/*****@pdb1 attach='Import Schema 00'
I get:
LRM-00112: multiple values not allowed for parameter 'attach'
So I then try to escape characters:
impdp imp_admin/*****@pdb1 attach=\'Import Schema 00\'
But then I get:
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 408
ORA-31638: cannot attach to job Import Schema 00 for user IMPORT
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 401
ORA-31632: master table "IMPORT.Import Schema 00" not found, invalid, or inaccessible
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 393
ORA-00942: table or view does not exist
ORA-06512: at "SYS.KUPV$FT_INT", line 2578
ORA-06512: at "SYS.KUPV$FT", line 205
Which it looks like it get the job name correct (Import Schema 00), but now is uses IMPORT as a user instead of IMP_ADMIN
I've also tried something like this:
impdp imp_admin/****@pdb1 attach="'Import Schema 00'"
but it gets the same error.
It gets the first word from attach and uses it as a user.
I have also tried using a parameter file:
...
attach='Import Schema 00'
but it also fails:
UDI-00014: invalid value for parameter, 'attach'
What I am doing wrong here? Besides using a space for a job_name, of course.
Any advice is appreciated.