What is Oracle RENAME Table ?

• RENAME TABLE allows you to rename an existing table in any schema.
• Use the RENAME statement to rename a table, view, sequence, or private synonym.
• Oracle Database automatically transfers integrity constraints, indexes, and grants on the old object to the new object.
• Oracle Database invalidates all objects that depend on the renamed object, such as views, synonyms, and stored procedures and functions that refer to a renamed table.

Syntax

RENAME TABLE table_Name to new Table_Name 

click below button to copy the code. By - oracle tutorial - team

Copy Code

Example:

RENAME emp_dtl to wikitechy;

click below button to copy the code. By - oracle tutorial - team

Copy Code

oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , plsql

OUTPUT:

1. Rename is the keyword.
2. emp_dtl is the old table name.
3. wikitechy is our new table name.
4. From the given RENAME STATEMENT the table has been changed from old table name to new table name.

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , sql tutorial for beginners , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning