最近有同事在使用传统的imp工具导入数据时，总是提示收到skipping table的提示，也就是表被跳过，而不是被重建。即使是将目标数据
最近有同事在使用传统的imp工具导入数据时，总是提示收到skipping table的提示，，也就是表被跳过，而不是被重建。即使是将目标数据库上的表对象删除，仍然无法导入。因此记录一下，供大家参考。
1、导入时的skipping table提示
oracle@szdb:~> imp goex_admin/xxx file=sy-trans-20130509-2.dmp log=tmp.log full=y ignore=y show=y
import: release 10.2.0.3.0 - production on fri may 10 10:42:18 2013
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
create table sys_receiving_bank_tbl (bank_id number(12, 0) not null ena
ble, curr_cd char(3) not null enable, e_name varchar2(128) not null ena
ble, is_imp_use_sys_acc_no char(1), display_seq number(2, 0), tc_name
varchar2(128), sc_name varchar2(128), short_desc varchar2(64), bank_g
rp varchar2(128)) pctfree 10 pctused 0 initrans 1 maxtrans 255 storage(in
itial 65536 freelists 1 freelist groups 1 buffer_pool default) tablespace
goex_system_tbl logging nocompress
. . skipping table sys_receiving_bank_tbl
grant select on sys_receiving_bank_tbl to goex_webuser_role
create unique index pk_sys_receiving_bank on sys_receiving_bank_tbl (b
ank_id ) pctfree 10 initrans 2 maxtrans 255 storage(initial 65536 freelis
ts 1 freelist groups 1 buffer_pool default) tablespace goex_system_idx lo
gging
alter table sys_receiving_bank_tbl add constraint pk_sys_receiving_bank
primary key (bank_id) using index pctfree 10 initrans 2 maxtrans 255 st
orage(initial 65536 freelists 1 freelist groups 1 buffer_pool default) tabl
espace goex_system_idx logging enable
comment on column sys_receiving_bank_tbl.bank_id is 'reciving bank id,
different from in bank table
for scb, the bank id must equal to bank table'
comment on column sys_receiving_bank_tbl.curr_cd is 'currency used for
receiving bank'
comment on column sys_receiving_bank_tbl.e_name is 'bank name'
comment on column sys_receiving_bank_tbl.is_imp_use_sys_acc_no is '[no
t used now] y - use system a/c no, first 7 digits for file import'
comment on column sys_receiving_bank_tbl.short_desc is 'store bank cod
e'
comment on column sys_receiving_bank_tbl.bank_grp is 'bank group, to g
roup banks for all currencies'
create table sys_trans_type_tbl (type_cd varchar2(5) not null enable,
desc_en varchar2(64) not null enable, desc_tc varchar2(64) not null enab
le, acc_hist_desc_format_en varchar2(1024), acc_hist_trans_type_en varc
har2(64), daily_stmt_trans_type_en varchar2(64), daily_stmt_desc_format_
en varchar2(1024), daily_stmt_trans_type_tc varchar2(64), daily_stmt_de
sc_format_tc varchar2(1024), monthly_stmt_trans_type_en varchar2(64), m
onthly_stmt_desc_format_en varchar2(1024), monthly_stmt_trans_type_tc va
rchar2(64), monthly_stmt_desc_format_tc varchar2(1024), display_seq num
ber(3, 0), in_ati_entitlement char(1) not null enable, is_display char(
1) not null enable, dr_or_cr_stk_qty char(2), desc_sc varchar2(64), da
ily_stmt_trans_type_sc varchar2(64), daily_stmt_desc_format_sc varchar2(
1024), monthly_stmt_trans_type_sc varchar2(64), monthly_stmt_desc_format
_sc varchar2(1024), has_receiving_bank char(1), short_desc varchar2(64
), is_accounting_use char(1), is_per_acc_type char(1), type_grp varch
ar2(20), desc_accting_std varchar2(128), syn_grp char(1)) pctfree 10 p
ctused 40 initrans 1 maxtrans 255 storage(initial 196608 freelists 1 freeli
st groups 1 buffer_pool default) tablespace goex_users_tbl logging nocomp
ress
alter table sys_trans_type_tbl modify (in_ati_entitlement default 'n'
)
alter table sys_trans_type_tbl modify (is_display default 'y' )
alter table sys_trans_type_tbl modify (has_receiving_bank default 'n')
alter table sys_trans_type_tbl modify (is_accounting_use default 'n')
alter table sys_trans_type_tbl modify (is_per_acc_type default 'n')
. . skipping table sys_trans_type_tbl