devxlogo

Renaming an Oracle Table

Renaming an Oracle Table

Create a synonym to the table with a new name. A public synonym is accessible by all schemas in the database, not just the user who created the synonym.
Here is the syntax for synonym:

 create [public] synonym new_name for table_name

size=3>

devx-admin

Share the Post: