How to modify table name in oracle

How to modify the table name in oracle

Method 1:alter table old_table_name rename to new_table_name;

This is the simplest (personally think)

Method 2: select tname from tab; (querying all table names in the database) rename old_table_name to new_table_name;

rename can only modify the table under its own schema

Method three: create table new_table_name as select * from old_table_name;

It is equivalent to copying it into a new table

drop table old_table_name; Delete the old table

Method 4: Change it directly in PLSQL developer

Recommended tutorial: " Oracle tutorial》

The above is the detailed content of How to modify table name in oracle. For more information, please follow other related articles on the PHP Chinese website!