Attached to this page is a dump in SQL of the schema for the glastgen tablespace used by Fermi LAT web applications. The tool I used is pretty thorough in that it gets tables, sequences, packages, constraints and triggers. The format is slightly inconveient in that all constraints including primary key constraints are dumped as ALTER TABLE statments instead of code inside the table definitions. This exposes the Oracle-generated names.
The tool I used was a Python script called DescribeSchema, part of a package call cx_OracleTools. The package contains many other useful scripts which manipulate Oracle databases. This package with its dependencies is available in the FlightOps Software PROD installation. Once you set up the environment the scripts are accessible from ${ISOC_INSTALLROOT}/share/cx_OracleTools-7.4.
cx_OracleTools utility scripts
cx_Oracle database driver for Python
cx_Logging
cx_PyGenLib
cx_PyOracleLib