1.TNS 配置
添加配置到tnsnames.ora文件
//B4是库别名(自己随便写),mydb是唯一标识
B4=(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.236)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydbid)
)
)
**首先项(Preferences)配置从也可以从钥匙的configure
2.不配置TNS,连接数据库,并记住密码
配置方式:
Preferences->Oracle->Logon History:
3.自动提示(表、字段、包…)配置
配置方式:
Preferences->User Interface->Code Assistant: