Oracle Error Help

[cherlapalli_jailer]

[quote name='SUbba LIngam' timestamp='1373917950' post='1303954954']


existing data chusa, chaala varaku same unnayi both table name and synonym name

em cheyamantaaru
[/quote]Add dn name in front of tbl name only

[SUbba LIngam]

[quote name='cherlapalli_jailer' timestamp='1373918070' post='1303954963']
Add dn name in front of tbl name only
[/quote]
, I didnt get you

[padmasri123]

synonym name change chey dude ....should not be the same table name

[peru_edaite_enti]

Synonym and table name can be the same... No issues in that

[nexus]

[quote name='CBZ' timestamp='1373918889' post='1303955035']
Synonym and table name can be the same... No issues in that
[/quote]

public synonym can be same as object name but not private synonyms.

[peru_edaite_enti]

[quote name='nexus' timestamp='1373919362' post='1303955083']


public synonym can be same as object name but not private synonyms.
[/quote]
I see that synonym as public

[SUbba LIngam]

Thanks guys,,,,,,,, the issue is solved, its not the issue with the synonym name though.
Anyways thanks for replies.

[nexus]

[quote name='CBZ' timestamp='1373919443' post='1303955092']
I see that synonym as public
[/quote]

Agreed. I doesn't make any sense to create a private synonym with the same object name unless you are referencing an object in a remote database over a database link. I should be thinking of something while typing.

[peru_edaite_enti]

[quote name='SUbba LIngam' timestamp='1373919801' post='1303955119']
Thanks guys,,,,,,,, the issue is solved, its not the issue with the synonym name though.
Anyways thanks for replies.
[/quote]

what did you do to solve this? issue ochinappudu question esi solve aiyyaka utti thanks cheptam endi vaay??

[quote name='nexus' timestamp='1373919805' post='1303955120']

Agreed. I doesn't make any sense to create a private synonym with the same object name unless you are referencing an object in a remote database over a database link. I should be thinking of something while typing.
[/quote]
no issues..

[SUbba LIngam]

[quote name='CBZ' timestamp='1373919967' post='1303955143']
what did you do to solve this? issue ochinappudu question esi solve aiyyaka utti thanks cheptam endi vaay??

[/quote]
upgrade project mama, script sarigga run cheyanattu unnaru during migration.
View lo vachesi actual ga 11 fields unnayi but behind SQL lo matram just 10 fields query chestundi and that caused the issue.
SQL modify chesi build chesaaka its working fine.

[peru_edaite_enti]

[quote name='SUbba LIngam' timestamp='1373920219' post='1303955173']
upgrade project mama, script sarigga run cheyanattu unnaru during migration.
View lo vachesi actual ga 11 fields unnayi but behind SQL lo matram just 10 fields query chestundi and that caused the issue.
SQL modify chesi build chesaaka its working fine.
[/quote]

ohkies.. tfs...