使用ERWin工具为Oracle数据库生成ERD时应使用的连接字符串格式是什么? [英] What is the format of connection string that should be used while using ERWin tool for generating ERD for an Oracle database?

问题描述

我一直在尝试为某些oracle数据库生成ERD.当我通过动作"->逆向工程"选项执行此操作时，我得到了一个部分，要求我提供连接字符串.但是我不确定如何指定数据库及其详细信息的格式. 有人可以帮我吗?

I have been trying to generate an ERD for some oracle database. While I am doing this via 'Actions'->'Reverse Engineering' option, I get a section that asks me for a connection string. But I am unsure of the format about how we can specify the database and its details. Could someone please help me with this?

谢谢 Pradeep

Thanks Pradeep

推荐答案

我正在使用Erwin 7.3.8连接Oracle 11g模式.当我使用 oracle tnsnames 字符串格式时，该连接对我有效:

I am using Erwin 7.3.8 to connect on a Oracle 11g schema. The connection works from me when I use the oracle tnsnames string format:

例如:

(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = **database-server**)(PORT = **database-server-port**))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = **service-name-if-exists**)))

复制为一行命令，然后粘贴到连接字符串字段中.

Copy as a one line command and paste in the Connection String field.

干杯！

这篇关于使用ERWin工具为Oracle数据库生成ERD时应使用的连接字符串格式是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！