I want to change this statment:
From tablename partition(p20130511) tb
To look two days back, so I don't have to keep on inputting the dates.
I want to change it to something like this:
From tablename partition(p (sysdate - interval '2' day)) tb
I am returning an invalid partition error when I try this. Could someone please let me know how I can do this?