Rename View in Oracle

sql oracle rename sql-view
Gunnar picture Gunnar · Jun 25, 2012 · Viewed 29.8k times · Source

Possible Duplicate:
Rename Oracle Table or View

I know you can use

ALTER TABLE oldName RENAME TO newName;

to rename a table, but "ALTER" doesn't work with renaming views.

What's the syntax for renaming Views in Oracle (i'm using 11g if that makes any difference)?

Answer

Sergey Kalinichenko picture Sergey Kalinichenko · Jun 25, 2012

You can use RENAME on views, like this:

Use the RENAME statement to rename a table, view, sequence, or private synonym.

RENAME old_view_name to new_view_name

Related questions

Re-order columns of table in Oracle

I have a table with 50+ columns and I need to swap the order of the first two columns. What is the best way to accomplish this using Oracle? Assume the table name is ORDERDETAILS and as it is, the first …

Read More
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
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