Home » RDBMS Server » Server Administration » HELP rename table
HELP rename table [message #369319] Mon, 14 August 2000 14:13
tommy
Messages: 22
Registered: July 2000
Junior Member
I need to rename tables daily... using the system date. I have tried this, but it does not work:

ALTER TABLE (select "OCC" ||(to_char(sysdate - 15,'YYYYMMDD')) || "DAILY" from dual)
RENAME TO (select "OCC" || (to_char(sysdate,'YYYYMMDD')) || "DAILY" from dual);

Can anyone show what I am doing wrong?
Previous Topic: DBVERIFY - Blocksize
Next Topic: Help:: ORA-6571 dbms_sql Dynamic sql
Goto Forum:
  


Current Time: Fri Oct 30 02:05:45 CDT 2020