0

Is there any way to get the type or general table/view definition from an Oracle database synonym? Are special rights neccessary to get it or is it even impossible and I have to check the real source database? I am especially interested in the column datatypes and length of the type (where it matters).

Thanks a lot in davance.

Mil
  • 756
  • 2
  • 11
  • 30
  • It depends... are you able to query the view/table _without_ the synonym? – Ben Apr 18 '13 at 13:38
  • SQL*Plus command DESC[RIBE] works with synonyms. What more information do you need? – APC Apr 18 '13 at 13:41
  • Ben, no not at the moment. Thanks APC, yes these are the informations I needed. If you like to write this as answer, I will close the question with that. – Mil Apr 19 '13 at 11:43

0 Answers0