We need to backup one oracle table every week before it is dropped. I wrote one scripts as:
CREATE TABLE a1backup
AS SELECT * FROM al;
I need to run this as cron every week. My question is how to specify the name of backup table(table name + date)? Like albackup03212003, a1backup31042003, ….