oracle only_data,expdp/impdp中metadata/data_only導入順序的影響、區別

1、先導入metadata,再導入data_only，此時，在導data_only時，會檢查表的相關約束、triger關系

Metadata導入時，對象按以下的順序：

D:\db_dump>impdp cadcam/flyer DIRECTORY=EXPDP_DIR CONTENT=metadata_only logfile=

wtadmin_order_tb_main.log DUMPFILE=wtadmin_order_tb_main.dmp TABLES=wtadmin.ORDE

R_TB_MAIN

Import: Release 10.2.0.5.0 - Production on星期三, 16 2月, 2011 18:19:45

Copyright (c) 2003, 2007, Oracle.All rights reserved.

連線至: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

已順利載入/取消載入主要表格"CADCAM"."SYS_IMPORT_TABLE_02"

啟動"CADCAM"."SYS_IMPORT_TABLE_02":cadcam/******** DIRECTORY=EXPDP_DIR CONTEN

T=metadata_only logfile=wtadmin_order_tb_main.log DUMPFILE=wtadmin_order_tb_main

.dmp TABLES=w