SQL> select table_name,partition_name from user_tab_partitions where table_name='PDBA';
TABLE_NAME                     PARTITION_NAME
------------------------------ ------------------------------
PDBA                           P1
PDBA                           P2
PDBA                           P3
PDBA                           P4
sql> select count(*) from pdba partition (p1);
count(*)
----------
   1718285
sql> select count(*) from pdba partition (p2);
count(*)
----------
    183667
sql> select count(*) from pdba partition (p3);
count(*)
----------
    188701
sql> select count(*) from pdba partition (p4);
count(*)
----------
    622582

现在分区表已经建好了，但是表名不一样，需要用rename对表重命名一下：
SQL> rename dba to dba_old;
表已重命名。
SQL> rename pdba to dba;
表已重命名。
SQL> select table_name,partition_name from user_tab_partitions where table_name='DBA';
TABLE_NAME                     PARTITION_NAME
------------------------------ ------------------------------
DBA                            P1
DBA                            P2
DBA                            P3
DBA                            P4

ITPub博客

学习之应用基础(7)

最新文章