Oracle uses EXP,IMP to migrate databases

1. Export data from the source database:

Syntax:

Exp user1/pwd1@test1 file= ' e:test.dmp ';

Example:

Exp TIANZHI_SMART/TIANZHI_SMART@192.168.56.60:1521/ORCL file= ' E:\tianzhi_smart.dmp ';

Application screenshot:
I am stupid, the initial use, do not know where to enter this export statements, so specifically posted out, in preparation for like me as a small partner, less to take detours.

2. Import data to the target database:

Syntax:

Imp user2/pwd@test2 file= ' e:test.dmp ' full=y;

Example:

Imp tianzhi_smart/tianzhi_smart@192.168.10.129:1521/orcl file= ' E:\tianzhi_smart.dmp ' full=y;

Application screenshot: