首页 > 数据库技术 > 详细

[Oracle][Partition][Controlfile]Partition 操作是否和 Controlfile有关?

时间:2017-10-04 13:24:38      阅读:250      评论:0      收藏:0      [点我收藏+]

Partition 操作是否和 Controlfile有关?

通过实验来判断:

对比 Partition 前后的操作,看看controlfile 的dump 信息中是否有记录,
结果发现没有记录在 controlfile 中的信息。

#### Testcase-0810-1

Operations related to partition are not recorded in the control file

It is connected.
SQL> CREATE TABLE book1 (id NUMBER, val01 integer, val02 integer, val03 integer)
PARTITION BY RANGE (val 01)
(PARTITION book 1 p 1 VALUES LESS THAN (100),
PARTITION book 1 p 2 VALUES LESS THAN (200),
PARTITION book 1 p 3 VALUES LESS THAN (300)); 2 3 4 5

SQL> oradebug setmypid
The statement has been processed.

SQL> oradebug tracefile_name
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_32505.trc
SQL>
SQL> oradebug dump controlf 5
The statement has been processed.
SQL>

[oracle @ dhcp - cn - 10 - 182 - 210 - 9 ~] $ cat / u 01 /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_32505.trc | grep partition
[oracle @ dhcp - cn - 10 - 182 - 210 - 9 ~] $
[oracle @ dhcp - cn - 10 - 182 - 210 - 9 ~] $
grep "PARTITION"
[oracle @ dhcp - cn - 10 - 182 - 210 - 9 ~] $

SQL> alter table book1 add partition p4 values ??less than (400);

The table has been changed.

SQL> alter table book 1 drop partition book 1 p 1;

The table has been changed.

SQL> oradebug dump controlf 5
The statement has been processed.
SQL>

grep "PARTITION"
[oracle @ dhcp - cn - 10 - 182 - 210 - 9 ~] $
[oracle @ dhcp - cn - 10 - 182 - 210 - 9 ~] $
[oracle @ dhcp - cn - 10 - 182 - 210 - 9 ~] $ cat / u 01 /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_32505.trc | grep partition

[Oracle][Partition][Controlfile]Partition 操作是否和 Controlfile有关?

原文:http://www.cnblogs.com/gaojian/p/7625489.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!