Timestamp and timestamp with local timezone question

From: Krispyqube <kris.plakkat_at_gmail.com>
Date: 9 Dec 2005 05:36:16 -0800
Message-ID: <1134135376.369353.173390@g47g2000cwa.googlegroups.com>

Hi

Table 1 - source - UNPARTITIONED Very big table > 200M

---

col1 timestamp with local time zone,

col2      number,
col3      varchar2(10),
col4      timestamp

Table 2 - Destination - PARTITIONED - structure same as source above but no time zone

---

currently empty structure range partioned based on col1 ( timestamp)

col1 timestamp,

col2      number,
col3      varchar2(10),
col4      timestamp

PARTITION BY RANGE (col1)
(PARTITION PART_2003 VALUES LESS THAN
(TO_DATE('01-JAN-2004','DD-MON-YYYY')),

PARTITION PART_Q1_2004 VALUES LESS THAN
(TO_DATE('01-APR-2004','DD-MON-YYYY')),

PARTITION PART_Q2_2004 VALUES LESS THAN
(TO_DATE('01-JUL-2004','DD-MON-YYYY')),

PARTITION PART_Q1_2005 VALUES LESS THAN
(TO_DATE('01-OCT-2005','DD-MON-YYYY')),

PARTITION PART_Q4_2005 VALUES LESS THAN
(TO_DATE('01-JAN-2006','DD-MON-YYYY'))
Now I want to pick a subset and populate a small portion of my partiton say PART_Q4_2005

i am using the

insert /*+ APPEND */ into table2
select (/*+ parallel (table1, 4) * from table1 where col1 > to_date('30-sep-2005', 'dd-mon-yyyy') ;

Insert /*+ APPEND */ into TABLE2
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P002 ORA-01843: not a valid month

is this a problem with conversion from timestamp LTZ to timestamp or do i nead to do some kind of cast or to_timestamp functions . I tried them but the error seem to pop up on the insert . if you run the latter part just the selects they work fine

I tried specifying the columns but still get the error

thanks for any help or insight

regds
Kris Received on Fri Dec 09 2005 - 07:36:16 CST