Help Renaming Tables!!!

I need to create a process that renames a table that is 15 days old to todays date.
This is what I have tried and can not make it work:

Alter Table
(select 'OCC'|| (to_char(sysdate,'YYYYMMDD') - 15) || 'DAILY' into t from
dual)
Rename To
(select 'OCC'|| (to_char(sysdate,'YYYYMMDD')) || 'DAILY' into t from dual);

Can anyone tell me how to make this work?

Thanks
Tommy Received on Mon Aug 14 2000 - 15:32:14 CDT