Rename Oracle Table or View

Question

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

User · Answer

In order to rename a table in a different schema, try:

ALTER TABLE owner.mytable RENAME TO othertable;

The rename command (as in "rename mytable to othertable") only supports renaming a table in the same schema.

User · Answer

ALTER TABLE mytable RENAME TO othertable   In Oracle 10g also   RENAME mytable TO othertable

User · Answer

Past 10g the current answer no longer works for renaming views  The only method that still works is dropping and recreating the view  The best way I can think of to do this would be      SELECT TEXT FROM ALL VIEWS  WHERE owner  some schema  and VIEW NAME  some view     Add this in front of the SQL returned     Create or replace view some schema new view name as       Drop the old view     Drop view some schema some view

User · Answer

To rename a table you can use   RENAME mytable TO othertable    or  ALTER TABLE mytable RENAME TO othertable    or  if owned by another schema   ALTER TABLE owner mytable RENAME TO othertable    Interestingly  ALTER VIEW does not support renaming a view  You can  however   RENAME myview TO otherview    The RENAME command works for tables  views  sequences and private synonyms  for your own schema only   If the view is not in your schema  you can recompile the view with the new name and then drop the old view    tested in Oracle 10g

User · Answer

One can rename indexes the same way   alter index owner index name rename to new name

[oracle] Rename Oracle Table or View

Examples related to oracle

Examples related to table-rename