title: Oracle imp dmp file, create table statements skipped
body: <p>I get a dmp and install a Oracle XE for developing. However, when I use imp to import, the create table statements were skipped. Can anyone kindly help on the issue.</p>
  
  <p>The screen output were captured as follow: Many Thanks!</p>
  
  <hr>
  
  <pre><code>C:\Documents and Settings\wong\Desktop&gt;imp
  
  Import: Release 10.2.0.1.0 - Production on Mon Aug 2 22:48:32 2010
  
  Copyright (c) 1982, 2005, Oracle.  All rights reserved.
  
  Username: report 
  </code></pre>
  
  <p>Password:</p>
  
  <pre><code>Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio n
  
  Import file: EXPDAT.DMP &gt; report20100524.dmp
  
  Enter insert buffer size (minimum is 8192) 30720&gt; 30720
  
  Export file created by EXPORT:V10.01.00 via conventional path import done in ZHS16GBK character set and AL16UTF16 NCHAR character set import server uses WE8MSWIN1252 character set (possible charset conversion) List contents of import file only (yes/no): no &gt; yes
  
  Import entire export file (yes/no): no
  &gt; yes
  
  . importing REPORT's objects into REPORT  "BEGIN  "  "sys.dbms_logrep_imp.instantiate_schema(schema_name=&gt;'REPORT', export_db_na"  "me=&gt;'SPACESAT', inst_scn=&gt;'650909');"  "COMMIT; END;"  "CREATE TABLE "BASE_COUNTRY" ("IN_CODE" VARCHAR2(60) NOT NULL ENABLE, "OUTCO"  "DE" VARCHAR2(60), "OUTNAME" VARCHAR2(60), "LEVELID" NUMBER(1, 0), "IS_LEAF""  " NUMBER(1, 0), "SX" VARCHAR2(10), "PHONE" VARCHAR2(20), "TIMEX" NUMBER(2, 0"  "))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FRE"  "ELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING "  "NOCOMPRESS" . . skipping table "BASE_COUNTRY"
  
  
  .... many tables skipped...
  
  
  "CREATE UNIQUE INDEX "XF_TC_FLOOR_U1" ON "XF_TC_FLOOR" ("XF_FLOOR" , "XF_GSI" "D" )  PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 " "FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING" "CREATE TRIGGER "YREPORT".xf_tc_floor_insupd BEFORE INSERT OR UPDATE" "  ON xf_tc_floor" " FOR EACH ROW" "  BEGIN" "    :new.xf_lastmodtime := sysdate;" "    :new.xf_lastuploadtime := sysdate;" "  END xf_tc_floor_insupd" ";" "ALTER TRIGGER "XF_TC_FLOOR_INSUPD"  ENABLE" mport terminated successfully without warnings.
  
  C:\Documents and Settings\wong\Desktop&gt;
  </code></pre>