Rename Oracle Table or View

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

Solution

ALTER TABLE mytable RENAME TO othertable

In Oracle 10g also:

RENAME mytable TO othertable

Create a column that assigns a date column to current month, next month, two months, keeping the year in mind. Using SQL in Toad for Oracle
Update multiple columns based on values of another table in stored procedure
Oracle APEX apex_data_parser execution time explodes for big files
apex_data_parser file > 50MB
Oracle XE installation aborts with no error explanation
How to put the select result (column) in an array in PL/SQL
How to return NULL value from Oracle if no record is present
How to pretty format the printing of SQL queries in SQLAlchemy
Python 3.6 with pony 0.7 gives error on commit to oracle db
Sum a record with its previous not-null ordered by timestamp
ORA-28001: The password has expired
Cannot connect to Oracle (oci8) with Apache (FPM). PHP 7.x CLI is OK
How to use Oracle's LISTAGG function with a unique filter?
Installing oci8 on Centos 8 running Apache and php-fpm
Echo sqlplus command without using prompts or scripts
Talend BatchUpdateException not caught while using tOracleOutput
data type changes when using AVG in view definition
Oracle JSON_OBJECT how to have a missing key
Best way to check if SYS_REFCURSOR is empty
How can I remove backslash escaped characters from a string?
Get the minimum value from XML set of nodes using XPath
How to write pandas dataframe to oracle database using to_sql?
How to query the return value of RECORD Type of a Function in oracle-database
Oracle find tablename given an index name
Oracle - Identify rows that contain chinese characters in a CLOB column
Is it possible to target a column in table B, based on a value in table A?
Oracle SQL Developer - How to Display Percents using Color (Not Numbers)
ORA-01840: input value not long enough for date format SQL Oracle
How to see all weeks and months by number
do a select from a potentiel non existing table