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.