Oracle Service Name properties file for SchemasSpy

commandline.ps1

PS C:\mydocs\Downloads> java -jar .\schemaSpy_5.0.0.jar
*** Required parameter '-o' was not specified. ***

Usage:
 java -jar .\schemaSpy_5.0.0.jar [options]
   -t databaseType       type of database - defaults to ora
                           use -dbhelp for a list of built-in types
   -u user               connect to the database with this user id
   -s schema             defaults to the specified user
   -p password           defaults to no password
   -o outputDirectory    directory to place the generated output in
   -dp pathToDrivers     optional - looks for JDBC drivers here before looking
                           in driverPath in [databaseType].properties.
Go to http://schemaspy.sourceforge.net for a complete list/description
 of additional parameters.

Sample usage using the default database type (implied -t ora):
 java -jar schemaSpy.jar -db mydb -s myschema -u devuser -p password -o output

PS C:\mydocs\Downloads> java -jar .\schemaSpy_5.0.0.jar -t orathin_servicename -u user -p password -host host -o output_directory -db database.world -dp jdbcdriver.jar -all

orathin_servicename.properties

#
# see http://schemaspy.sourceforge.net/dbtypes.html
# for configuration / customization details
#

description=Oracle with Thin Driver

# gory details in ora.properties:
extends=ora

connectionSpec=jdbc:oracle:thin:@//<host>:<port>/<db>
host=database host
port=port on database host
db=database SID as known on host