exp_导出用户多个表与多个表的索引|约束

经查看导出的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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-668589/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-668589/