alter table rename dynamically
CREATE TABLE GTEST_OR(X NUMBER)
I am trying to dynamically rename this table, I get ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations
can we not alter table dynamicallly and apped new table name with current time ?
begin
execute immediate 'ALTER TABLE GTEST_OR
RENAME TO DUP||to_char(sysdate,''YYYYMMDDHH24MISS'')';
end;
/