hallo !
can me somebody say, how i get from this select statement max date - 7
days.


select max(to_date(substr(PARTITION_NAME,6,10),'dd.mm.yyy y')) from
dba_tab_partitions
where table_name='FRONTEND_TAB'

thank you

Oracle info: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit
Production

On 19 Okt., 11:39, sansar <uemit.uen... (AT) googlemail (DOT) com> wrote:
select max(to_date(substr(PARTITION_NAME,6,10),'dd.mm.yyy y')) - 7 from
dba_tab_partitions

where table_name='FRONTEND_TAB';

On Oct 19, 12:10 pm, sansar <uemit.uen... (AT) googlemail (DOT) com> wrote:
Can you give an example of some partition names? I'm surprised they
have dots in them.

Can you be sure the names will always match the expected format? Looks
a rather fragile approach to me.

On 20 Okt., 10:17, William Robertson <williamr2... (AT) googlemail (DOT) com>
wrote:
the partition name is:
for example= "part_19.10.2007"
when i give "" to the partitio names, that makes don't problems.

On Oct 20, 5:40 am, sansar <uemit.uen... (AT) googlemail (DOT) com> wrote:
Could it be that putting the dot in makes it look for a schema named
part_19? And putting the quotes on protects the partition name from
schema translation? Or something like that.

jg
--
@home.com is bogus.
Ad on dizwell blog post about shutting down:
http://h71028.www7.hp.com/enterprise...erproof/google