oracle sy imp,Oracle imp导入时出现skipping table

2、移除参数show=y后正常导入

Oracle@SZDB:~> imp goex_admin/xxx file=sy-trans-20130509-2.DMP log=tmp.log rows=y full=y ignore=y

Import: Release 10.2.0.3.0 - Production on Fri May 10 12:02:29 2013

-- Author : Robinson

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

Connected to: Oracle Database 10g Release 10.2.0.3.0 - 64bit Production

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

import done in US7ASCII character set and UTF8 NCHAR character set

import server uses UTF8 character set (possible charset conversion)

export client uses ZHT16BIG5 character set (possible charset conversion)

. importing GOEX_ADMIN's objects into GOEX_ADMIN

. importing GOEX_ADMIN's objects into GOEX_ADMIN

. . importing table      "SYS_RECEIVING_BANK_TBL"        117 rows imported

. . importing table          "SYS_TRANS_TYPE_TBL"        134 rows imported

. . importing table      "SYS_WITHDRAWAL_BANK_TBL"        34 rows imported

Import terminated successfully without warnings.

3、imp的帮助信息

oracle@SZDB:~> imp -help

Keyword  Description (Default)      Keyword      Description (Default)

--------------------------------------------------------------------------

USERID  username/password          FULL        import entire file (N)

BUFFER  size of data buffer        FROMUSER    list of owner usernames

FILE    input files (EXPDAT.DMP)    TOUSER      list of usernames

SHOW    just list file contents (N) TABLES      list of table names

IGNORE  ignore create errors (N)    RECORDLENGTH length of IO record

GRANTS  import grants (Y)          INCTYPE      incremental import type

INDEXES  import indexes (Y)          COMMIT      commit array insert (N)

ROWS    import data rows (Y)        PARFILE      parameter filename

LOG      log file of screen output  CONSTRAINTS  import constraints (Y)

DESTROY                overwrite tablespace data file (N)

INDEXFILE              write table/index info to specified file

说明：

SHOW：该参数为N的时候是仅仅列出dump文件的内容，因此当指定为Y的时候不会导入任何对象。

INDEXFILE：如果指定了该参数则强制imp产生一个脚本，而不会导入任何对象到数据库。如果想要导入表时，移除该参数。