How can I export db from 11.2 xe and import to 19c standard version
I use the comand as below
exp sys/oracle@XE file=D:\source\ecpscmp.dmp owner=ecpscmp log=D:\source\ecpscmp_exp.log
and got the dmp file then copy to 19c stardard version windows server
use the export cmd is as below
imp system/oracle@orcl file=D:\source\ecpscmp.dmp fromuser= ecpscmp touser= ecpscmp log=D:\source\ecpscmp_imp.log
but it always require me to input username and password
I already use below comand to create user ecpscmp on destination server and the messeage
shows up it is sucessfully
ALTER SESSION SET "_ORACLE_SCRIPT"=TRUE;
CREATE USER ecpscmp IDENTIFIED BY ecpscmp;