Export and Import Data from XML Schema Database

Login with Username and Password

SQL> show parameter db_name;    -- It will shows database name
SQL> exit;

How to setup my SID?
set oracle_sid <2nd DBname>

Export from user XX to user AA
Export: Release 10.1.0.4.2 - Production on Thu Mar 01 07:50:03 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: XX/XX
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP > c:\ware.dmp
(2)U(sers), or (3)T(ables): (2)U > T
Export table data (yes/no): yes > Y
Compress extents (yes/no): yes > Y
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
TA
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > WAREHOUSES . . Exporting table WAREHOUSES     

9 rows exported
Table (T) or Partition (T:P) to be exported: (RETURN to quit) >
Export terminated successfully without warnings.
C:\

***************************************************
TO IMPORT DATA FROM C:\WARE.DMP FILE TO USER SCOTT
C :\> IMP SCOTT/TIGER FILE=C:\WARE.DMP FULL=Y