This content has been marked as final. Show 2 replies
DBMS_XMLSCHEMA.GENERATESCHEMA works on a set of existing SQL object types and/or collections, it builds the schema out of this structure and maps SQL datatypes to XML datatypes.
If all the input you have is an XML instance document, that won't help you.
You'll need a 3rd party tool supporting schema inference, e.g. XMLSpy or Oxygen (not free), or MS XML Schema Definition Tool (part of the .NET SDK), or another free online converter.