What is the Difference Between Oracle lnstant Client and Oracle Client ? Could you explain me ? Thanks
Asked
Active
Viewed 2.0k times
1 Answers
12
Oracle client comes with an installer and a lot of executable like sqlplus, tnsping, it's complete and huge.
Oracle Instant client is a basic lightweight client which can be unzipped in a location without any installation, it contains only the communication layer to be able to connect to oracle. It can be extended by adding for example sqlplus which ships as a separate executable. When using Instant Client, just unzip it to a location, set your ORACLE_HOME environment variable to this location and you are ready to go.

Moudiz
- 7,211
- 22
- 78
- 156

Cyrille MODIANO
- 2,246
- 2
- 21
- 33
-
Regarding 1. When you run the installer you can select and unselect various components you like to install or not. So, the scale of "complete and huge" depends on your selections. – Wernfried Domscheit Sep 29 '17 at 08:06
-
You're right, when I say complete and huge I talk about the size of the client source itself, a few MB for the instant client, a few hundred for the full client. – Cyrille MODIANO Sep 29 '17 at 08:09
-
Which one do you prefer , instant or client for huge project? l – Melo Sep 29 '17 at 13:37
-
2Instant Client 19.3 is a zip with 241 MB! The sole "oraociei19.dll" is 200 MB. "lightweight" is a generous compliment :-) – Alex 75 Oct 14 '19 at 14:26
-
4A little confused about the ORACLE_HOME part since the installation instructions do not mention that.https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html#ic_winx64_inst – IEnjoyEatingVegetables Jan 27 '21 at 19:53