SQL Language (MOSC)

MOSC Banner

PUBLIC SYNONYM

edited Dec 20, 2018 4:00AM in SQL Language (MOSC) 7 commentsAnswered

Dears,

I'm installing custom application from Opentext Company called Extended ECM on E Business Suite 12.2.5 on DB 11.2.4 , one of the installation steps to create  PUBLIC SYNONYM using below statement,

"CREATE OR REPLACE PUBLIC SYNONYM fnd_env_context FOR applsys.fnd_env_context"

but it's returning below error

"Error ORA-01948: identifier's name length (42000) exceeds maximum (30)"

if i tried to create same synonym not public like " CREATE OR REPLACE SYNONYM SYSTEM.fnd_env_context FOR applsys.fnd_env_context; " it will work fine,

i tried the same on EBS 12.2.6 on 12C DB it was also working fine

kindly advise.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center