Partitioning in Oracle SQL Table

PARTEEK

I am trying to read an Oracle table with partitioning. I have specified a date column as a partition but I am getting the following error:

Failed to read data from table

Failed to read data from table, caused by: SQLException: ORA-12801: error signaled in parallel query server P002 ORA-01861: literal does not match format string , caused by: OracleDatabaseException: ORA-12801: error signaled in parallel query server P002 ORA-01861: literal does not match format string

fchataigner2

Hi,

DSS apparently can't use the column type of that date for partitioning. The simplest is to make a view out of the table and use the view instead of the original table in your DSS dataset. Something like

create view xxxxx as select cast(date_col as NVARCHAR(50)), ... from the_table

(or some TO_CHAR(...) with an appropriate format)