Notes for exporting and importing Oracle database tables

Export

Linux-t9ub :~ # Su-Oracle
Loracle @ linux-t9ub: ~> Ls
Desktop events ents afiedt. Buf DMP expdat. dmp gxda-906261212.dmp log Oracle sh Software
Oracle @ linux-t9ub: ~> CD dmp
Oracle @ linux-t9ub :~ /DMP> ls
Gx090624.dmp gx0906260900.dmp gx090628.dmp gx090630.dmp gx090703.dmp gx090705.tar.gz gx090708.dmp gx70090619.dmp
Gx090625.dmp gx090627.dmp gx090629.dmp gx090701.dmp gx090704.dmp gx090706.dmp gx090709.dmp sys090629.dmp
Gx090626.dmp gx0906271400.dmp gx090629.tar.gz gx090702.dmp gx090705.dmp gx090707.dmp gxda-906260035.dmp sys090706.dmp
Oracle @ linux-t9ub :~ /DMP> pwd
/Oracle/dmp
Oracle @ linux-t9ub :~ /DMP>Exp GX/GX file = expdat_jzwx.dmp tables = sjy_dat_sn_jzwx_jzwx grants = y;

Note: export all tables. Available: exp gx/GX file = expdat_jzwx.dmp grants = y;

Export: Release 10.2.0.1.0-production on Friday July 10 11:07:35 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options
The zhs16gbk and al16utf16 nchar character sets have been exported.

To export the specified table through the regular path...
.. Export table sjy_dat_sn_jzwx_jzwx export 1240 rows
The export is successfully terminated without a warning.
Oracle @ linux-t9ub :~ /DMP>

Import

[root @ localhost ~] # Su-Oracle
-Bash-3.00 $ ls
createdata. sh expdatgx_70_20090115.dmp flash_recovery_area
admin expdatgx_70_20090121.dmp gx_88_090526.log
afiedt. buf expdatgx_70_20090203.dmp insertdata. SQL
arhiva release log
DMP release lost + found
too old
expdatgx20081202.dmp release orainventory
expdatgx20081219.dmp release Oracle
using Oracle Data
BR> commandid sh
commandid sjy_create_tables. SQL
expdatgx_70_20090105.dmp expdatgx_70_20090322.dmp
-Bash-3.00 $ Cd DMP
-Bash-3.00 $ sqlplus GX/GX

SQL * Plus: Release 10.2.0.1.0-production on Fri Jul 10 11:24:44 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options

SQL> drop table sjy_dat_sn_jzwx_jzwx;

Table dropped.

SQL>Exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options
-Bash-3.00 $IMPGX/GX file = expdat_jzwx.dmp grants = y;

Note: The full = y parameter is required to import the entire DMP file.

Import: Release 10.2.0.1.0-production on Fri Jul 10 11:26:30 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options

Export File Created by export: v10.02.01 via conventional path
Import done in us7ascii Character Set and al16utf16 nchar Character Set
Import server uses zhs16gbk character set (possible charset conversion)
Export client uses zhs16gbk character set (possible charset conversion)
. Importing GX's objects into GX
. Importing GX's objects into GX
.. Importing table "sjy_dat_sn_jzwx_jzwx" 1240 rows imported
Import terminated successfully without warnings.