ORA-14501: object is not partitioned
来源:互联网 发布:媳妇当车模 知乎 编辑:程序博客网 时间:2024/05/18 03:48
ORA-14501: object is not partitioned
alter table tap_test add partition tap_test0
values less than (TO_DATE(' 2014-08-16 00:00:00', 'YYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) tablespace TESTDBS1;
提示ORA-14501: object is not partitioned对象未分区。
解决办法 :把tap_test表变成分区表:
1、新建新表tap_test为分区表
-- Create table
create table tap_test2
(
INT_ID INTEGER,
VENDOR_ID INTEGER,
SCAN_START_TIME DATE,
SINRUL_00 INTEGER,
SINRUL_01 INTEGER,
SINRUL_02 INTEGER
)
partition by range (SCAN_START_TIME)
(
partition tap_test0 values less than (TO_DATE(' 2014-06-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace testdba1
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
),
partition tap_test1 values less than (TO_DATE(' 2014-10-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace testdba2
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
)
);
2、往新建插入数据
insert into tap_test2 select * from tap_test;
commit;
3、删掉旧表,重命名新表
drop table tap_test;--删除旧表;
rename tap_test2 to tap_test;新表重命名。
4、查询是否分区表
SELECT * FROM USER_TAB_PARTITIONS WHERE TABLE_NAME = ‘TAP_TEST’ ;注意表名要大写。
- ORA-14501: object is not partitioned
- ORA-14501: object is not partitioned ORA-06512: at "KPI.P_KPI_M_2G_WASRATE_GRID", line 54
- ORA-01502& ORA-14086: a partitioned index may not be rebuilt as a whole
- ORA-01034: ORACLE not available 、ora-00064:object is too large to allocate on this O/S
- 'classobj' object is not iterable ?
- object is not a function
- str' object is not callable
- object is not afunction错误
- 'NoneType' object is not iterable
- python object is not iterable
- 'dict' object is not callable
- 'module' object is not callable
- “'WebElement' object is not iterable”
- ORA-04043 object DROP_AW_ELIST_ALL does not exist
- ORA-28365: wallet is not open
- ORA-39213: Metadata processing is not available
- ORA-30553: The function is not deterministic
- ORA-38709: Recovery Area is not enabled.
- ARM开发板上iconv_open(“utf-8", "gb2312”) 调用失败的解决方法
- Nignx和Apache的简单比较
- Gabor 变换详解
- jffs2文件系统删除文件不释放空间
- 如何提高java技能
- ORA-14501: object is not partitioned
- SQL点滴5—产生时间demention,主要是时间转换
- 数组和内存控制
- INT类型位数的理解
- jQuery animate方法开发极客标签Logo动画融合效果
- AlertDialog对话框的使用
- sqoop源码编译
- Set Matrix Zeroes
- Singleton模式目前看到的最好的文章