SQL*Plus for windows is dying

Back in 2000, with Oracle 8, if you wanted to install Oracle in a desktop, Windows was your choice as Linux was only beginning. Together with it came SQL*Plus for Windows.

SQL*Plus for Windows

More recently with Oracle 11g, SQL*Plus for Windows has been removed from the Windows installation (the DOS version remains).

For those like me that will want to use it a little bit longer, you can copy the sqlplusw.exe executable file from a 10.2 home and paste it in the BIN folder of the 11g home. There’s a catch: you’ll need to copy the oraclient11.dll in this same folder and paste it renamed as oraclient10.dll, which is the one sqlplusw.exe wants.

And that’s it. Now you can double-click it, create a shortcut, or if using Windows 7, pin it to the taskbar as I did 🙂 .

This entry was posted in Oracle and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s