ORACLE Export/Import

Oracle Import :

imp
Username:.......
Password:.......
Import data Only: no
Import file: EXPDAT.DMP
List contents of import file only (yes/no): no > no
Ignore create error due to object existence:>no
Import grants>yes
Import table data>yes
Import entire export file>no
Username:........


[root@fws Desktop]# cd /opt
[root@fws opt]# source /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
[root@fws opt]# ls
Disk1                             New Text Document.txt
f101(1).sql                       oracle-xe-11.2.0-1.0.x86_64.rpm
f111(4).sql                       putty.rpm
image.sql                         rh
libaio-0.3.109-5.fc17.x86_64.rpm  SAJIB(1.oct.13).sql
lsnrctl status                    SAJIB.5.oct.13.DMP
lsnrctl status~                   teamviewer_linux.rpm
[root@fws opt]# imp

Import: Release 11.2.0.2.0 - Production on Tue Oct 8 03:51:27 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: system
Password:

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

Import data only (yes/no): no > no

Import file: expdat.dmp > SAJIB.5.oct.13.DMP

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V11.02.00 via conventional path

Warning: the objects were exported by SAJIB, not by you

import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > no

Ignore create error due to object existence (yes/no): no > no

Import grants (yes/no): yes > yes

Import table data (yes/no): yes > yes

Import entire export file (yes/no): no > no
Username: sajib

Enter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done:

. importing SAJIB's objects into SAJIB
. . importing table              "ADD_STOCK_FIBER"          4 rows imported
. . importing table                    "APEX$_ACL"          0 rows imported
. . importing table               "APEX$_WS_FILES"          0 rows imported
. . importing table             "APEX$_WS_HISTORY"          0 rows imported
. . importing table               "APEX$_WS_LINKS"          0 rows imported
. . importing table               "APEX$_WS_NOTES"          0 rows imported
. . importing table                "APEX$_WS_ROWS"          0 rows imported
. . importing table                "APEX$_WS_TAGS"          0 rows imported
. . importing table      "APEX$_WS_WEBPG_SECTIONS"          0 rows imported
. . importing table "APEX$_WS_WEBPG_SECTION_HISTORY"          0 rows imported
. . importing table          "APEX_ACCESS_CONTROL"         42 rows imported
. . importing table            "APEX_ACCESS_SETUP"          2 rows imported
. . importing table                          "BAF"         20 rows imported
. . importing table                          "BZB"         38 rows imported
. . importing table                         "CEPZ"         61 rows imported
. . importing table                          "CGB"         57 rows imported
. . importing table                         "CHKB"         59 rows imported
. . importing table                         "CHMB"          0 rows imported
. . importing table                         "CHWB"          0 rows imported
. . importing table               "DEMO_CUSTOMERS"          7 rows imported
. . importing table                  "DEMO_ORDERS"         10 rows imported
. . importing table             "DEMO_ORDER_ITEMS"         49 rows imported
. . importing table            "DEMO_PRODUCT_INFO"         10 rows imported
. . importing table                  "DEMO_STATES"         51 rows imported
. . importing table                   "DEMO_USERS"          2 rows imported
. . importing table                         "DEPT"          4 rows imported
. . importing table                         "DWHB"         67 rows imported
. . importing table                          "EMP"         14 rows imported
. . importing table                          "FGB"          0 rows imported
. . importing table                          "FWT"         29 rows imported
. . importing table                          "GEC"         71 rows imported
. . importing table                           "HQ"        332 rows imported
. . importing table                         "IMGB"         41 rows imported
. . importing table                         "KEPZ"         26 rows imported
. . importing table                          "KGB"          1 rows imported
. . importing table                          "KSB"         79 rows imported
. . importing table                          "LKB"         35 rows imported
. . importing table                       "MCOURT"          0 rows imported
. . importing table                          "MEB"         31 rows imported
. . importing table                          "MGB"         19 rows imported
. . importing table                          "NGB"         41 rows imported
. . importing table                          "NKB"        146 rows imported
. . importing table                          "PLB"         64 rows imported
. . importing table              "RADIO_LINK_INFO"         49 rows imported
. . importing table                           "SI"          0 rows imported
. . importing table                          "SPB"          1 rows imported
. . importing table                  "STOCK_FIBER"          6 rows imported
. . importing table                  "SWITCH_INFO"         56 rows imported
. . importing table                       "TEST10"          1 rows imported
. . importing table                  "UNIQUE_TEST"          4 rows imported
About to enable constraints...
Import terminated successfully without warnings.
[root@fws opt]#