无题

[oracle@db-oracle-1 log]$ imp

Import: Release 10.2.0.4.0 - Production on Wed Jul 29 19:22:48 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Username: iebd3
Password: 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Import file: expdat.dmp > /home/oracle/oracle_dmp/xspfb_200920101.DMP

Enter insert buffer size (minimum is 8192) 30720> 30720

Export file created by EXPORT:V10.02.01 via conventional path

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

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
import server uses ZHS16CGB231280 character set (possible charset conversion)
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 > ^Z^Z

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

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

. importing ZFXFZB's objects into IEBD3
. importing ZFXFZB's objects into IEBD3
. . importing table              "XSPFB_200920101"    1818492 rows imported
Import terminated successfully without warnings.

  

posted on 2015-07-29 20:26  非要靠才华  阅读(419)  评论(0编辑  收藏  举报

导航