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

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: