Remove bloated Oracle clients and use PL/SQL

Looking at the fat Oracle client on my computer, I almost never used anything like the Enterprise Manage Console. Its existence is a waste of my computer space.

So I checked on the Internet to see if I could unmount the ORACLE client and use PL/SQL normally. It turns out that this method is available (I did my research and tried it ).

Step 1:

First go to oracle

Http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

Download this compressed package.

 

 

Step 2:

Decompress the package to a directory, create a Network folder under the directory, create ADMIN under the Network folder, and copy the original sqlnet. ora and tnsnames. ora to the ADMIN directory.

 

 

Step 3: Set PL/SQL

TOOLS-> preferences-> connection

Set these two items to the directory that was extracted from the file just now.

 

 

Step 4: uninstall the oracle client

If you are running windows 7, first enable the unistaller attribute, set it to run in windows xp SP3 compatible mode, and then enable uninstaller as an administrator.

 

 

Step 5: test whether it is successful

Open PL/SQL, connect to a database, and execute an SQL statement,

 

Successful.

 

This can reduce the disk space by about MB. Absolute value.

 

 

 

In addition, we recommend a replacement for PowerDesinger, which is too bloated. My daily work only needs to read PDM.

This alternative is PDMReader. .

 

This can save about MB of hard disk space.

 

 

 

About Myeclipse and Eclipse

Myeclipse is too large, and I do not like this IDE with more than MB.

I usually mix NotePAD ++ and eclipse.

Today, I think this Myeclipse on the computer is ugly and huge. So I always want to uninstall it.

However, using eclipse to completely replace existing Myeclipse requires a great deal of trouble.

After using eclipse, the first step is to complete the migration of my work environment.

First, install the Server plug-in for Oracle welogic.

(Eclipse comes with Apache Tomcat, but does not have webLogic plug-in)

After installation, configure the configuration according to the version. Finally, test it.

Then install an SVN plug-in. You can. It's okay to use it for work.

 

This saves about MB of space.