12:31:47 SQL> SET PAGESIZE 100
12:31:47 SQL>
12:31:47 SQL> alter table &base_table add partition &partition_prefix.P100
12:31:47 2 /
old 1: alter table &base_table add partition &partition_prefix.P100
new 1: alter table po_tab add partition PART1_P100
alter table po_tab add partition PART1_P100
*
ERROR at line 1:
ORA-14501: object is not partitioned
Elapsed: 00:00:00.03
12:31:47 SQL>
12:31:47 SQL> alter table &base_table add partition &partition_prefix.P101
12:31:47 2 /
old 1: alter table &base_table add partition &partition_prefix.P101
new 1: alter table po_tab add partition PART1_P101
alter table po_tab add partition PART1_P101
*
ERROR at line 1:
ORA-14501: object is not partitioned
请问为何不能对表po_tab
进行分区呢?
谢谢
12:31:47 SQL>
12:31:47 SQL> alter table &base_table add partition &partition_prefix.P100
12:31:47 2 /
old 1: alter table &base_table add partition &partition_prefix.P100
new 1: alter table po_tab add partition PART1_P100
alter table po_tab add partition PART1_P100
*
ERROR at line 1:
ORA-14501: object is not partitioned
Elapsed: 00:00:00.03
12:31:47 SQL>
12:31:47 SQL> alter table &base_table add partition &partition_prefix.P101
12:31:47 2 /
old 1: alter table &base_table add partition &partition_prefix.P101
new 1: alter table po_tab add partition PART1_P101
alter table po_tab add partition PART1_P101
*
ERROR at line 1:
ORA-14501: object is not partitioned
请问为何不能对表po_tab
进行分区呢?
谢谢
解决方案 »
- 关于Oracle触发器的:new.列名
- oracle10g问题
- oracle Fatal NI connect error 12170.错误
- 问一条一小时执行一次的存储过程!
- plsql developer 附带的Explain plan window中的cardinality bytes cost具体是什么含义?
- 请教数据库恢复的问题
- 要写oracle分析报告,可是很多概念都不知道,结果也不能出来.
- 救命,我实在想不好,如何设计一个社团活动小系统数据库
- 登录到ORACLE MANAGER SRRVRE??
- 如何备份一张表?(知道的话请您告诉我)
- 数据转移问题
- 制作一个WEB的报表,何种方法效率最高?
例如:
alter table guestbook add partition g_2001q3
values less than (to_date('2001-10-01','yyyy-mm-dd')
object is not partitioned
Cause: Table or index is not partitioned. Invalid syntax.
Action: Retry the command with correct syntax.