Oracle EXPDP-仅表且仅某些模式

嗨
我想从一个数据库进行datapupm导出，然后将datapump导入回另一个数据库。
我只想导出表，并且只导出属于两个用户的表-说USER1，USER2

所以我计划用以下参数做一个EXPDP

expdp ....INCLUDE = TABLE，SCHEMA: “IN ('user1'，'user2')



文件在
https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_import.htm#i1007761
表示查询架构模式的视图SCHEMA_EXPORT_OBJECTS。不知道这意味着什么-但是有一个带有OBJECT_PATH = 表的行-所以期望

但是，expdp的其他文档-请参阅https://oracle-base.com/articles/10g/oracle-data-pump-10g#IncludeExclude
似乎表明您可以包含 = TABLE_DATA

那么，我应该指定TABLE_DATA还是TABLE？

谢谢

抱歉，在Tim的大多数示例中，我看到对 “INCLUDE = TABLE” 的引用，而不是TABLE_DATA

例如

x.par
=====
dumpfile=blah
directory=TEMP
full=y
INCLUDE=TABLE, SCHEMA:"IN('SCOTT','HR')"

C:\>expdp userid=mcdonac/***** parfile=x.par

Export: Release 12.2.0.1.0 - Production on Tue Feb 27 11:17:04 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "MCDONAC"."SYS_EXPORT_FULL_01":  userid=mcdonac/******** parfile=c:\temp\x.par
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/AUDIT_OBJ
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/JAVA_SOURCE
Processing object type DATABASE_EXPORT/SCHEMA/JAVA_CLASS/JAVA_CLASS
Processing object type DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/JAVA_RESOURCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
. . exported "SCOTT"."SYS_EXPORT_SCHEMA_02"              655.3 KB    1714 rows
. . exported "SCOTT"."SYS_EXPORT_SCHEMA_01"              455.0 KB    1677 rows
. . exported "HR"."EMPLOYEES"                            17.08 KB     107 rows
. . exported "SCOTT"."EMP$"                              8.796 KB      15 rows
. . exported "SCOTT"."BLAH"                              8.773 KB      14 rows
. . exported "SCOTT"."EMP"                               8.781 KB      14 rows
. . exported "SCOTT"."EMP2"                              8.789 KB      14 rows
. . exported "HR"."LOCATIONS"                            8.437 KB      23 rows
. . exported "HR"."JOB_HISTORY"                          7.195 KB      10 rows
. . exported "HR"."JOBS"                                 7.109 KB      19 rows
. . exported "HR"."DEPARTMENTS"                          7.125 KB      27 rows
. . exported "HR"."COUNTRIES"                            6.367 KB      25 rows
. . exported "SCOTT"."SALGRADE"                          6.023 KB      10 rows
. . exported "SCOTT"."DEPT"                              6.023 KB       4 rows
. . exported "HR"."REGIONS"                              5.546 KB       4 rows
. . exported "SCOTT"."BONUS"                                 0 KB       0 rows
. . exported "SCOTT"."CREATE$JAVA$LOB$TABLE"                 0 KB       0 rows
Master table "MCDONAC"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for MCDONAC.SYS_EXPORT_FULL_01 is:
  C:\TEMP\BLAH.DMP
Job "MCDONAC"."SYS_EXPORT_FULL_01" successfully completed at Tue Feb 27 11:18:52 2018 elapsed 0 00:01:48