表分区问题 ORA-02149: Specified partition does not exist
来源:互联网 发布:库存盘点软件 编辑:程序博客网 时间:2024/04/29 22:17
1.
第一次接触表分区,做了些练习,遇到一个超级恶心的问题。
--查看某个表的表分区
select TABLESPACE_NAME,partition_name, High_value from user_tab_partitions where
table_name='TEST';
--表分区定义
select dbms_metadata.get_ddl('TABLE','TEST','DBUSER') from dual;
--添加表分区
alter table TEST add
PARTITION "PAR_201608" VALUES LESS THAN (201608)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "BS_TS_REPORTS" NOCOMPRESS
以上为增加表分区的过程。
查看修改后的表分区
select TABLESPACE_NAME,partition_name, High_value from user_tab_partitions where
table_name='TEST';
BS_TS_REPORTS acct_one_prestore_201608 201608
BS_TS_REPORTS acct_one_prestore_201609 201609
BS_TS_REPORTS ACCT_ONE_PRESTORE_201201 201202
BS_TS_REPORTS ACCT_ONE_PRESTORE_201111 201112
发现成小写了,想到删了重建
alter table BS_TB_RPT_ACCT_ONE_PRESTORE truncate partition acct_one_prestore_201608
*
ERROR at line 1:
ORA-02149: Specified partition does not exist
TMD 一直报不存在,真是日了狗了
最后发现分区这货,不仅区分大小写,而且把引号也给加了进去。
alter table BS_TB_RPT_ACCT_ONE_PRESTORE drop partition "acct_one_prestore_201608";
Table altered.
终于修成正果。。。。。。。。
- 表分区问题 ORA-02149: Specified partition does not exist
- ORA-29807: specified operator does not exist
- The user specified as a definer (''@'%') does not exist问题
- The specified JRE installation does not exist
- The specified JRE installation does not exist
- The specified JRE installation does not exist
- The specified JRE installation does not exist
- specified for property 'resourceFile' does not exist
- Specified web-root folder does not exist
- The specified JRE installation does not exist
- The specified JRE installation does not exist
- 解决ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist的问题
- Hibernate: ORA-02289: sequence does not exist
- ORA-00959: tablespace 'PSAPTEMP' does not exist
- ORA-00959: tablespace '' does not exist
- ORA-01919: role 'PLUSTRACE' does not exist
- ORA-04043 object DROP_AW_ELIST_ALL does not exist
- mySql问题:The user specified as a definer ('root'@'%') does not exist 解决方法
- java多线程 信号量(Semaphore),死锁
- 【Linux4.1.12源码分析】协议栈报文接收之IP层处理分析(ip_forward)
- 第九周项目1-猴子选大王(数组版)
- Graphics View Framework之坦克大战(二)
- openWRT的ipk编译方法
- 表分区问题 ORA-02149: Specified partition does not exist
- USACO 提交测试
- android:layout_gravity 和 android:gravity 的区别及LinearLayout何时生效
- 51nod 1005 大数加法
- 一些不错的软件测试学习网站
- mysql创建用户并远程访问
- [GPIO] FireWRT-GPIO之按键----1
- java栈和堆(1)摘自别人的
- 浅析深究什么是SOA?