Oracle Database-Oracle Data Migration from 11g to 10g

C:\oracle\product\10.2.0\db_1\bin\exp.exe hr/hr@orcl file=C:\Users\Administrator\Desktop\bk\hr10g.dmp full=n


C:\oraclexe\app\oracle\product\11.2.0\server\bin\exp.exe hr/hr@xe file=C:\Users\Administrator\Desktop\bk\hr11g.dmp full=n STATISTICS=


----- connecting to 11g SQLPLUS ---------
-----------------------------------------

C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe /nolog


------- CONNECTING TO 11G'S XE DATABASE.

conn sys/sys@xe as sysdba

-------- CREATING USER HR

CREATE USER HR IDENTIFIED BY HR;

------- GRANTING PREVILEGES.

GRANT DBA TO HR;


----- NOW IMPORTING THE 10G DATA TO 11G.

C:\oraclexe\app\oracle\product\11.2.0\server\bin\imp.exe HR/HR@XE file=C:\Users\Administrator\Desktop\bk\hr10g.dmp full=y


----- 10G IMPORTED TO 11G


------- NOW 11G WILL GO TO 10G.

C:\oracle\product\10.2.0\db_1\bin\exp.exe HR/HR@XE file=C:\Users\Administrator\Desktop\bk\hr10gABCD.dmp full=n STATISTICS=NONE
----------------------------------------- -------- ---------------------------------------------------- ------ ---------------
           |                                  |                         |                                 |               |
           |                                  |                         |                                 |               |
           V                                  V                         V                                 V               V
  N.B. : THE EXP PATH OF 10G            DATA OF 11G                  DMP PATH                       FULL SCHEMA (HR)    NO STAT


------- NORMAL IMPORT TO 10G ...................

C:\oracle\product\10.2.0\db_1\bin\SQLPLUS.EXE /NOLOG

-------- CREATING USER HR

CONNECT SYS/SYS@ORCL AS SYSDBA

CREATE USER HR IDENTIFIED BY HR;

------- GRANTING PREVILEGES.

GRANT DBA TO HR;

EXIT

C:\oracle\product\10.2.0\db_1\bin\IMP.exe HR/HR@ORCL file=C:\Users\Administrator\Desktop\bk\hr10gABCD.dmp full=Y