经查看导出的dmp文件,说明导出的这些表之间的约束关系也导出来了
-bash-3.2$ strings exp_pd_moretable.dmp|tail -100f
ENDTABLE
TABLE "R_RESOURCEINFO"
ALTER TABLE "R_RESOURCEINFO" ADD CONSTRAINT "FK_R_RESOUR_REFERENCE_R_RESOUS" FOREIGN KEY ("LEVELID") REFERENCES "R_RESOUSELEVELINFO" ("LEVELID") ENABLE NOVALIDATE
ENDTABLE
TABLE "R_RESOURCEINFO"
ALTER TABLE "R_RESOURCEINFO" ADD CONSTRAINT "FK_R_RESOUR_REFERENCE_C_KNOWLE" FOREIGN KEY ("KNOWLEDGEID") REFERENCES "C_KNOWLEDGE_INFO" ("KNOWLEDGE_ID") ENABLE NOVALIDATE
ENDTABLE
TABLE "R_RESOURCEINFO"
ALTER TABLE "R_RESOURCEINFO" ADD CONSTRAINT "FK_R_RESOUR_REF" FOREIGN KEY ("CONTENTID") REFERENCES "R_RESOURCECONTENT" ("CONTENTID") ENABLE NOVALIDATE
ENDTABLE
METRICET 35
METRICST
METRICET 35
METRICST
METRICET 35
METRICST
METRICET 35
METRICSTPost-inst procedural actions
METRICET 35
METRICST
TABLE "R_RESOURCE_EXT"
ALTER TABLE "R_RESOURCE_EXT" ADD CONSTRAINT "FK_R_RESOUR_REFY" FOREIGN KEY ("RESOURCEID") REFERENCES "R_RESOURCEINFO" ("RESOURCEID") ENABLE NOVALIDATE
ENDTABLE
METRICET 36
METRICST
METRICET 36
METRICST
METRICET 36
METRICST
METRICET 36
METRICSTPost-inst procedural actions
METRICET 36
METRICST
TABLE "R_RESOUCETYPEMAPPING"
ALTER TABLE "R_RESOUCETYPEMAPPING" ADD CONSTRAINT "FK_R_RESOUC_REFERENCE_R_RESOUR" FOREIGN KEY ("RESOURCEID") REFERENCES "R_RESOURCEINFO" ("RESOURCEID") ENABLE NOVALIDATE
####看看下面,INDEX索引也导出了
-bash-3.2$ strings exp_pd_moretable.dmp|tail -1002222220f|grep INDEX
CREATE UNIQUE INDEX "PK_R_RESOURCECONTENT" ON "R_RESOURCECONTENT" ("CONTENTID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING
BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PK_R_RESOURCECONTENT"',NULL,NULL,NULL,7,1,7,1,1,6,0,6); END;
ALTER TABLE "R_RESOURCECONTENT" ADD CONSTRAINT "PK_R_RESOURCECONTENT" PRIMARY KEY ("CONTENTID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING ENABLE
CREATE UNIQUE INDEX "PK_R_RESOURCEINFO" ON "R_RESOURCEINFO" ("RESOURCEID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING
BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PK_R_RESOURCEINFO"',NULL,NULL,NULL,116,1,116,1,1,5,0,6); END;
ALTER TABLE "R_RESOURCEINFO" ADD CONSTRAINT "PK_R_RESOURCEINFO" PRIMARY KEY ("RESOURCEID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING ENABLE
CREATE UNIQUE INDEX "PK_R_RESOURCE_EXT" ON "R_RESOURCE_EXT" ("EXT_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING
BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PK_R_RESOURCE_EXT"',NULL,NULL,NULL,117,1,117,1,1,14,0,6); END;
ALTER TABLE "R_RESOURCE_EXT" ADD CONSTRAINT "PK_R_RESOURCE_EXT" PRIMARY KEY ("EXT_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING ENABLE
CREATE UNIQUE INDEX "PK_R_RESOUCETYPEMAPPING" ON "R_RESOUCETYPEMAPPING" ("MAPPINGID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING
BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PK_R_RESOUCETYPEMAPPING"',NULL,NULL,NULL,17,1,17,1,1,14,0,6); END;
ALTER TABLE "R_RESOUCETYPEMAPPING" ADD CONSTRAINT "PK_R_RESOUCETYPEMAPPING" PRIMARY KEY ("MAPPINGID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING ENABLE
CREATE UNIQUE INDEX "PK_R_RESOURCE_MODE_MAPPING" ON "R_RESOURCE_MODE_MAPPING" ("MAPPING_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING
BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PK_R_RESOURCE_MODE_MAPPING"',NULL,NULL,NULL,16,1,16,1,1,11,0,6); END;
ALTER TABLE "R_RESOURCE_MODE_MAPPING" ADD CONSTRAINT "PK_R_RESOURCE_MODE_MAPPING" PRIMARY KEY ("MAPPING_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TONGYIHUA" LOGGING ENABLE