SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
UNDOTBS2 ONLINE
EXAMPLE ONLINE
TEST ONLINE
SALES_TEST ONLINE
9 rows selected
7.在目标数据库上执行导入操作
[oracle@jytest1 tts]$ impdp system/xxzx7817600@JYPDB_175 dumpfile=sales_test.dmp directory=tts_dump transport_datafiles='+data/jy/4B2C6373AE2547CCE053AB828A0A7CA3/datafile/sales_test_01.dbf' tables=sh.sales_test:sales_test_q1_2000,sh.sales_test:sales_test_q2_2000 logfile=imp_sales_test.log
Import: Release 12.2.0.1.0 - Production on Tue Jun 6 19:23:09 2017
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
Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/********@JYPDB_175 dumpfile=sales_test.dmp directory=tts_dump transport_datafiles=+data/jy/4B2C6373AE2547CCE053AB828A0A7CA3/datafile/sales_test_01.dbf tables=sh.sales_test:sales_test_q1_2000,sh.sales_test:sales_test_q2_2000 logfile=imp_sales_test.log
Processing object type TABLE_EXPORT/TABLE/PLUGTS_BLK
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/END_PLUGTS_BLK
Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 13 error(s) at Tue Jun 6 19:25:06 2017 elapsed 0 00:01:46
SQL> select owner,table_name,tablespace_name from dba_tables where owner='SH';
OWNER TABLE_NAME TABLESPACE_NAME
-------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------
SH SALES_TEST_SALES_TEST_Q1_2000 SALES_TEST
SH SALES_TEST_SALES_TEST_Q2_2000 SALES_TEST
SH SALES_TRANSACTIONS_EXT
SH COSTS
SH SALES
SH CAL_MONTH_SALES_MV EXAMPLE
SH FWEEK_PSCAT_SALES_MV EXAMPLE
SH DIMENSION_EXCEPTIONS EXAMPLE
SH SUPPLEMENTARY_DEMOGRAPHICS EXAMPLE
SH COUNTRIES EXAMPLE
SH CUSTOMERS EXAMPLE
SH PROMOTIONS EXAMPLE
SH PRODUCTS EXAMPLE
SH TIMES EXAMPLE
SH CHANNELS EXAMPLE
可以看到分区sales_test_q1_2000与sale_test_q2_2000导入后分别成为了一张非分区表