Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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:
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)