Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Oracle: Extract Graphical Database Representation
- SET JDBC_ORACLE_JAR=C:oracleproduct10.2.0client_1jdbclibojdbc14.jar
- SET CONNECTION_USERNAME=hr
- SET CONNECTION_PASSWORD=hr
- SET TNS_DATABASE_NAME=orcl
- SET SCHEMA_NAME=HR
- SET TABLE_NAME='EMP'
- SET OUTPUT_NAME=HR_EMP
- java -jar schemaSpy_5.0.0.jar -dp %JDBC_ORACLE_JAR% -db %TNS_DATABASE_NAME% -o schemaOutput%OUTPUT_NAME% -u %CONNECTION_USERNAME% -p %CONNECTION_PASSWORD% -i %TABLE_NAME%.* -schemas %SCHEMA_NAME% -hq -noviews -loglevel severe
- java -jar schemaSpy_5.0.0.jar -dp %JDBC_ORACLE_JAR% -db %TNS_DATABASE_NAME% -o schemaOutput%OUTPUT_NAME% -u %CONNECTION_USERNAME% -p %CONNECTION_PASSWORD% -schemas %SCHEMA_NAME% -hq -noviews -loglevel severe
Add Comment
Please, Sign In to add comment