The requirement is to export the data in database A to a *.dmp file, and then import the *.dmp file into database B.
1. Export database A in the cmd window, enter the following command:
Export all databases
EXP User name/password @ database name File=d:\*.dmp full=y
Export the database under the current user
EXP username/Password @ database name owner= (username) file=d:\*.dmp
2. Connecting to database b
under SQL Plus enter the following command: Conn Sys/sys as S YSDBA;
3. Create user
create user username identified by password;
&n Bsp 4. Grant User DBA Authority
grant connect,resource,dba to user name;
5. Import Database A Enter the following command under CMD:
 &NBSP ; Import entire library to a user
IMP username/password @ database name full=y file=d:\*.dmp ignore=y
Import a table to user
&N Bsp IMP username/password @ database name file=d:\*.dmp tables= (table name) To this end, the Oracle database Export import completed, I hope that the deployment will be completed tomorrow.