I am trying to import 1 partition of a partitioned table with datapump, but it is importing all of the partitions. Whay is that?
datapump version is Import: Release 11.2.0.3.0
Import into Oracle
Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Datapump command:
impdp impusr/psswrd \
DUMPFILE=table_a.dmp \
REMAP_SCHEMA=user_a:user_b \
TABLES=USER_A.TABLE_A:P_TAB_EXT_INT_01 \
SKIP_UNUSABLE_INDEXES=Y \
PARTITION_OPTIONS=none \
DIRECTORY=BACKUP \
logfile=impdp_table_a.log
select
TABLE_NAME,PARTITION_NAME,SUBPARTITION_COUNT sub_count, high_value from
user_tab_partitions
TABLE_NAME PARTITION_NAME SUB_COUNT HIGH_VALUE
---------- -------------- ---------- ----------------------------
TABLE_A SYS_P58015 2 2014-06-28 00:00:00',
TABLE_A SYS_P57766 2 2014-06-27 00:00:00',
TABLE_A SYS_P57337 2 2014-06-25 00:00:00',
TABLE_A SYS_P56967 2 2014-06-24 00:00:00',
TABLE_A SYS_P56729 2 2014-06-14 00:00:00',
TABLE_A SYS_P56413 2 2014-06-11 00:00:00',
TABLE_A SYS_P54568 2 2014-05-17 00:00:00',
TABLE_A SYS_P52586 2 2014-05-03 00:00:00',
TABLE_A SYS_P49372 2 2014-04-10 00:00:00',
TABLE_A SYS_P46729 2 2014-03-20 00:00:00',
TABLE_A SYS_P40751 2 2014-07-22 00:00:00',
TABLE_A SYS_P40649 2 2014-07-10 00:00:00',
TABLE_A SYS_P39719 2 2014-03-14 00:00:00',
TABLE_A SYS_P39247 2 2013-04-02 00:00:00',
TABLE_A SYS_P39133 2 2014-03-13 00:00:00',
TABLE_A SYS_P32434 2 2100-01-01 00:00:00',
TABLE_A P_TAB_EXT_INT_01 2 2010-11-01 00:00:00',
17 rows
selected.
Export
Logfile output from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -
64bit Production
. . exported
"USER_A"."TABLE_A":"P_TAB_EXT_INT_01"."P_TAB_EXT_INT_01_SP1" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"P_TAB_EXT_INT_01"."P_TAB_EXT_INT_01_SP2" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P32434"."SYS_SUBP32432" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P32434"."SYS_SUBP32433" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P39133"."SYS_SUBP39131" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P39133"."SYS_SUBP39132" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P39247"."SYS_SUBP39245" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P39247"."SYS_SUBP39246" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P39719"."SYS_SUBP39717" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P39719"."SYS_SUBP39718" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P40649"."SYS_SUBP40647" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P40649"."SYS_SUBP40648" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P40751"."SYS_SUBP40749" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P40751"."SYS_SUBP40750" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P46729"."SYS_SUBP46727" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P46729"."SYS_SUBP46728" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P49372"."SYS_SUBP49370" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P49372"."SYS_SUBP49371" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P52586"."SYS_SUBP52584" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P52586"."SYS_SUBP52585" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P54568"."SYS_SUBP54566" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P54568"."SYS_SUBP54567" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P56413"."SYS_SUBP56411" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P56413"."SYS_SUBP56412" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P56729"."SYS_SUBP56727" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P56729"."SYS_SUBP56728" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P56967"."SYS_SUBP56965" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P56967"."SYS_SUBP56966" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P57337"."SYS_SUBP57335" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P57337"."SYS_SUBP57336" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P57766"."SYS_SUBP57764" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P57766"."SYS_SUBP57765" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P58015"."SYS_SUBP58013" 0 KB 0 rows
. . exported
"USER_A"."TABLE_A":"SYS_P58015"."SYS_SUBP58014" 0 KB 0 rows