RENAMING TABLES

Oracle allows renaming of tables. The rename operation is done atomically, which means that no other thread  can access any of the tables while the rename process is running.

 To rename a table, the syntax is

Syntax :

RENAME TO ;

 Example:

Change the name of ADDR_DTLS table to ADDRESS.

RENAME ADDR_DTLS TO ADDRESS;

 Output:

Table renamed.