Rename Oracle Table or View

oracle table-rename
Steven picture Steven · May 7, 2009 · Viewed 170.9k times · Source

What is the syntax to rename a table or view in Oracle?

Answer

Quassnoi picture Quassnoi · May 7, 2009 
ALTER TABLE mytable RENAME TO othertable

In Oracle 10g also:

RENAME mytable TO othertable

Related questions

Oracle - drop table constraints without dropping tables

I'm doing some bulk migration of a large Oracle database. The first step of this involves renaming a whole load of tables as a preparation for dropping them later (but I need to keep the data in them around for …

Read More
Rename Oracle table

What is the difference between ALTER TABLE RENAME statement and RENAME TABLE statement. ie, between Alter table old_table_name rename to new_table_name and rename table old_table_name to new_table_name.

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More