The use of synonyms

Recently, the AP personnel had a requirement to transfer a table from an obsolete system to a new system for use. exp/IMP was used quickly. He also corrected the problem.ProgramAnd a new version is released on some clients. however, the development director suddenly asked the table transferred from the old database to add a prefix before the table name to indicate the difference. the program is modified quickly, but cannot be released because the table name cannot be changed to a new one. Otherwise, the published program cannot be used and the release takes time.

The developer needs to copy this table with a new name. after all the programs are released, delete the old table. it sounds like it can solve the problem, but it is very troublesome and a waste of space.

Today, I suddenly think of a way to get a new table synonym for the old table. The old program can be used, and the new program can also be used. after the program is updated, rename the table. really stupid.