Skipping table appears during Oracle imp Import

Recently, when using traditional imp tools to import data, a colleague always prompts to receive the skipping table prompt, that is, the table is skipped, rather than being rebuilt. The table object in the target database cannot be imported even if it is deleted. So record it for your reference.

 

1. Skipping table prompt during import

oracle@SZDB:~> imp goex_admin/xxx file=sy-trans-20130509-2.DMP log=tmp.log full=y ignore=y show=yImport: Release 10.2.0.3.0 - Production on Fri May 10 10:42:18 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to: Oracle Database 10g Release 10.2.0.3.0 - 64bit ProductionExport file created by EXPORT:V10.02.01 via conventional pathimport done in US7ASCII character set and UTF8 NCHAR character setimport 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"                "GRANT SELECT ON "SYS_TRANS_TYPE_TBL" TO "GOEX_WEBUSER_ROLE"" "CREATE INDEX "IN_ATI_ENTITLEMENT_IDX" ON "SYS_TRANS_TYPE_TBL" ("IN_ATI_ENTI" "TLEMENT" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELI" "STS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "GOEX_SYSTEM_IDX" L" "OGGING" "CREATE UNIQUE INDEX "PK_SYS_TRANS_TYPE_TBL" ON "SYS_TRANS_TYPE_TBL" ("TYPE_" "CD" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1" " FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "GOEX_SYSTEM_IDX" LOGGIN" "G" "ALTER TABLE "SYS_TRANS_TYPE_TBL" ADD  CONSTRAINT "PK_SYS_TRANS_TYPE_TBL" PR" "IMARY KEY ("TYPE_CD") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAG" "E(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPA" "CE "GOEX_SYSTEM_IDX" LOGGING ENABLE " "COMMENT ON TABLE "SYS_TRANS_TYPE_TBL" IS  'Store transaction type'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."TYPE_CD" IS  'Transaction type code" "'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DESC_EN" IS  'Description in Eng'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DESC_TC" IS  'Description in TC'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."ACC_HIST_DESC_FORMAT_EN" IS  'A/C h" "istory description format in Eng'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."ACC_HIST_TRANS_TYPE_EN" IS  'A/C hi" "story transaction type in Eng'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_TRANS_TYPE_EN" IS  'Dail" "y statement transaction type in Eng'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_DESC_FORMAT_EN" IS  'Dai" "ly statement description format in Eng'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_TRANS_TYPE_TC" IS  'Dail" "y statement transaction type in T.Chi'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_DESC_FORMAT_TC" IS  'Dai" "ly statement description format in T.Chi'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."MONTHLY_STMT_TRANS_TYPE_EN" IS  'Mo" "nthly statement transaction type in Eng'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."MONTHLY_STMT_DESC_FORMAT_EN" IS  'M" "onthly statement description format in Eng'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."MONTHLY_STMT_TRANS_TYPE_TC" IS  'Mo" "nthly statement transaction type in T.Chi'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."MONTHLY_STMT_DESC_FORMAT_TC" IS  'M" "onthly statement description format in T.Chi'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DISPLAY_SEQ" IS  'Display sequence " "of transactions for a/c history and client statement'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."IN_ATI_ENTITLEMENT" IS  'This type " "will include in ATI Export (Entitlement record section)'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."IS_DISPLAY" IS  'Y : display in scr" "een for selection; N: internal transaction use'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DR_OR_CR_STK_QTY" IS  'Flag indicat" "e whether this type should debit or credit stk qty'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DESC_SC" IS  'Description in SC'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_TRANS_TYPE_SC" IS  'Dail" "y statement transaction type in S.Chi'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DAILY_STMT_DESC_FORMAT_SC" IS  'Dai" "ly statement description format in S.Chi'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."MONTHLY_STMT_TRANS_TYPE_SC" IS  'Mo" "nthly statement transaction type in S.Chi'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."MONTHLY_STMT_DESC_FORMAT_SC" IS  'M" "onthly statement description format in S.Chi'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."HAS_RECEIVING_BANK" IS  'Flag indic" "ates whether relate to a receiving bank'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."SHORT_DESC" IS  'store transaction " "type'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."IS_ACCOUNTING_USE" IS  'For account" "ing, whether used in accounting'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."IS_PER_ACC_TYPE" IS  'Flag indicate" "s whether this type can be grouped per a/c type'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."TYPE_GRP" IS  'Accounting non-trade" " type grouping, used in FSH'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."DESC_ACCTING_STD" IS  'Accounting s" "tandard description, used in FSH'" "COMMENT ON COLUMN "SYS_TRANS_TYPE_TBL"."SYN_GRP" IS  '''C''-Cash; ''S''-Sto" "ck; ''A''-Trade Add; ''X''-Trade Cancel'" "CREATE TABLE "SYS_WITHDRAWAL_BANK_TBL" ("BANK_ID" NUMBER(12, 0) NOT NULL EN" "ABLE, "CURR_CD" CHAR(3) NOT NULL ENABLE, "E_NAME" VARCHAR2(128) NOT NULL EN" "ABLE, "DISPLAY_SEQ" NUMBER(2, 0), "TC_NAME" VARCHAR2(128), "SC_NAME" VARCHA" "R2(128), "SHORT_DESC" VARCHAR2(64), "BANK_GRP" VARCHAR2(128))  PCTFREE 10 P" "CTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIS" "T GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "GOEX_SYSTEM_TBL" LOGGING NOCOMP" "RESS". . skipping table "SYS_WITHDRAWAL_BANK_TBL"           "CREATE UNIQUE INDEX "UNI_SYS_WITHDRAWAL_BANK_TBL" ON "SYS_WITHDRAWAL_BANK_T" "BL" ("BANK_ID" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 " "FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "GOEX_SYSTEM_" "IDX" LOGGING" "COMMENT ON COLUMN "SYS_WITHDRAWAL_BANK_TBL"."BANK_ID" IS  'Withdrawal bank " "id, different from in bank table'" "COMMENT ON COLUMN "SYS_WITHDRAWAL_BANK_TBL"."CURR_CD" IS  'Currency used fo" "r withdrawal bank'" "COMMENT ON COLUMN "SYS_WITHDRAWAL_BANK_TBL"."E_NAME" IS  'Bank Name'" "COMMENT ON COLUMN "SYS_WITHDRAWAL_BANK_TBL"."SHORT_DESC" IS  'store bank co" "de'" "COMMENT ON COLUMN "SYS_WITHDRAWAL_BANK_TBL"."BANK_GRP" IS  'Bank group, to " "group banks for all currencies'"Import terminated successfully without warnings.

2. normal import after the show = y parameter is removed

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-- Blog   : http://blog.csdn.net/robinson_0612Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to: Oracle Database 10g Release 10.2.0.3.0 - 64bit ProductionExport file created by EXPORT:V10.02.01 via conventional pathimport done in US7ASCII character set and UTF8 NCHAR character setimport 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 importedImport terminated successfully without warnings.

3. Help information of IMP

Oracle @ szdb: ~> Imp-helpkeyword description (default) keyword description (default) specify userid username/password full import entire file (n) buffer size of data buffer fromuser list of owner usernamesfile input files (expdat. DMP) touser list of usernamesshow just list file contents (n) Tables List of table namesignore ignore create errors (n) Re Cordlength length of Io recordgrants import grants (y) inctype incremental import typeindexes import indexes (y) Commit commit array insert (n) rows import data rows (y) parfile parameter filenamelog log file of screen output constraints import constraints (y) destroy overwrite tablespace data file (n) indexfile write table/index info to specified file Description: show: when this parameter is set to N, only the content of the dump file is listed. Therefore, if this parameter is set to Y, no object will be imported.. Indexfile: If this parameter is specified, force IMP to generate a script without importing any objects to the database. If you want to import a table, remove this parameter.

4. References
Use of exclude/include in expdp impdp
Use the Oracle DataPump API to export data
Import and Export Oracle Partition Table Data
Use of Data Pump expdp export tool
Use of Data Pump impdp import tool

 

5. More references

For more information about Oracle RAC, see
Use crs_setperm to modify the resource owner and permissions of RAC.
Use crs_profile to manage RAC resource configuration files
RAC database startup and Shutdown
Oracle RAC services
Services in Oracle Database 10g
Migrate datbase from single instance to Oracle RAC
Connect Oracle RAC to a specified instance
Oracle RAC load balancing test (combined with server and client)
Oracle RAC server connection Load Balance)
Load Balance)
Non-Default port listening configuration in Oracle RAC (listener. ora tnsnames. ora)
Oracle RAC Listener Configuration (listener. ora tnsnames. ora)
Configure RAC load balancing and Failover
CRS-1006, CRS-0215 fault case
Installing Oracle 10g RAC Based on Linux (RHEL 5.5)
Use runcluvfy to verify the Oracle RAC installation environment

For more information about the basics and concepts of Oracle network configuration, see:
Configure dynamic service registration for non-default ports
Configure sqlnet. ora to restrict IP Access to Oracle
Configure and manage Oracle listener logs
Set the Oracle listener password (listener)
Configure the Oracle client to connect to the database

For more information about user-managed backup and recovery, see
Oracle cold backup
Oracle Hot Backup
Concept of Oracle backup recovery
Oracle instance recovery
Oracle recovery based on user management
System tablespace management and Backup Recovery
Sysaux tablespace management and recovery
Oracle backup control file recovery (unsing backup controlfile)

For information on RMAN backup recovery and management, see
RMAN overview and architecture
RMAN configuration, Monitoring and Management
Detailed description of RMAN backup
RMAN restoration and recovery
Create and use RMAN catalog
Create RMAN storage script based on catalog
Catalog-based RMAN backup and recovery
RMAN backup path confusion
Use RMAN for recovery from different machine backups (WIN platform)
Use RMAN to migrate a file system database to ASM
Linux RMAN backup shell script
Use RMAN to migrate the database to a different machine

For the Oracle architecture, see
Oracle tablespace and data files
Oracle Password File
Oracle parameter file
Oracle online redo log file)
Oracle Control File)
Oracle archiving logs
Oracle rollback and undo)
Oracle database instance startup and Shutdown Process
Automated Management of Oracle 10g SGA
Oracle instances and Oracle databases (Oracle Architecture)