oracle导出用户所有表和索引,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