import data into Oracle 18xe using IMPDP failed

Question

I have created a new oracle DB 18xe on a docker.

I am trying to import a dump file using the following command

impdp **/**@xepdb1 directory=DATA_PUMP_DIR dumpfile=file.dmp 
remap_schema='source:dest' logfile=imp.log  CONTENT=DATA_ONLY 

I am getting the following error

Import: Release 18.0.0.0.0 - Production on Thu Dec 9 05:39:42 2021
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

ORA-39002: invalid operation

I could not figure out why I am getting this error, I tried to import one table only, used the following command

impdp **/**@xepdb1 directory=DATA_PUMP_DIR dumpfile=file.dmp 
remap_schema='source:dest' logfile=imp.log  CONTENT=DATA_ONLY  tables=table1

I got the following error

Import: Release 18.0.0.0.0 - Production on Thu Dec 9 05:39:42 2021
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

ORA-39002: invalid operation
ORA-39166: Object dest.table1 was not found or could not be exported or imported.

Appreciate your assistance people.

Answer 1

As far as I can tell, remap_schema doesn't / shouldn't have single quotes.

No : remap_schema='source:dest'

Yes: remap_schema=source:dest

See REMAP_SCHEMA in documentation.