Database Administration (MOSC)

MOSC Banner

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; 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center