Monday, July 27, 2009

how to rename a table in oracle (sqlplus)

alter table
   table_name
rename to
   new_table_name;

2 comments:

Anonymous said...

if that does not work try....

rename old_table_name to new_table_namme ;

unsigned_nerd said...

Thanks, Anonymous ; )

Post a Comment