Guest User

Untitled

a guest
Aug 13th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. Oracle: Extract Graphical Database Representation
  2. SET JDBC_ORACLE_JAR=C:oracleproduct10.2.0client_1jdbclibojdbc14.jar
  3. SET CONNECTION_USERNAME=hr
  4. SET CONNECTION_PASSWORD=hr
  5. SET TNS_DATABASE_NAME=orcl
  6. SET SCHEMA_NAME=HR
  7. SET TABLE_NAME='EMP'
  8. SET OUTPUT_NAME=HR_EMP
  9.  
  10. 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
  11.  
  12. 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