oracle分区表分区导出,Oracle分区表单个分区导入导出实验

1、创建测试分区表

create table scott.ptest (owner,object_name, created) partition by range (created)

(partition p1 values less than (to_date('2018-11-25', 'yyyy-mm-dd')),

partition p2 values less than (maxvalue))

as select owner,object_name,created from dba_objects;

2、查看各分区数据是否正确

select table_name, partition_name from dba_tab_partitions where table_name = 'PTEST';

TABLE_NAME PARTITION_NAME

------------------------------ ------------------------------

PTEST P1

PTEST P2

3、创建本地索引

create index ptest_local_idx

on scott.ptest(created)

local

(partition local1,

partition local2);

4、创建数据泵所需目录

oracle用户下：

cd $ORACLE_HOME

mkdir dump

sqlplus：

create or replace directory dump as '/oracle/app/oracle/product/11.2.0.4/dbhome_1/rdbms/log