Range partitioning in source metadata

system · October 15, 2009, 9:49am

Hi,

I have a view as source of DS job.
I want to add partitions to the source metatdata on a varchar column.

I added

Qrt1 : ‘DEC-95’
Qrt2 : ‘APR-96’

When i say apply, it gives the folowing error:

Range value of Partition ‘Qtr1’ is greater than Range value of partition ‘Qrt2’.

Please help me with this.

suma_ys (BOB member since 2009-06-12)

system · October 15, 2009, 11:23am

Is this is DI/DS question, or really an Oracle/database question?

dnewton (BOB member since 2004-01-30)

system · October 15, 2009, 11:40am

I think he answered his own question - it is a varchar column - collation sequence ‘D’ comes after ‘A’ - it is not a date column

speed12 (BOB member since 2004-09-27)

system · October 20, 2009, 8:58am

Thanks!

suma_ys (BOB member since 2009-06-12)