Configuring the native-mounted Oracle in the Tnsnames.ora file

First of all, thanks to these two users: http://zhidao.baidu.com/link?url=eGYeoEa-EhQdVitSGqjE36uNfVmEsryXH1WUjPue6YvArDSx-Y1N9_ Rd9hx6vh-nklyevkcctamh1x28fi1hoq

Introduction:

I created a connection called "OA" in the Oracle SQL Developer tool, then landed Plsql Developer, imported a table "T_dept" from the local, opened Oracle SQL Developer, and found that not only the "OA" connection was inserted into the table "T_dept", and in the other connection "cart" also inserted the table "T_dept", so I think this must be because the login Plsql developer not specified to the "OA" connection caused by, then I landed the interface is this:

Attached--My Oracle SQL developer Tool interface at the time:

How can I connect to Oracle's specified connection when Plsql developer is logged in?

This requires configuring the Tnsnames.ora file.

To configure the Tnsnames.ora file step:

1. Locate the Tnsnames.ora file (Note: This file is in the directory where Oracle is installed, not the directory where Plsql developer is installed! ）

My Tnsnames.ora file address:

2. Configuration: Basically copy and paste just fine, as shown, I only modified the connection name "OA", the other is copy MYORCL.

It's done. At this time login Plsql Developer, you can see the new "OA" Connection:

Note: My OA connection was created in the Oracle SQL Developer tool with a test_table1 table, so open the OA connection and there will be this table:

You can configure the Tnsnames.ora file directly, and then open the Plsql developer for a variety of operations without the Oracle SQL Developer tool (although I feel this tool is good, but I do not know how to import SQL files through it?). ）

Configuring the native-mounted Oracle in the Tnsnames.ora file