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?

Report message to a moderator

Previous Topic: DBVERIFY - Blocksize
Next Topic: Help:: ORA-6571 dbms_sql Dynamic sql
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 02:31:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.