ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
来源:互联网 发布:成本数据分析 编辑:程序博客网 时间:2024/05/04 19:38
11g Release 2 (11.2)
尝试解决如下步骤:
1.表中字段类型更改
a order_date TIMESTAMP
创建成功
b order_date date
创建成功
2. PARTITION value 类型更改
a VALUES LESS THAN (TO_DATE('2016-06-01','YYYY-MM-DD'))
创建失败
b VALUES LESS THAN (timestamp'2016-06-01 00:00:00.000000')
创建失败
c VALUES LESS THAN (timestamp('2016-06-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'))
创建失败
d VALUES LESS THAN (cast(to_date('2016-07-01','yyyy-mm-dd') as timestamp))
创建失败
e VALUES LESS THAN (TO_TIMESTAMP_TZ('2016-06-01 00:12:56.788 -12:44', 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'))
创建成功
以上为运行结果。
下面是参数信息,在下面两台数据库中测试,以上运行结果都相同。
NLS_LANGUAGE=SIMPLIFIED CHINESE
NLS_TERRITORY=CHINA
NLS_LANGUAGE=AMERICAN
NLS_TERRITORY=AMERICA
Example 4-9 Creating reference-partitioned tables
CREATE TABLE orders ( order_id NUMBER(12), order_date TIMESTAMP WITH LOCAL TIME ZONE, order_mode VARCHAR2(8), customer_id NUMBER(6), order_status NUMBER(2), order_total NUMBER(8,2), sales_rep_id NUMBER(6), promotion_id NUMBER(6), CONSTRAINT orders_pk PRIMARY KEY(order_id) ) PARTITION BY RANGE(order_date) ( PARTITION Q1_2005 VALUES LESS THAN (TO_DATE('01-APR-2005','DD-MON-YYYY')), PARTITION Q2_2005 VALUES LESS THAN (TO_DATE('01-JUL-2005','DD-MON-YYYY')), PARTITION Q3_2005 VALUES LESS THAN (TO_DATE('01-OCT-2005','DD-MON-YYYY')), PARTITION Q4_2005 VALUES LESS THAN (TO_DATE('01-JAN-2006','DD-MON-YYYY')) );ERROR at line 13:
ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
尝试解决如下步骤:
1.表中字段类型更改
a order_date TIMESTAMP
创建成功
b order_date date
创建成功
2. PARTITION value 类型更改
a VALUES LESS THAN (TO_DATE('2016-06-01','YYYY-MM-DD'))
创建失败
b VALUES LESS THAN (timestamp'2016-06-01 00:00:00.000000')
创建失败
c VALUES LESS THAN (timestamp('2016-06-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'))
创建失败
d VALUES LESS THAN (cast(to_date('2016-07-01','yyyy-mm-dd') as timestamp))
创建失败
e VALUES LESS THAN (TO_TIMESTAMP_TZ('2016-06-01 00:12:56.788 -12:44', 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'))
创建成功
以上为运行结果。
下面是参数信息,在下面两台数据库中测试,以上运行结果都相同。
NLS_LANGUAGE=SIMPLIFIED CHINESE
NLS_TERRITORY=CHINA
NLS_LANGUAGE=AMERICAN
NLS_TERRITORY=AMERICA
0 0
- ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
- timestamp with time zone 和 timestamp with local time zone
- TIMESTAMP WITH TIME ZONE &TIMESTAMP WITH LOCAL TIME ZONE
- Oracle TIMESTAMP WITH TIME ZONE类型
- TIMESTAMP WITH TIME ZONE与TIMESTAMP WITH LOCAL TIME ZONE数据类型
- timestamp with local time zone类型和timestamp with time zone
- timestamp with local time zone 和 timesatamp with time zone的区别
- ocp-047-30 timestamp with local time zone 和timesatamp with time zone
- INTERVAL YEAR TO MONTH和TIMESTAMP WITH TIME ZONE 等
- JAVA获取数据库TIMESTAMP(6) WITH LOCAL TIME ZONE
- Local time zone must be set-see zic manual page
- Time with Time-zone Programming on Linux
- [每日一题] OCP1z0-047 :2013-08-26 TIMESTAMP WITH LOCAL TIME ZONE....................112
- Local time zone must be set--see zic manual page 2017
- Time Zone
- Time Zone
- 增加分区遇到ORA-14074:partition bound must collate higher...
- Resetting time zone
- Verilog中阻塞赋值和非阻塞赋值区别
- freeswitch新增app接口
- 逻辑回归
- 想搞个nas (1)
- 新手入门git: 使用git管理自己的代码
- ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
- 多线程资料
- mysql 入门基础(2)—外键、主键和索引
- 第13周项目2--动物这样叫(2)
- 阿里云Centos下安装升级Python3.5
- Java中关于 单例 多例 单线程 多线程
- Java正则、Mysql、网络编程、多线程总结
- 基变换 线性变换 矩阵
- hd 2099 整除的尾数