Thanks for the quick reply. Therefore I can issue a create table my_tablename_sysdate at a command line and execute immediate and it will create a table with sysdate in the table name. Just to clarify