How Do You Rename A Table In Oracle?
• Find out which version of Oracle you have installed. Plan to use at least version 8i of Oracle. This is the earliest version that supports the function that permits renaming a table in the program. • Follow the requirements in order to rename a table in Oracle. • One of the major pre-requisites is that the table must be in your own schema. • There are also certain types of synonyms that you can not rename in Oracle. These include public synonyms as well as types with dependent tables. • Review the original syntax for the table that you wish to rename. You will need to know the table name in order to enter the command that allows you to alter it. • Determine if there are any dependencies prior to renaming a table in Oracle. If you are unsure of dependencies, you can use the “TOAD” tool to check the table’s status. • First, select the table you plan to rename in the schema browser, • Then find the “Used By” tab. Any dependencies will be listed in this section. • Choose a new table name
