Oracle db impdp command syntax error

I’m trying to run
impdp system/password dumpfile=FILE.dmp fromuser=USER1 touser=USER1 directory=$DIRECTORY on oracle server but keep getting following error:

  • LRM-00118: syntax error at ‘=’ at the end of input

I’ve come to this after running the following commands on oracle server sqlplus:

  • alter session set container=sgeplus;
  • CREATE USER USER1 IDENTIFIED BY USER1;
  • GRANT ALL PRIVILEGES TO USER1 WITH ADMIN OPTION;
  • GRANT CONNECT TO USER1;
  • CREATE USER GEOC_WEB IDENTIFIED BY GEOC_WEB;
  • GRANT CONNECT TO GEOC_WEB;

And running this on oracle server:

  • expdp sgeplus/sgeplus@localhost/orcl full=y dumpfile=sge210b.dmp

I haven’t found any similar error, so any help will be welcomed!

Thanks in advance.

Oracle 11 IMPDP Table Exists but gets Does Not Exist Error

I’m running in to a weird problem with IMPDP and Oracle DB version 11.2.0.4.0 where I have a table in the destination schema that does indeed exist, but IMPDP thinks it doesn’t. See this entry from the import log file:

Starting “EXPORT_USER”.”SYS_IMPORT_TABLE_01″: export_user/********
directory=EXPORT_DIRECTORY
dumpfile=SMARTCLOUDCONSOLE_OWNER_20170830.dmp
TABLE_EXISTS_ACTION=APPEND DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS
REMAP_SCHEMA=SMARTCLOUDCONSOLE_OWNER:MIKETESTCONSOLE_OWNER
TABLES=SMARTCLOUDCONSOLE_OWNER.ACCOUNTDEPLOYMENTLINKS QUERY=”WHERE
account_id = (select account_id from accounts where lower(guid) =
‘#####’)”

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Table “MIKETESTCONSOLE_OWNER”.”ACCOUNTDEPLOYMENTLINKS” exists. Data
will be appended to existing table but all dependent metadata will be
skipped due to table_exists_action of append

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

ORA-31693: Table data object
“MIKETESTCONSOLE_OWNER”.”ACCOUNTDEPLOYMENTLINKS” failed to load/unload
and is being skipped due to error: ORA-00942: table or view does not
exist

We are using VPDs such that the _owner user owns all of the objects, so I don’t think it’s a problem of ownership. And it seems like it figures out that the table exists from the second line there Table "MIKETESTCONSOLE_OWNER"."ACCOUNTDEPLOYMENTLINKS" exists. but then when it proceeds it fails with ORA-00942: table or view does not exist

What might be wrong with my use of IMPDP?

Oracle db impdp command syntax error

I’m trying to run
impdp system/password dumpfile=FILE.dmp fromuser=USER1 touser=USER1 directory=$DIRECTORY on oracle server but keep getting following error:

  • LRM-00118: syntax error at ‘=’ at the end of input

I’ve come to this after running the following commands on oracle server sqlplus:

  • alter session set container=sgeplus;
  • CREATE USER USER1 IDENTIFIED BY USER1;
  • GRANT ALL PRIVILEGES TO USER1 WITH ADMIN OPTION;
  • GRANT CONNECT TO USER1;
  • CREATE USER GEOC_WEB IDENTIFIED BY GEOC_WEB;
  • GRANT CONNECT TO GEOC_WEB;

And running this on oracle server:

  • expdp sgeplus/sgeplus@localhost/orcl full=y dumpfile=sge210b.dmp

I haven’t found any similar error, so any help will be welcomed!

Thanks in advance.