Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Editionable view SYNONYM issue

Rajesh123Jan 24 2018 — edited Jan 24 2018

Hi All,

I have Editionable view created like below.

CREATE OR REPLACE EDITIONABLE VIEW

as

selct columns

FROM GL.GL_LEDGERS# SOBS

synonym which is created like this.

CREATE SYNONYM APPS.GL_LEDGERS FOR GL.GL_LEDGERS#;

But after few days , don't know why SYNONYM is deleted.

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2018
Added on Jan 24 2018
9 comments
3,514 views